SQLite is a query language created in 2000 by Dwayne Richard Hipp.
#111on PLDB | 23Years Old | 5.6kUsers |
11Books | 0Papers |
SQLite ( or ) is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client鈥搒erver database engine. Rather, it is embedded into the end program. Read more on Wikipedia...
SELECT 'Hello, world!';
ABORT ACTION ADD AFTER ALL ALTER ANALYZE AND AS ASC ATTACH AUTOINCREMENT BEFORE BEGIN BETWEEN BY CASCADE CASE CAST CHECK COLLATE COLUMN COMMIT CONFLICT CONSTRAINT CREATE CROSS CURRENTDATE CURRENTTIME CURRENT_TIMESTAMP DATABASE DEFAULT DEFERRABLE DEFERRED DELETE DESC DETACH DISTINCT DROP EACH ELSE END ESCAPE EXCEPT EXCLUSIVE EXISTS EXPLAIN FAIL FOR FOREIGN FROM FULL GLOB GROUP HAVING IF IGNORE IMMEDIATE IN INDEX INDEXED INITIALLY INNER INSERT INSTEAD INTERSECT INTO IS ISNULL JOIN KEY LEFT LIKE LIMIT MATCH NATURAL NO NOT NOTNULL NULL OF OFFSET ON OR ORDER OUTER PLAN PRAGMA PRIMARY QUERY RAISE RECURSIVE REFERENCES REGEXP REINDEX RELEASE RENAME REPLACE RESTRICT RIGHT ROLLBACK ROW SAVEPOINT SELECT SET TABLE TEMP TEMPORARY THEN TO TRANSACTION TRIGGER UNION UNIQUE UPDATE USING VACUUM VALUES VIEW VIRTUAL WHEN WHERE WITH WITHOUT
Feature | Supported | Token | Example |
---|---|---|---|
Case Insensitive Identifiers | X | ||
Booleans | X |
title | author | year | reviews | ratings | rating |
---|---|---|---|---|---|
Introducing Sqlite for Mobile Developers | Jesse Feiler | 0 | 2 | 3.50 | |
Introducing SQLite for Mobile Developers | Jesse Feiler | 0 | 0 | 0.0 | |
iPhone Database Programming Exercises: SQLite | Norman McEntire | 2010 | 0 | 1 | 2.00 |
title | authors | year | publisher |
---|---|---|---|
The Definitive Guide to SQLite (Expert's Voice in Open Source) | Allen, Grant and Owens, Mike | 2011 | Apress |
The Definitive Guide to SQLite | Mike Owens | 20061206 | Springer Nature |
Build iOS Database Apps with Swift and SQLite | Kevin Languedoc | 20161115 | Springer Nature |
Introducing SQLite for Mobile Developers | Feiler, Jesse | 2015 | Apress |
Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming | Siahaan, Vivian and Sianipar, Rismon Hasiholan | 2019-11-25T00:00:01Z | Independently published |
Learn PyQt By Example: A Quick Start Guide to MySQL and SQLite Driven Programming | Siahaan, Vivian and Sianipar, Rismon Hasiholan | 2019-11-24T00:00:01Z | Independently published |
Learn PyQt The Hard Way: A Quick Start Guide to PostgreSQL and SQLite Driven Programming | Siahaan, Vivian and Sianipar, Rismon Hasiholan | 2019 | Independently published |
SQLite | Newman, Chris. | 2004 | Sams |