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,665 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-
dawid-nowak
dawid-nowak commented Nov 29, 2020

Is it supported at the moment to have 'serialize_as' and 'deserialize_as' on the single field in the sturcture as shown below?

#[derive(Identifiable, Queryable, PartialEq, Debug, Serialize, Deserialize, Insertable)]
#[table_name = "blah"]
pub struct Data {

    #[diesel(serialize_as = "SensitiveStringSerializer")]   
    #[diesel(deserialize_as = "SensitiveStringDeserializer")]

   
abonander
abonander commented Dec 2, 2020

Currently, the macros expect SQLX_OFFLINE to equal "true" (case insensitive) to force offline mode. This is fine, but environment variables that can switch something on or off typically also accept 0 as false and 1 as true.

This should be a relatively easy fix, the code is here: https://github.com/launchbadge/sqlx/blob/master/sqlx-macros/src/query/mod.rs#L40

I would also prefer to use

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.