Yesterday I released a small site* to track your rep that used a shared SQLite database for all visitors. Unfortunately, even with the modest load that it put on my host it ran quite slowly. This is because the entire database was locked every time someone viewed the page because it contained updates/inserts. I soon … Read more
14/06/2016 Yep… still getting upvotes :-/ 17/03/2014 I’m still receiving upvotes for this, be mindful of the date this was originally answered. Though the main three items listed are still entirely viable, the list will tend towards becoming stale. There are further database technologies available that are not listed. You have a couple of immediately … Read more
You missed a space: db.execSQL(“delete * from ” + TABLE_NAME); Also there is no need to even include *, the correct query is: db.execSQL(“delete from “+ TABLE_NAME);
Put the UNIQUE declaration within the column definition section; working example: CREATE TABLE a ( i INT, j INT, UNIQUE(i, j) ON CONFLICT REPLACE );
It seems your makefile didn’t include the appropriate .so file. You can correct this problem with the steps below: Install sqlite-devel (or libsqlite3-dev on some Debian-based systems) Re-configure and re-compiled Python with ./configure –enable-loadable-sqlite-extensions && make && sudo make install Note The sudo make install part will set that python version to be the system-wide … Read more
In Python: con = sqlite3.connect(‘database.db’) cursor = con.cursor() cursor.execute(“SELECT name FROM sqlite_master WHERE type=”table”;”) print(cursor.fetchall()) Watch out for my other answer. There is a much faster way using pandas.
You’re not saying what you wish to do with the dumped file. To get a CSV file (which can be imported into almost everything) .mode csv — use ‘.separator SOME_STRING’ for something other than a comma. .headers on .out file.csv select * from MyTable; To get an SQL file (which can be reinserted into a … Read more
From here and d5e5’s comment: You’ll have to switch the output to csv-mode and switch to file output. sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; sqlite> .output stdout
Base is younger than your question, and definitely feels like a 1.0, but the user experience is miles better than the experience of using any of the “cross-platform” apps on a Mac. http://menial.co.uk/software/base/ I recommend you buy a license before the developer realizes he is charging too little for it. UPDATE: Since December 2008, Base … Read more
Try doubling up the single quotes (many databases expect it that way), so it would be : INSERT INTO table_name (field1, field2) VALUES (123, ‘Hello there”s’); Relevant quote from the documentation: A string constant is formed by enclosing the string in single quotes (‘). A single quote within the string can be encoded by putting … Read more