How to create a non-unique index in sqlite?
How to create a non-unique index in sqlite? I'm using vb.net to create the tables. ...
sqlite
SQLite trigger to update Summary Counts
Consider the following two (hypothetical) tables Temperature * day * time * lake_name * station * temperature_f Temperature_summary * day * lake_name * station * count_readings_over_75f * count_readings_below_75f How can I write an SQLite Trigger to update the temperature_summary table on insert. I want to increment the count. T...
Sqlite file caching in iPhone 3.2
As of 3.2 it appears that sqlite files are being cached. I discovered that when replacing a sqlite database file and loading its contents, stale data is returned from the overwritten database file. The contents of the new file are correct (as verified by NSFileManager contentsAtPath:) and on relaunch the new file is loaded correctly. A ...
Importing Sqlite data into Google App Engine
I have a relatively extensive sqlite database that I'd like to import into my Google App Engine python app. I've created my models using the appengine API which are close, but not quite identical to the existing schema. I've written an import script to load the data from sqlite and create/save new appengine objects, but the appengine en...
Why isn't my assets folder being installed on emulator?
Where are my assets being installed to? I utilize an assets folder in my new app. I have two files in the folder. When I install my app on the emulator, I cannot access my assets, and furthermore I cannot see them on the emulator filesystem. Extracted my apk and confirmed the assets folder exists: $ ls -ltr assets/ total 16 -rw-rw-r-...
SQLite Select an id which is smaller than a number
Hi, I am trying to only select the objects where the id is smaller than an int value. e.g.: i have 3 objects -> id = 1, id = 2, id = 3 Now I want to only get the objects with the id smaller than the variable i = 2; How can I manage this? sql = "SELECT id FROM table_name WHERE id <= i"; Thanks ;-) ...
c# write big files to blob sqlite
I have c# application which write files to sqlite database. It uses entity fraemwork for modeling data. Write file to blob (entity byte[] varible) with this line: row.file = System.IO.File.ReadAllBytes(file_to_load.FileName); //row.file is type byte[] //row is entity class t...
Efficient batch SQL query execution on Android, for upgrade database.
As we Android developers know, the SQLiteDatabase execSQL method can execute only one statement. The doc says: Execute a single SQL statement that is not a query. For example, CREATE TABLE, DELETE, INSERT, etc. Multiple statements separated by ;s are not supported. I have to load in a batch of records, 1000 and counting. How do I...
Android - viewing SQLite databases on device?
Is there any tool that will allow me to browse databases on my Android device? Something like Sql Management Studio - you know GUI tool that displays databases, tables, row in tables, etc. I'm using Eclipse for development (if it is important for plug-in suggestions). Thanks! ...
SQLite table creation date
Is there a way to query the creation date of a table in SQLite? I am new to SQL, overall. I just found this http://stackoverflow.com/questions/1171019/sql-server-table-creation-date-query. I am assuming that sqlite_master is the equivalent to sys.tables in SQLite. Is that correct? But then my sqlite_master table only has the columns "typ...
Is it normal to get SQLITE_BUSY on a read only database?
I have 2 processes: 1 is writing to a sqlite database, 1 is reading from the same database. Occasioally, I get SQLITE_BUSY on my selects. Is this normal? Is their some option or way I could open the database so that it blocks until it CAN complete the query? (I tried the FULLMUTEX option on the open call but it appeared to have no effect...
How can I package sqlite with my Perl for Windows application?
I need to set up sqllite for Perl on a Windows box. However - Perl is probably being run over the network from a central server, and I do not know what modules will be available on initial running of my script. I can guarantee Perl 5.8+ (activestate) or Perl 5.10+ (strawberry). Therefore, I need to package sqlite & the associated Perl ...
SQLite Databases and Grid Hosting
I'm considering moving my site from a GoDaddy shared hosting account to a Media Temple grid hosting account in anticipation of traffic. However, I first have some concerns with the grid hosting setup. My site stores a large personal set of data on a per-user basis (possibly 3-4MB per user). At this rate I was worried about blowing over ...
SQLITE (C/C++interface) - How to commit a transaction
I am using sqlite c/c++ interface. Now here is my scenario - I have 3 tables (related tables) say A, B, C. Now, there is a function called Set, which get some inputs and based on the inputs inserts rows into these three tables. (sometimes it can be an update in one of the tables) Now I need two things. One, i dont want autocommit ...
[Rails] ActiveRecord using Safari Sqlite
Hi, I am build a webapp for iphone using Phonegap, and I want to create a DB on the device and not on my server. I've seen that there is a Safari Sqlite database, but I haven't been able to find any information about using this database with active record. Does someone knows how to do so? Best, Gregory ...
How to insert date in sqlite through java.
Hello guys, I want to make a database that will hold a date in it(SQLite). Now first to ask is what is the right syntax to declare a date column. The second i want to know is how to insert date in it after that. And the third thing i want to know is how to select dates between, for example to select all rows which contain date between ...
storing array in sqlite databse using objective c in iphone
I want to store mutable array in sqlite database field. Is there any way to serialize array means convaert array into serializaible string and store in to database field. while retrieve time i can deserialize that string. please help me ...
Faster Insertion of Records into a Table with SQLAlchemy
I am parsing a log and inserting it into either MySQL or SQLite using SQLAlchemy and Python. Right now I open a connection to the DB, and as I loop over each line, I insert it after it is parsed (This is just one big table right now, not very experienced with SQL). I then close the connection when the loop is done. The summarized code ...
How to enforce foreign keys using Xerial SQLite JDBC?
According to their release notes, the Xerial SQLite JDBC driver supports foreign keys since version 3.6.20.1. I have tried some time now to get a foreign key constraint to be enforced, but to no avail. Here is what I came up with: public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("...
When to use pragmas on sqlite?
When the pragmas are used? When the database is created for first time or in each connection to database? ...