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

directus
mlbullett
mlbullett commented Feb 5, 2021

Bug Report

Hi there. Absolutely love your collective work but have discovered a small bug regarding broken thumbnails in the Project Settings panel (and possibly elsewhere).

Environment

Fresh Directus 1-click App on DigitalOcean
Ubuntu 20.04 LTS
Postgres 12.5
Directus 9.0.0-rc.34
PM2 4.5.1
Caddy 2.3.0
Tested on Brave 88.1.19.90 and Chromium 87.0.4280.141

Steps to Reproduce

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")]

   
sify21
sify21 commented Sep 4, 2020

I'm using postgresql, sqlx="0.4.0-beta.1".
My struct is like:

#[derive(Serialize, Deserialize, Debug, PartialEq, FromRow)]
pub struct Struct1 {
    pub a1: i16,
    pub a2: String,
    pub a3: Option<String>,
    pub a4: Option<serde_json::Value>,
    pub a5: serde_json::Value,
    pub a6: Option<String>,
    pub a7: Option<serde_json::Value>,
    pub a8: Option<f32>,
    pub a9: 
adrianvoica
adrianvoica commented Oct 7, 2020

Hello Maurits,
This is more of a request than it is an actual issue, but I think the value in this request is really high (for newcomers, especially - but not limited to).
Could you please add a COMPLETE application example of using the API (with user authentication, maybe even with the user-creation SQL script, table authorization, etc).
This would be really really helpful as a quickstart /

Created by D. Richard Hipp

Released August 17, 2000

Website
www.sqlite.org
Wikipedia
Wikipedia

Related Topics

sql