Return to the Press page

Vyatta – Linux & Open Source Alternative to Cisco – Advanced Routing, Firewall, VPN, QoS..
Free Download ->

LWN.net Weekly Edition for October 2, 2008

openSUSE and the distribution of proprietary software

Weekly edition	Kernel	Security	Distributions	Search
Archives	Calendar	Subscribe	Write for LWN	LWN.net FAQ

SQLite 3.0.7 (Linux Journal)

[Posted October 1, 2004 by ris]

Linux Journal reviews SQLite. "D. Richard Hipp's SQLite database engine has earned a well-respected place in the toolbox of many programmers. Its small size and simple distribution make it a natural choice for standalone and embedded applications. Wide support by many programming languages, including PHP, has made SQLite popular for Web applications that need persistent data storage but don't need the kind of multi-user scaling capabilities provided by server-based solutions."

(Log in to post comments)

Posted Oct 2, 2004 8:25 UTC (Sat) by gervin23 (guest, #13977) [Link]

The only stumbling block I ran into with the idea of distributing sqlite (i.e. cdrom) is the absence of Access Control. Other than that, I very much liked it.

SQLite 3.0.7 (Linux Journal)

Posted Oct 2, 2004 13:07 UTC (Sat) by evgeny (subscriber, #774) [Link]

?? It's just simple plain single file. Define whatever AC a filesystem/OS provides.

SQLite 3.0.7 (Linux Journal)

Posted Oct 2, 2004 13:43 UTC (Sat) by tzafrir (subscriber, #11501) [Link]

It is not a server. You don't authentocate before each access. Thus there is not much point talking about different users. It does not provide/impose its own ACL mechanism.

This should be hamdled either below (filesystem level) or above (application level).

Frrankly the ACLs in a typical small apache/php/mysql program are not used on anything less than a table granularity, and even that is quite rare.

SQLite 3.0.7 (Linux Journal)

Posted Oct 2, 2004 22:24 UTC (Sat) by dps (subscriber, #5725) [Link]

Maybe my program is not small, but is actively uses column level access controls to limit any SQL injection attacks that get past it's SQL injection filters. Table level access control is just about tolerable, but no access control whatsoever it is not.

Apart from that problem SQLite has more than everything the program needs. ALTER TABLE is useful when the tables mutate during development, but this is infrequent enough for me to be able to live without that feature.