Skip to content
#

SQLite

sqlite logo

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.

Here are 5,055 public repositories matching this topic...

dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

JeanGolang
JeanGolang commented Feb 7, 2017

Hello Philip!
I think there is an issue with this part of the code of rqlite (store/store.go).

func (s *Store) Database(leader bool) ([]byte, error) {
	if leader && s.raft.State() != raft.Leader {
		return nil, ErrNotLeader
	}
	// Ensure only one snapshot can take place at once, and block all queries.
	s.mu.Lock()
	defer s.mu.Unlock()

	f, err := ioutil.TempFile("", "rqlilte-snap-
sgrif
sgrif commented Feb 18, 2020

Given that we support CURRENT_TIMESTAMP, the lack of CURRENT_DATE feels like an omission. While you can hack it with date(now), I keep finding myself wishing there was a direct way to reference this. Given that now means CURRENT_TIMESTAMP, I think there's precedent for today meaning CURRENT_DATE. This is supported by all backends we support (and is in the ISO standard I believe).

rathboma
rathboma commented Jun 12, 2020

For those using the AppImage and not installing normally into their app tray it'd be nice to provide a .desktop file that points to their local copy of the app image.

A PR here should include:

  1. The text of the .desktop file, along with locations to sub out the path of the app image
  2. Instructions on where to put the .desktop file inside the user's home directory
  3. Some manual testing
jplatte
jplatte commented Jul 24, 2020

Running cargo sqlx prepare from a directory that isn't actually a cargo project, when .env exists in the same directory as would usually be the case and DATABASE_URL isn't in the environment, complains about the missing DATABASE_URL and exits before notifying the user that they are running prepare in the wrong directory. It should probably check for the existence of Cargo.toml or (total

Created by D. Richard Hipp

Released August 17, 2000

Website
www.sqlite.org
Wikipedia
Wikipedia

Related Topics

sql
You can’t perform that action at this time.