Curation by mkidd 8 months ago for query SQL
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…
-
https://sqlserver.livejournal.com/ — found via Mwmbl
SQL Server's Journal
The user makes his request via the make_job_request stored procedure. He is required to enter a valid job name, action (which is either START, STOP, or CA…
-
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://www.w3schools.com/sql/ — found via Mwmbl
SQL Tutorial
W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are co…
-
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://en.wikipedia.org/wiki/SQL — found via Mwmbl
SQL - Wikipedia
SQL offers two main advantages over older read–write APIs such as ISAM or VSAM . Firstly, it introduced the concept of accessing many records with one sin…
-
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://microsoft.com/sqlserver — found via Mwmbl
SQL Server 2022 | Microsoft
Hybrid capabilities and pay-as-you-go pricing are now available for all versions of SQL Server environments with Azure Arc SQL Server, enabled by Azure Ar…
-
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://golang.org/pkg/database/sql/ — found via Mwmbl
sql package - database/sql - Go Packages
DatabaseTypeName returns the database system name of the column type. If an empty string is returned, then the driver type name is not supported. Consult …
-
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://winand.at/ — found via Mwmbl
Markus Winand: SQL Renaissance Ambassador
As the SQL Renaissance Ambassador, it’s my mission to make developers aware of the evolution of SQL in the 21st century. My book “ SQL Performance Explain…
-
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://twitter.com/sqlserver — found via Mwmbl
We’ve detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You c…
-
http://sqlserver.developpez.com/faq/?page=Schema — found via Mwmbl
SQL Server - La FAQ, le club des d�veloppeurs et IT Pro
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Datab…
-
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…
-
https://en.wikipedia.org/wiki/SQL_Slammer — found via Mwmbl
SQL Slammer - Wikipedia
The worm was based on proof of concept code demonstrated at the Black Hat Briefings by David Litchfield , who had initially discovered the buffer overflow…
-
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…
-
http://dataconomy.com/sql-vs-nosql-need-know/ — found via Mwmbl
SQL Vs. NoSQL - Know The Difference - Dataconomy
SQL vs. NoSQL – Know the Difference ‘SQL is outdated’. ‘RDBMS can no longer meet businesses’ data management needs’. ‘New database technologies like NoSQ…
-
http://stackoverflow.com/a/39943048/4099593 — found via Mwmbl
sql - How do I specify a default value in a MS Access query? - S…
Thanks... That's helping. Just to clarify, I've wrapped the entire subquery using that function like so: nz((SELECT Sum(tblPayments.Amount) FROM tblPaymen…
-
http://mssqlwiki.com/category/sqlserver-sos/ — found via Mwmbl
SQLServer SOS « MSSQLWIKI
When we discussed about thread I mentioned In multi-threaded applications each thread has to synchronize their activities among other threads. Sometimes a…
-
https://en.wikipedia.org/wiki/SQL_injection — found via Mwmbl
SQL injection - Wikipedia
In computing, SQL injection is a code injection technique used to attack data-driven applications, in which malicious SQL statements are inserted into an …
-
http://stackoverflow.com/questions/20441645/ — found via Mwmbl
sql - Creating a list of all the dates between a range and then …
I have a problem were I need to insert a set of dates (one row for each date) that come from a date range that comes in to me as an ical format . I also n…
-
http://stackoverflow.com/questions/20499972/ — found via Mwmbl
sql - Update Trigger on a Table - Stack Overflow
Yes, if the trigger encounters an error (internally or through calling some external procedure) and rolls back the transaction, it will roll back the whol…
-
http://stackoverflow.com/questions/14740688/ — found via Mwmbl
sql server 2008 - How to prevent only non-empty tables from bein…
I don't think you can do this with a DDL trigger, since in this case it is an after trigger - so the table no longer exists, and there is no trace of it i…
-
https://github.com/dotnet/efcore/issues/22613 — found via Mwmbl
SqlServer Migrations: Scripts do not fail on failure · Issue #22…
Comments edited One of the new features added in 5.0-rc1 was that transactions are now used in migrations, however if there is a failure in your migratio…
-
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://www.w3.org/TR/webdatabase/ — found via Mwmbl
Web SQL Database
This specification defines an API for storing data in databases that can be queried using a variant of SQL. Status of This Document Beware. This specifica…
-
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/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://en.wikipedia.org/wiki/Query_plan — found via Mwmbl
Query plan - Wikipedia
Since SQL is declarative , there are typically many alternative ways to execute a given query, with widely varying performance. When a query is submitted …
-
https://owasp.org/www-community/attacks/SQL_Injection — found via Mwmbl
SQL Injection | OWASP Foundation
A SQL injection attack consists of insertion or “injection” of a SQL query via the input data from the client to the application. A successful SQL injecti…
-
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/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://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.w3schools.com/sql/func_sqlserver_coalesce.asp — found via Mwmbl
SQL Server COALESCE() Function
W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are c…
-
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…
-
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/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/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…
-
http://stackoverflow.com/questions/18498039/ — found via Mwmbl
url - SQL SERVER get hostname and path but not parameters - Stac…
The only thing I didn't understand is why the first row in the output should be missing a trailing slash, while the other rows include it. In my query thi…
-
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…
-
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://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://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://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…
-
http://en.wikipedia.org/wiki/Microsoft_SQL_Server — found via Mwmbl
Microsoft SQL Server - Wikipedia
Microsoft SQL Server is a relational database management system developed by Microsoft . As a database server , it is a software product with the primary …
-
https://www.slideshare.net/antoniosch/sqlserver-database-structures — found via Mwmbl
SQLServer Database Structures | PPT
13 . PAGE HEADER pageID The file number and page number of this page in the database Metadata: ObjectId The ID of the object to which this page belongs sl…
-
https://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet — found via Mwmbl
SQL Injection Prevention - OWASP Cheat Sheet Series
This article is focused on providing clear, simple, actionable guidance for preventing SQL Injection flaws in your applications. SQL Injection attacks are…
-
https://stackoverflow.com/questions/tagged/sql-server — found via Mwmbl
Newest 'sql-server' Questions - Stack Overflow
Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all Microsoft SQL Server editions including Compact, Express, Az…
-
https://docs.microsoft.com/sql/linux/sql-server-linux-setup — found via Mwmbl
Installation guidance for SQL Server on Linux - SQL Server | Mic…
SQL Server is tested and supported on Linux for the previously listed distributions. If you choose to install SQL Server on an unsupported operating syste…
-
https://github.com/TechEmpower/FrameworkBenchmarks/issues/3786 — found via Mwmbl
Add SqlServer on Linux DB? · Issue #3786 · TechEmpower/Framework…
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You swi…
-
http://stackoverflow.com/questions/tagged/google-cloud-dataproc — found via Mwmbl
Newest 'google-cloud-dataproc' Questions - Stack Overflow
My Sql server DB password is saved on Azure app vault which has DATAREF ID as a identifier. I need that password to create spark dataframe from table whic…
-
https://www.mssqltips.com/sqlservertutorial/4/sql-server-simple-recovery-model/ — found via Mwmbl
SQL Server Simple Recovery Model
Overview The "Simple" recovery model does what it implies, it gives you a simple backup that can be used to replace your entire database in the event of …
-
https://eriqande.github.io/2014/12/19/setting-up-rodbc.html — found via Mwmbl
Accessing MS SQLserver with R from my Mac
A few years back I had used unixODBC and freeTDS to be able to connect from my Mac to the Microsoft SQLserver that is here in the lab. Since then I have s…
-
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://archive.fosdem.org/2015/schedule/event/modern_sql_in_postgresql/ — found via Mwmbl
FOSDEM 2015 - Modern SQL in PostgreSQL
SQL has gone out of fashion lately—partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, th…
-
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…
-
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling — found via Mwmbl
SQL Server Connection Pooling - ADO.NET | Microsoft Learn
Connecting to a database server typically consists of several time-consuming steps. A physical channel such as a socket or a named pipe must be establishe…
-
https://docs.cossacklabs.com/acra/acra-in-depth/architecture/acraserver/ — found via Mwmbl
AcraServer, an SQL proxy | Cossack Labs
AcraServer is also known as SQL Proxy. It’s an SQL database proxy that exposes Acra’s functionality by parsing SQL traffic between an app and a database …
-
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Comments.html — found via Mwmbl
Comments
Comments within SQL statements are stored as part of the application code that executes the SQL statements. Comments associated with individual schema or …
-
https://stackoverflow.com/questions/40685375/how-to-import-bacpac-into-docker-sqlserver/51057827 — found via Mwmbl
sql server - How to import .bacpac into docker Sqlserver? - Stac…
I installed Sqlserver on my Mac in a docker container, following the instructions from this article . I run the container with Kitematic and managed to co…
-
https://stackoverflow.com/questions/1437200/sqlserver-2005-deadlock-problem-with-no-shared-records — found via Mwmbl
SqlServer 2005: deadlock problem with no shared records - Stack …
Table A is in the middle of three tables. If I change anything in the query, for instance remove one of the joined tables B or C , there is no deadlock. T…
-
https://www.mssqltips.com/sqlservertutorial/218/command-line-tool-to-execute-ssis-packages/ — found via Mwmbl
Command line tool to execute SSIS packages
Overview SQL Server includes the command line tool DTEXEC.EXE which can be used to execute an SSIS package. DTEXEC can be run from a Command Prompt or f…
-
https://stackoverflow.com/questions/24310361/why-doesnt-this-newly-created-oracle-text-index-work-until-it-is-rebuilt — found via Mwmbl
sql - Why doesn't this newly created Oracle Text Index work unti…
We recently had to fix a bug with our context indexes not properly indexing the contents of any of the Office Open XML file formats that we uploaded to ou…
-
https://serverfault.com/questions/114137/sql-server-management-studio-connect-to-server-list-editing — found via Mwmbl
ssms - SQL Server Management Studio Connect to Server List Editi…
I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no lon…
New results
-
https://en.wikipedia.org/wiki/SQL — found via Mwmbl
SQL - Wikipedia
SQL offers two main advantages over older read–write APIs such as ISAM or VSAM . Firstly, it introduced the concept of accessing many records with one sin…
-
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…
-
https://sqlserver.livejournal.com/ — found via Mwmbl
SQL Server's Journal
The user makes his request via the make_job_request stored procedure. He is required to enter a valid job name, action (which is either START, STOP, or CA…
-
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://www.w3schools.com/sql/ — found via Mwmbl
SQL Tutorial
W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are co…
-
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/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://microsoft.com/sqlserver — found via Mwmbl
SQL Server 2022 | Microsoft
Hybrid capabilities and pay-as-you-go pricing are now available for all versions of SQL Server environments with Azure Arc SQL Server, enabled by Azure Ar…
-
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://golang.org/pkg/database/sql/ — found via Mwmbl
sql package - database/sql - Go Packages
DatabaseTypeName returns the database system name of the column type. If an empty string is returned, then the driver type name is not supported. Consult …
-
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://winand.at/ — found via Mwmbl
Markus Winand: SQL Renaissance Ambassador
As the SQL Renaissance Ambassador, it’s my mission to make developers aware of the evolution of SQL in the 21st century. My book “ SQL Performance Explain…
-
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://twitter.com/sqlserver — found via Mwmbl
We’ve detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You c…
-
http://sqlserver.developpez.com/faq/?page=Schema — found via Mwmbl
SQL Server - La FAQ, le club des d�veloppeurs et IT Pro
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Datab…
-
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…
-
https://en.wikipedia.org/wiki/SQL_Slammer — found via Mwmbl
SQL Slammer - Wikipedia
The worm was based on proof of concept code demonstrated at the Black Hat Briefings by David Litchfield , who had initially discovered the buffer overflow…
-
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…
-
http://dataconomy.com/sql-vs-nosql-need-know/ — found via Mwmbl
SQL Vs. NoSQL - Know The Difference - Dataconomy
SQL vs. NoSQL – Know the Difference ‘SQL is outdated’. ‘RDBMS can no longer meet businesses’ data management needs’. ‘New database technologies like NoSQ…
-
http://stackoverflow.com/a/39943048/4099593 — found via Mwmbl
sql - How do I specify a default value in a MS Access query? - S…
Thanks... That's helping. Just to clarify, I've wrapped the entire subquery using that function like so: nz((SELECT Sum(tblPayments.Amount) FROM tblPaymen…
-
http://mssqlwiki.com/category/sqlserver-sos/ — found via Mwmbl
SQLServer SOS « MSSQLWIKI
When we discussed about thread I mentioned In multi-threaded applications each thread has to synchronize their activities among other threads. Sometimes a…
-
https://en.wikipedia.org/wiki/SQL_injection — found via Mwmbl
SQL injection - Wikipedia
In computing, SQL injection is a code injection technique used to attack data-driven applications, in which malicious SQL statements are inserted into an …
-
http://stackoverflow.com/questions/20441645/ — found via Mwmbl
sql - Creating a list of all the dates between a range and then …
I have a problem were I need to insert a set of dates (one row for each date) that come from a date range that comes in to me as an ical format . I also n…
-
http://stackoverflow.com/questions/20499972/ — found via Mwmbl
sql - Update Trigger on a Table - Stack Overflow
Yes, if the trigger encounters an error (internally or through calling some external procedure) and rolls back the transaction, it will roll back the whol…
-
http://stackoverflow.com/questions/14740688/ — found via Mwmbl
sql server 2008 - How to prevent only non-empty tables from bein…
I don't think you can do this with a DDL trigger, since in this case it is an after trigger - so the table no longer exists, and there is no trace of it i…
-
https://github.com/dotnet/efcore/issues/22613 — found via Mwmbl
SqlServer Migrations: Scripts do not fail on failure · Issue #22…
Comments edited One of the new features added in 5.0-rc1 was that transactions are now used in migrations, however if there is a failure in your migratio…
-
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://www.w3.org/TR/webdatabase/ — found via Mwmbl
Web SQL Database
This specification defines an API for storing data in databases that can be queried using a variant of SQL. Status of This Document Beware. This specifica…
-
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/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://en.wikipedia.org/wiki/Query_plan — found via Mwmbl
Query plan - Wikipedia
Since SQL is declarative , there are typically many alternative ways to execute a given query, with widely varying performance. When a query is submitted …
-
https://owasp.org/www-community/attacks/SQL_Injection — found via Mwmbl
SQL Injection | OWASP Foundation
A SQL injection attack consists of insertion or “injection” of a SQL query via the input data from the client to the application. A successful SQL injecti…
-
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/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://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.w3schools.com/sql/func_sqlserver_coalesce.asp — found via Mwmbl
SQL Server COALESCE() Function
W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are c…
-
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…
-
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/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/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…
-
http://stackoverflow.com/questions/18498039/ — found via Mwmbl
url - SQL SERVER get hostname and path but not parameters - Stac…
The only thing I didn't understand is why the first row in the output should be missing a trailing slash, while the other rows include it. In my query thi…
-
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…
-
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://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://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://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…
-
http://en.wikipedia.org/wiki/Microsoft_SQL_Server — found via Mwmbl
Microsoft SQL Server - Wikipedia
Microsoft SQL Server is a relational database management system developed by Microsoft . As a database server , it is a software product with the primary …
-
https://www.slideshare.net/antoniosch/sqlserver-database-structures — found via Mwmbl
SQLServer Database Structures | PPT
13 . PAGE HEADER pageID The file number and page number of this page in the database Metadata: ObjectId The ID of the object to which this page belongs sl…
-
https://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet — found via Mwmbl
SQL Injection Prevention - OWASP Cheat Sheet Series
This article is focused on providing clear, simple, actionable guidance for preventing SQL Injection flaws in your applications. SQL Injection attacks are…
-
https://stackoverflow.com/questions/tagged/sql-server — found via Mwmbl
Newest 'sql-server' Questions - Stack Overflow
Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all Microsoft SQL Server editions including Compact, Express, Az…
-
https://docs.microsoft.com/sql/linux/sql-server-linux-setup — found via Mwmbl
Installation guidance for SQL Server on Linux - SQL Server | Mic…
SQL Server is tested and supported on Linux for the previously listed distributions. If you choose to install SQL Server on an unsupported operating syste…
-
https://github.com/TechEmpower/FrameworkBenchmarks/issues/3786 — found via Mwmbl
Add SqlServer on Linux DB? · Issue #3786 · TechEmpower/Framework…
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You swi…
-
http://stackoverflow.com/questions/tagged/google-cloud-dataproc — found via Mwmbl
Newest 'google-cloud-dataproc' Questions - Stack Overflow
My Sql server DB password is saved on Azure app vault which has DATAREF ID as a identifier. I need that password to create spark dataframe from table whic…
-
https://www.mssqltips.com/sqlservertutorial/4/sql-server-simple-recovery-model/ — found via Mwmbl
SQL Server Simple Recovery Model
Overview The "Simple" recovery model does what it implies, it gives you a simple backup that can be used to replace your entire database in the event of …
-
https://eriqande.github.io/2014/12/19/setting-up-rodbc.html — found via Mwmbl
Accessing MS SQLserver with R from my Mac
A few years back I had used unixODBC and freeTDS to be able to connect from my Mac to the Microsoft SQLserver that is here in the lab. Since then I have s…
-
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://archive.fosdem.org/2015/schedule/event/modern_sql_in_postgresql/ — found via Mwmbl
FOSDEM 2015 - Modern SQL in PostgreSQL
SQL has gone out of fashion lately—partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, th…
-
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…
-
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling — found via Mwmbl
SQL Server Connection Pooling - ADO.NET | Microsoft Learn
Connecting to a database server typically consists of several time-consuming steps. A physical channel such as a socket or a named pipe must be establishe…
-
https://docs.cossacklabs.com/acra/acra-in-depth/architecture/acraserver/ — found via Mwmbl
AcraServer, an SQL proxy | Cossack Labs
AcraServer is also known as SQL Proxy. It’s an SQL database proxy that exposes Acra’s functionality by parsing SQL traffic between an app and a database …
-
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Comments.html — found via Mwmbl
Comments
Comments within SQL statements are stored as part of the application code that executes the SQL statements. Comments associated with individual schema or …
-
https://stackoverflow.com/questions/40685375/how-to-import-bacpac-into-docker-sqlserver/51057827 — found via Mwmbl
sql server - How to import .bacpac into docker Sqlserver? - Stac…
I installed Sqlserver on my Mac in a docker container, following the instructions from this article . I run the container with Kitematic and managed to co…
-
https://stackoverflow.com/questions/1437200/sqlserver-2005-deadlock-problem-with-no-shared-records — found via Mwmbl
SqlServer 2005: deadlock problem with no shared records - Stack …
Table A is in the middle of three tables. If I change anything in the query, for instance remove one of the joined tables B or C , there is no deadlock. T…
-
https://www.mssqltips.com/sqlservertutorial/218/command-line-tool-to-execute-ssis-packages/ — found via Mwmbl
Command line tool to execute SSIS packages
Overview SQL Server includes the command line tool DTEXEC.EXE which can be used to execute an SSIS package. DTEXEC can be run from a Command Prompt or f…
-
https://stackoverflow.com/questions/24310361/why-doesnt-this-newly-created-oracle-text-index-work-until-it-is-rebuilt — found via Mwmbl
sql - Why doesn't this newly created Oracle Text Index work unti…
We recently had to fix a bug with our context indexes not properly indexing the contents of any of the Office Open XML file formats that we uploaded to ou…
-
https://serverfault.com/questions/114137/sql-server-management-studio-connect-to-server-list-editing — found via Mwmbl
ssms - SQL Server Management Studio Connect to Server List Editi…
I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no lon…