PLDB
Languages Features Calendar CSV Lists Blog About Sponsor Add Language
GitHub icon

SQLite

SQLite

SQLite is a query language created in 2000 by Dwayne Richard Hipp.

#117on PLDB 22Years Old 5.6kUsers
11Books 0Papers

Try now: RijuTIO

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...


Example from Riju:
SELECT 'Hello, world!';

Keywords in SQLite

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 CURRENT_DATE CURRENT_TIME 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

Language features

Feature Supported Example Token
Booleans

Books about SQLite on goodreads

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

Books about SQLite from ISBNdb

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
mips.html 路 sqlite.html 路 visual-basic-dot-net.html

View source

PLDB - Build the next great programming language 路 v2022 Day 29 Docs Build Acknowledgements Traffic Today Traffic Trends Mirrors GitHub feedback@pldb.com