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 7,493 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

prisma
binary64
binary64 commented Aug 2, 2021

Bug description

On windows, I run prisma format and note the unusual file ending. The lines are all LF, but the very last line is CRLF.

This causes issue on my Linux CI where it formats it ending in LF's only, causing a diff to occur and the build to fail.

How to reproduce

  1. On windows do prisma format
  2. Open in HxD or similar
  3. See attached:

![image](https://user-images.g

directus
rijkvanzanten
rijkvanzanten commented Oct 8, 2021

Right now, the API will (correctly) error with a foreign key constraint violation when deleting a user that has one or more uploaded images. I think it makes more sense to nullify the 'uploaded_by' field when you delete the user.

When implementing this in a new migration, we should also look into any other system tables that have a foreign key constraint to directus_users to ensure they all rel

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-

Created by D. Richard Hipp

Released August 17, 2000

Website
www.sqlite.org
Wikipedia
Wikipedia

Related Topics

sql