Curation by mkidd 2 years, 6 months ago for query SQLite
Original results
-
https://sqlite.org/ — found via Mwmbl
SQLite Home Page
The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050 . SQLite da…
-
http://sqlite.org/fts3.html — found via Mwmbl
SQLite FTS3 and FTS4 Extensions
FTS3 and FTS4 are SQLite virtual table modules that allows users to perform full-text searches on a set of documents. The most common (and effective) way …
-
https://sqlite.org/src/timeline — found via Mwmbl
SQLite: Timeline
In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so tha…
-
http://www.sqlite.org/src/ — found via Mwmbl
SQLite: Documentation
This repository contains the complete source code for the SQLite database engine . Some test scripts are also included. However, many other test scripts a…
-
https://sqlite.org/cli.html — found via Mwmbl
Command Line Shell For SQLite
The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL…
-
https://sqlite.org/althttpd/ — found via Mwmbl
Althttpd: The Althttpd Webserver
Althttpd is a simple webserver that has run the https://sqlite.org/ website since 2004. Althttpd strives for simplicity, security, and low resource usage.…
-
https://sqlite.org/tclsqlite.html — found via Mwmbl
The Tcl interface to the SQLite library
The SQLite library is designed to be very easy to use from a Tcl or Tcl/Tk script. SQLite began as a Tcl extension and the primary test suite for SQLite i…
-
https://sqlite.org/forum/forumpost/dcba8698b2 — found via Mwmbl
SQLite Forum: Country-coding from Lat/Long, using GeoPoly and/or…
I have tables of geometrical objects, with Latitude/Longitude coordinates, and we'd like to filter that data by countries . Given a set of polygons fo…
-
https://sqlite.org/forum/forumpost/3ad538a776?t=h — found via Mwmbl
SQLite Forum: CHECK violation during table definition ignored, n…
SQLite does not evaluate check constraints until you actually do an INSERT or UPDATE. Follow-up: I tried this same thing on MySQL 5.6, PostgreSQL 9.3, Ora…
-
https://www.sqlite.org/testing.html — found via Mwmbl
How SQLite Is Tested
The reliability and robustness of SQLite is achieved in part by thorough and careful testing. As of version 3.39.0 (2022-06-25), the SQLite library consis…
-
https://sqlite.org/forum/forumpost/183697d77e?t=h — found via Mwmbl
SQLite Forum: sqlite-tools-win32-x86-3310100.zip won't work rope…
Hello, I downloaded https://www.sqlite.org/2020/sqlite-tools-win32-x86-3310100.zip the sqlite-tools-win32-x86-3310100.zip option, on windows 10 and when I…
-
https://sqlite.org/c3ref/io_methods.html — found via Mwmbl
OS Interface File Virtual Methods Object
Every file opened by the sqlite3_vfs.xOpen method populates an sqlite3_file object (or, more commonly, a subclass of the sqlite3_file object) with a poin…
-
http://system.data.sqlite.org/ — found via Mwmbl
System.Data.SQLite: Home
System.Data.SQLite was started by Robert Simpson. Robert still has commit privileges on this repository but is no longer an active contributor. Developmen…
-
https://www.sqlite.org/datatype3.html — found via Mwmbl
Datatypes In SQLite
Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of …
-
https://www.sqlite.org/howtocorrupt.html — found via Mwmbl
How To Corrupt An SQLite Database File
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle …
-
https://www.sqlite.org/pragma.html — found via Mwmbl
Pragma statements supported by SQLite
The PRAGMA statement is an SQL extension specific to SQLite and used to modify the operation of the SQLite library or to query the SQLite library for inte…
-
https://www.sqlite.org/custombuild.html — found via Mwmbl
Custom Builds Of SQLite
For most applications, the recommended method for building SQLite is to use the amalgamation code file, sqlite3.c , and its corresponding header file sqli…
-
https://sqlite.org/althttpd/info/32df1a61707616bc — found via Mwmbl
Althttpd: Check-in [32df1a6170]
Reworked GetMimeType() to allow for type-specific flags such as eliding the charset from Content-Type (necessary for wasm). This also fixes the duplicate …
-
https://www.sqlite.org/fasterthanfs.html — found via Mwmbl
35% Faster Than The Filesystem
The performance difference arises (we believe) because when working from an SQLite database, the open() and close() system calls are invoked only once, wh…
-
https://www.sqlite.org/lang_dropview.html — found via Mwmbl
DROP VIEW
The DROP VIEW statement removes a view created by the CREATE VIEW statement. The view definition is removed from the database schema, but no actual data i…
-
https://sqlite.org/forum/forumpost/ae49298964022f5c7555e97f2c112dd1 — found via Mwmbl
SQLite Forum: [ANN] SQLite in the Cloud: The Future of Lightweig…
We are excited to announce the launch of a beta version of our new SQLite Cloud service. This service allows you to easily and securely share your SQLite …
-
https://github.com/sqlite/sqlite/blob/master/src/malloc.c — found via Mwmbl
sqlite/malloc.c at master · sqlite/sqlite · GitHub
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behav…
-
https://www.sqlite.org/c3ref/get_autocommit.html — found via Mwmbl
Test For Auto-Commit Mode
The sqlite3_get_autocommit() interface returns non-zero or zero if the given database connection is or is not in autocommit mode, respectively. Autocommit…
-
https://www.sqlite.org/lang_createtable.html — found via Mwmbl
CREATE TABLE
Every CREATE TABLE statement must specify a name for the new table. Table names that begin with "sqlite_" are reserved for internal use. It is an error to…
-
https://www.sqlite.org/cgi/docsrc/info/7652db76ff667908 — found via Mwmbl
Documentation Source Text: Check-in [7652db76ff]
}</tclscript> <tcl>hd_fragment csv {CSV import} {.import}</tcl> <h2>Importing CSV files</h2> <p>Use the ".import" command to import CSV (comma separated v…
-
https://news.ycombinator.com/item?id=31340942 — found via Mwmbl
Just clarifying - D1 without read replicas is strongly consisten…
Does SQLite support some kind of monotonic transaction id that can be used as a cache coherency key? Say a client writes a new record to the database whi…
-
http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html?highlight=check_same_thread — found via Mwmbl
SQLite — SQLAlchemy 2.0 Documentation
SQLite does not have built-in DATE, TIME, or DATETIME types, and pysqlite does not provide out of the box functionality for translating values between Pyt…
-
https://stackoverflow.com/questions/1719610/determine-if-sqlite3-transaction-is-active — found via Mwmbl
sqlite - Determine if SQLite3 transaction is active - Stack Over…
Determine the transaction state of a database int sqlite3_txn_state(sqlite3*,const char *zSchema); The sqlite3_txn_state(D,S) interface returns the curren…
New results
-
https://sqlite.org/ — found via Mwmbl
SQLite Home Page
The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050 . SQLite da…
-
http://sqlite.org/fts3.html — found via Mwmbl
SQLite FTS3 and FTS4 Extensions
FTS3 and FTS4 are SQLite virtual table modules that allows users to perform full-text searches on a set of documents. The most common (and effective) way …
-
https://sqlite.org/src/timeline — found via Mwmbl
SQLite: Timeline
In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so tha…
-
http://www.sqlite.org/src/ — found via Mwmbl
SQLite: Documentation
This repository contains the complete source code for the SQLite database engine . Some test scripts are also included. However, many other test scripts a…
-
https://sqlite.org/cli.html — found via Mwmbl
Command Line Shell For SQLite
The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL…
-
https://sqlite.org/althttpd/ — found via Mwmbl
Althttpd: The Althttpd Webserver
Althttpd is a simple webserver that has run the https://sqlite.org/ website since 2004. Althttpd strives for simplicity, security, and low resource usage.…
-
https://sqlite.org/tclsqlite.html — found via Mwmbl
The Tcl interface to the SQLite library
The SQLite library is designed to be very easy to use from a Tcl or Tcl/Tk script. SQLite began as a Tcl extension and the primary test suite for SQLite i…
-
https://sqlite.org/forum/forumpost/dcba8698b2 — found via Mwmbl
SQLite Forum: Country-coding from Lat/Long, using GeoPoly and/or…
I have tables of geometrical objects, with Latitude/Longitude coordinates, and we'd like to filter that data by countries . Given a set of polygons fo…
-
https://sqlite.org/forum/forumpost/3ad538a776?t=h — found via Mwmbl
SQLite Forum: CHECK violation during table definition ignored, n…
SQLite does not evaluate check constraints until you actually do an INSERT or UPDATE. Follow-up: I tried this same thing on MySQL 5.6, PostgreSQL 9.3, Ora…
-
https://www.sqlite.org/testing.html — found via Mwmbl
How SQLite Is Tested
The reliability and robustness of SQLite is achieved in part by thorough and careful testing. As of version 3.39.0 (2022-06-25), the SQLite library consis…
-
https://sqlite.org/forum/forumpost/183697d77e?t=h — found via Mwmbl
SQLite Forum: sqlite-tools-win32-x86-3310100.zip won't work rope…
Hello, I downloaded https://www.sqlite.org/2020/sqlite-tools-win32-x86-3310100.zip the sqlite-tools-win32-x86-3310100.zip option, on windows 10 and when I…
-
https://sqlite.org/c3ref/io_methods.html — found via Mwmbl
OS Interface File Virtual Methods Object
Every file opened by the sqlite3_vfs.xOpen method populates an sqlite3_file object (or, more commonly, a subclass of the sqlite3_file object) with a poin…
-
http://system.data.sqlite.org/ — found via Mwmbl
System.Data.SQLite: Home
System.Data.SQLite was started by Robert Simpson. Robert still has commit privileges on this repository but is no longer an active contributor. Developmen…
-
https://www.sqlite.org/datatype3.html — found via Mwmbl
Datatypes In SQLite
Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of …
-
https://www.sqlite.org/howtocorrupt.html — found via Mwmbl
How To Corrupt An SQLite Database File
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle …
-
https://www.sqlite.org/pragma.html — found via Mwmbl
Pragma statements supported by SQLite
The PRAGMA statement is an SQL extension specific to SQLite and used to modify the operation of the SQLite library or to query the SQLite library for inte…
-
https://www.sqlite.org/custombuild.html — found via Mwmbl
Custom Builds Of SQLite
For most applications, the recommended method for building SQLite is to use the amalgamation code file, sqlite3.c , and its corresponding header file sqli…
-
https://sqlite.org/althttpd/info/32df1a61707616bc — found via Mwmbl
Althttpd: Check-in [32df1a6170]
Reworked GetMimeType() to allow for type-specific flags such as eliding the charset from Content-Type (necessary for wasm). This also fixes the duplicate …
-
https://www.sqlite.org/fasterthanfs.html — found via Mwmbl
35% Faster Than The Filesystem
The performance difference arises (we believe) because when working from an SQLite database, the open() and close() system calls are invoked only once, wh…
-
https://www.sqlite.org/lang_dropview.html — found via Mwmbl
DROP VIEW
The DROP VIEW statement removes a view created by the CREATE VIEW statement. The view definition is removed from the database schema, but no actual data i…
-
https://sqlite.org/forum/forumpost/ae49298964022f5c7555e97f2c112dd1 — found via Mwmbl
SQLite Forum: [ANN] SQLite in the Cloud: The Future of Lightweig…
We are excited to announce the launch of a beta version of our new SQLite Cloud service. This service allows you to easily and securely share your SQLite …
-
https://github.com/sqlite/sqlite/blob/master/src/malloc.c — found via Mwmbl
sqlite/malloc.c at master · sqlite/sqlite · GitHub
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behav…
-
https://www.sqlite.org/c3ref/get_autocommit.html — found via Mwmbl
Test For Auto-Commit Mode
The sqlite3_get_autocommit() interface returns non-zero or zero if the given database connection is or is not in autocommit mode, respectively. Autocommit…
-
https://www.sqlite.org/lang_createtable.html — found via Mwmbl
CREATE TABLE
Every CREATE TABLE statement must specify a name for the new table. Table names that begin with "sqlite_" are reserved for internal use. It is an error to…
-
https://www.sqlite.org/cgi/docsrc/info/7652db76ff667908 — found via Mwmbl
Documentation Source Text: Check-in [7652db76ff]
}</tclscript> <tcl>hd_fragment csv {CSV import} {.import}</tcl> <h2>Importing CSV files</h2> <p>Use the ".import" command to import CSV (comma separated v…
-
https://news.ycombinator.com/item?id=31340942 — found via Mwmbl
Just clarifying - D1 without read replicas is strongly consisten…
Does SQLite support some kind of monotonic transaction id that can be used as a cache coherency key? Say a client writes a new record to the database whi…
-
http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html?highlight=check_same_thread — found via Mwmbl
SQLite — SQLAlchemy 2.0 Documentation
SQLite does not have built-in DATE, TIME, or DATETIME types, and pysqlite does not provide out of the box functionality for translating values between Pyt…
-
https://stackoverflow.com/questions/1719610/determine-if-sqlite3-transaction-is-active — found via Mwmbl
sqlite - Determine if SQLite3 transaction is active - Stack Over…
Determine the transaction state of a database int sqlite3_txn_state(sqlite3*,const char *zSchema); The sqlite3_txn_state(D,S) interface returns the curren…