sqlite

JavaScript sqlite

Best recommendations for accessing and manipulation of sqlite databases from JavaScript. ...

SQLite UDF - VBA Callback

Has anybody attempted to pass a VBA (or VB6) function (via AddressOf ?) to the SQLite create a UDF function (http://www.sqlite.org/c3ref/create_function.html). How would the resulting callback arguments be handled by VBA? The function to be called would have the following signature... void (*xFunc)(sqlite3_context*,int,sqlite3_value...

Database functionality with WPF app: SQLite, SQL CE, other?

I want to extend a WPF application with database functionality. Which database engine would you suggest and why? SQLite, SQL CE, other? ...

How do I dump the data of some SQLite3 tables?

How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)? The dump should be in SQL format, as it should be easily re-entered into the database latter and should be done from the command line. Something like sqlite3 db .dump but without dumping the schema and selecting which ...

SQLite3::BusyException

Running a rails site right now using SQLite3. About once every 500 requests or so, I get a ActiveRecord::StatementInvalid (SQLite3::BusyException: database is locked:... What's the way to fix this that would be minimally invasive to my code? I'm using SQLLite at the moment because you can store the DB in source control which makes ba...

How can I merge many SQLite databases?

If I have a large number of SQLite databases, all with the same schema, what is the best way to merge them together in order to perform a query on all databases? I know it is possible to use ATTACH to do this but it has a limit of 32 and 64 databases depending on the memory system on the machine. ...

Read Firefox 3 bookmarks

Firefox 3 stores the bookmarks in a sqlite database. There are several hacked sqlite java libraries available. Is there a way to hack the sqlite database in java(not using libraries) to read bookmarks reliably? Does someone know how the sqlite DB is stored and access programmatically (from java)? ...

How do I list the tables in a SQLite database file

What SQL can be used to list the tables, and the rows within those tables, in a SQLite database file once i've ATTACHed it on the sqlite3 command line tool? ...

Is there a .NET/C# wrapper for SQLite?

I'd sort of like to use SQLite from within C#.Net, but I can't seem to find an appropriate library. Is there one? An official one? Are there other ways to use SQLite than with a wrapper? ...

SQLite / Firebird embedded for numeric data

I have an experiment streaming up 1Mb/s of numeric data which needs to be stored for later processing. It seems as easy to write directly into a database as to a CSV file and I would then have the ability to easily retrieve subsets or ranges. I have experience of sqlite2 (when it only had text fields) and it seemed pretty much as fast ...

Mac SQLite editor

I am aware of CocoaMySQL but I have not seen a Mac GUI for SQLite, is there one? My Google search didn't turn up any Mac related GUI's which is why I'm asking here rather than Google. ...

Predict next auto-inserted row id (sqlite)

I'm trying to find if there is a reliable way (using sqlite) to find the ID of the next row to be inserted, before it gets inserted. I need to use the id for another insert statement, but don't have the option of instantly inserting and getting the next row. Is predicting the next id as simple as getting the last id and adding one? Is t...

Using SQLITE with VB6

I am currently using an MSAccess mdb file for a redistributable app. A while ago I found out about SQLite, as an alternative to my solution, but the binaries they provide do not offer the possiblilty of using them as an object in VB6. (Or at least I couldn't figure it out how). Does anyone has a link, or could write a little about con...

Delphi Question : Multiple Tables in a TClientDataset?

Is it possible to put the results from more than one query on more than one table into a TClientDataset? Just something like SELECT * from t1; SELECT * from t2; SELECT * from t3; I can't seem to figure out a way to get a data provider (SetProvider) to pull in results from more than one table at a time. ...

What is a good OO C++ wrapper for sqlite

I'd like to find a good object oriented C++ (as opposed to C) wrapper for sqlite. What do people recommend? If you have several suggestions please put them in separate replies for voting purposes. Also, please indicate whether you have any experience of the wrapper you are suggesting and how you found it to use. ...

Storing a calendar day in sqlite database

I need to store items with a calendar date (just the day, no time) in a sqlite database. What's the best way to represent the date in the column? Julian days and unix seconds come to mind as reasonable alternatives. If I go with a unit other than days at what clock time should it be? Update: I am aware of ISO8601 and actually used it...

What is the equivalent of the SQLite datetime function in PostgreSQL?

The question is pretty self-explanatory. I'm looking for a PostgreSQL equivalent to the SQLite datetime function. ...

Extreme Sharding: One SQLite Database Per User

I'm working on a web app that is somewhere between an email service and a social network. I feel it has the potential to grow really big in the future, so I'm concerned about scalability. Instead of using one centralized MySQL/InnoDB database and then partitioning it when that time comes, I've decided to create a separate SQLite databa...

How do I unlock a SQLite database?

sqlite> DELETE FROM mails WHERE (`id` = 71); SQL error: database is locked How do I unlock the database so this will work? ...

Sqlite update field if it contains

Given a database field named "widget_ids", containing data like "67/797/124/" or "45/", where the numbers are slash separated widget_ids... how would you make an update statement with SQL that would say: "if the widget_ids of the row with id X contains the text "somenumber/" do nothing, otherwise append "somenumber/" to it's current valu...