Talk:SQLite

From Wikipedia, the free encyclopedia
Jump to: navigation, search
          This article is of interest to the following WikiProjects:
WikiProject Computing (Rated Start-class)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 ???  This article has not yet received a rating on the project's importance scale.
 
WikiProject Free Software / Software / Computing  (Rated Start-class, Mid-importance)
WikiProject icon This article is within the scope of WikiProject Free Software, a collaborative effort to improve the coverage of free software on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 Mid  This article has been rated as Mid-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Software.
Taskforce icon
This article is supported by WikiProject Computing.
 
WikiProject Databases / Computer science  (Rated Start-class, Mid-importance)
WikiProject icon This article is within the scope of WikiProject Databases, a collaborative effort to improve the coverage of database related articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 Mid  This article has been rated as Mid-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Computer science (marked as Mid-importance).
 


sqlite3 is not just a standalone program, or what?[edit]

The article says that 'sqlite3 is a standalone program ...'. Isn't there a standalone program for every version? And for version 3 the stand alone program just happens to be called 'sqlite3'? I think it is misleading.

Could be nice too, if someone could comment on differences and compatibilities between versions.

80.71.54.146 (talk) 10:48, 21 July 2011 (UTC)

The file format changed for version 3, necessitating a separate client. The client for 1-2 is just called sqlite. — Preceding unsigned comment added by 24.89.139.58 (talk) 20:18, 2 June 2014 (UTC)

Grammar for bindings statement in overview at top[edit]

Just a thought of grammar, should "It has many bindings to programming languages." be replaced with "It has bindings to many programming languages." or "It has bindings for many programming languages.". I believe the second and third statements are grammatically better, but I'm not sure whether it should be "bindings to" or "bindings for".

In the meantime, I have added a link to Language binding in the sentence in question.

--Jaguar83 (talk) 02:37, 13 February 2012 (UTC)

Providing db as a library is common[edit]

Just read the opening paragraph ending with : "In contrast to other database management systems, SQLite is not a separate process that is accessed from the client application, but an integral part of it."

If the goal is to avoid useless hype, that kind of comparisons should be avoided. Even though a claim can be true at one point of time it most likely will not be true infinitely. Providing a db in a linked lib is common way to provide db functionality. There are various ways to implement this. Library can be static, or dynamic. The server can use shared memory so that clients can be run in separate processes and access the same data. I'm not aware how wide is the support of SQLite, but the centence could as well say 'Like most embedded database management systems ... Unlike most database management systems, SQLite doesn't give the opportunity to run in separate server process'. 88.114.57.29 (talk) 09:24, 6 July 2012 (UTC)

Concurrent Writes?[edit]

"This restriction is relaxed in version 3.7 when WAL is turned on enabling concurrent reads and writes.[11]"

The referenced articles does not support this assertion - it states:

1) WAL provides more concurrency as readers do not block writers and a writer does not block readers. 
   Reading and writing can proceed concurrently.
2) Writers merely append new content to the end of the WAL file. 
   Because writers do nothing that would interfere with the actions of readers, 
   writers and readers can run at the same time. However, since there is only one WAL file, 
   there can only be one writer at a time.  

— Preceding unsigned comment added by 82.43.21.66 (talk) 10:11, 18 August 2012 (UTC)