SQLite

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,765 public repositories matching this topic...
-
Updated
Dec 31, 2020 - TypeScript
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
-
Updated
Dec 30, 2020 - C++
Makes it just that little nicer to use
-
Updated
Dec 29, 2020 - JavaScript
-
Updated
Oct 10, 2020 - Java
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-
-
Updated
Apr 3, 2020 - Go
-
Updated
Dec 24, 2020 - JavaScript
-
Updated
Dec 27, 2020 - Go
-
Updated
Dec 24, 2020 - PHP
It looks like there are hints at connecting directly with a socket path https://github.com/beekeeper-studio/beekeeper-studio/blob/9ff3131030057364f31f3034677fc0f6a9bd48b5/src/lib/connection-provider.js#L23
But there does not appear to be anything in the UI to indicate
-
Updated
Dec 31, 2020 - Swift
-
Updated
Dec 31, 2020 - Python
When creating a dump from OpenEdge (Progress) database, boolean fields will contain the following values:
- "yes" - true
- "no" - false
- "?" - null. I am assuming that everything else than yes/no is null here.
In my experience, far and away the primary reason to use DatabaseError::downcast_ref()
is to check the constraint name. It would be nice not to have to downcast, though:
https://github.com/launchbadge/sqlx/blob/master/sqlx-core/src/error.rs#L146
pub trait DatabaseError: ... {
// existing methods omitted
/// Returns the name of the constraint that triggered the error, if
-
Updated
Dec 15, 2020 - Go
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
Issue Description
While using model.bulkCreate, as we pass the options, an object which contains transaction, it comes modified after the execution
What are you doing?
We have called bulk