SQLite

This forum is an archive for the mailing list sqlite-users@mailinglists.sqlite.org (more options) Messages posted here will be sent to this mailing list.
SQLite is a small C library that implements a self-contained, serverless, embeddable, zero-configuration SQL database engine.
12345 ... 544
Topics (19018)
Replies Last Post Views
LEFT JOIN + WHERE / OR optimisation by Dinu
23
by Dinu
sqlite3_column_name with alias by Bart Smissaert
7
by Bart Smissaert
The performance of indexed select by Nick
15
by Nick
Tip of Trunk does not compile under 64-bit MingW compiler by Keith Medcalf
3
by Richard Hipp-3
Efficient query to count number of leaves in a DAG. by Shane Dev
14
by Shane Dev
Why doesn't SQLite optimise this subselect? by Jonathan Moules-3
2
by Dinu
How can i encrypt my database file ? by a a
4
by a a
drop table if exists X by Kenneth Shuai
1
by Clemens Ladisch
Preventing a slow, determinstic function from running twice by rob@hoelz.ro
5
by rob@hoelz.ro
new Error database disk image is malformed by Ron Barnes
10
by Ron Barnes
Explain query plan output and recursive CTE's by David Raymond
0
by David Raymond
Loadable extension with shared state by Lifepillar
4
by Simon Slavin-3
Search % using sqlite by Deepak Hegde
3
by Deepak Hegde
LSM extension unusual memory growth? by Josu Diaz de Arcaya
0
by Josu Diaz de Arcaya
Database Variable by Gregory Moore-3
3
by Gregory Moore-3
Is WAL mode more robust against corruption? by Chris Brody
2
by Chris Brody
Can i check database corruption by select statement instead of quick_check? by Junyoung Park
3
by Keith Medcalf
Query optimizer and recursive common table expressions by Shane Dev
4
by Cezary H. Noweta
Emulate right-join by Stephen Chrzanowski
10
by Cezary H. Noweta
pragma table_info return column delimiters? by Bart Smissaert
7
by Bart Smissaert
GROUP_CONCAT with DISTINCT bug by Tony Papadimitriou
12
by Cezary H. Noweta
C++ compiler by eli
8
by Igor Korot
Dynamically load all the sqlite functions by Marco Bambini
0
by Marco Bambini
Capturing groups for regexp.c Check-in [3d6fba62] ? by petern
2
by petern
Knowing when not to use a R-Tree index, and clustering tables along spatial indexes by Andrea Aime
9
by Wolfgang Enzinger
scanstats by Luuk
0
by Luuk
Can select * from table where not exists (subquery) be optimized? by Shane Dev
11
by Clemens Ladisch
sqlite3AtoF() by Cezary H. Noweta
2
by Cezary H. Noweta
fsync on -wal still happening by Ian Freeman
13
by Keith Medcalf
PRAGMA help by Tony Papadimitriou
1
by J Decker
advice about schema versioning and WAL by Gwendal Roué-2
2
by Gwendal Roué-2
finding the number of records until a value is different by nitpilot
5
by Max Vlasov
Dan. Latest zipfile.c checkin feedback by petern
0
by petern
The value of nFetchOut and zPath after wal-file calls sqlite3OsOpen() by Nick
0
by Nick
What happens if an in memory database runs out of memory by curmudgeon
41
by Rowan Worth-2
12345 ... 544