Normally I use SQLite databases to store data for an application on a per-user basis: I include a blank version of the database in my app and copy it to the user's app data directory on first run, and that's where I keep all their personal data related to the app. Is it possible to do the same thing with SQL Server Compact edition? I th...
I use Netbeans IDE (6.5) and I have a SQLite 2.x database. I installed a JDBC SQLite driver from zentus.com and added a new driver in Nebeans services panel. Then tried to connect to my database file from Services > Databases using this URL for my database: jdbc:sqlite:/home/farzad/netbeans/myproject/mydb.sqlite but it fails to connec...
Hi I am developing an Adobe AIR application which stores data locally using a SQLite database. At any time, I want the end user to synchronize his/her local data to a central MySQL database. Any tips, advice for getting this right? Performance and stability is the key (besides security ;)) ...
In SQL Server, I can do something like this: UPDATE tbl1 SET col2 = tbl2.col2 FROM table1 tbl1 INNER JOIN table2 tbl2 ON tbl1.col1 = tbl2.col1 I haven't bothered to look whether this is part of any SQL standard or not, and I'm sure there are other ways to do it, but it is astoundingly useful. Here's my problem. I need to do somethin...
Using SQLite from .net, Is there a way to access the .dump command or something equivalent from the SQLiteConnection class? ...
Has anyone out there hacked up Expression Engine (CMS) to work with SQLite? If so, any good tips or guides on how to do so? ...
I require database access operations from several threads, through a singleton object, which holds a database connection. I read from SQLite3's website, saying that 'an sqlite3 structure could only be used in the same thread that called sqlite3_open() to create it. You could not open a database in one thread then pass the handle off to a...
Thank you! ...
I've been reading some tutorials on how to get started using Rails 2.0. (Time out: genius website name idea conceived from a typo I just made: "tutoRAILS." Sorry, back to my question.) In most of the tutorials I've been reading, it seems to encourage using MySQL instead of sqlite3. Is there a reason for this, like, performance-wise or ...
I am having problems connecting to a Sqlite database through System.Data.Sqlite. I was trying to use FluentNhibernate but that didn't work, so I went back to basics but got the same error: Cannot find entry point sqlite3_open_v2 in DLL sqlite3. This is my (fairly simple I believe) code: using (SQLiteConnection connection = new SQLiteCo...
I have a file of about 30000 lines of data I want to load into a sqlite3 database. Is there a faster way that generating insert statements for each line of data? The data is space delimited and maps directly to the sqlite3 table. Is there any sort of bulk insert method for adding volume data to a database? Has anyone devised some devio...
We are building an application on an embedded platform that needs a reasonably high performance database (very low select speeds on tables with > 500,000 entries). The database needs to be able to : Store atomic commit information in NVRAM so that such information is preserved if power fails before the commit finishes. Be written to N...
Anyone working on the Android ('gPhone') have or know of a place where I can find a good ORM tool for it? The code is written in Java, and the DB is SQLite. What I would like to find is a tool that given the object definition, can auto-generate the tables and the CRUD functions (that would be awesome), or, barring that, a tool that can...
I have two sqlite connections and execute like below(CMyDatabase is a derived class of sqlite3): CMyDatabase* dbConnection1 = new CMyDatabase; dbConnection1->OpenDataBase(CQCommon::GetModulePath() + L"test.db"); CMyDatabase* dbConnection2 = new CMyDatabase; dbConnection2->OpenDataBase(CQCommon::GetModulePath() + L"test.db"); dbConnect...
Hi All - Final Edit: I found a solution to the problem (at the bottom of the question). I've got an Nunit problem that's causing me grief. Edit: actually it looks more like a SQLite problem, but I'm not 100% certain yet. My TestFixture has a setup that generates a random filename that's used as a SQLite database in each of my tests. ...
I met with a strange problem about sqlite3. I obtained different connections of the same database file using open() method. connection 1 begins a transaction, and connection 2 begins another transaction, which is to update several records of a table. Then connection 1 commit the transaction, followed by connection 2 commit its transactio...
I begin a transaction, which is to insert several records into a table. Can I select the latest inserted record out of the database before the transaction commit? ...
I have a sqlite (v3) table with this column definition: "timestamp" DATETIME DEFAULT CURRENT_TIMESTAMP The server that this database lives on is in the CST time zone. When I insert into my table without including the timestamp column, sqlite automatically populates that field with the current timestamp in GMT, not CST. Is there a wa...
Does anyone know of a good example on how to set up log4net to use the system.data.sqlite provider? I've been playing around with it lately and I thought I had it all working. It makes a successful connection to the database and "writes" it out. However, when I look at the table data, it never actually commits the log. ...
Simply put, I have a table with, among other things, a column for timestamps. I want to get the row with the most recent (i.e. greatest value) timestamp. Currently I'm doing this: SELECT * FROM table ORDER BY timestamp DESC LIMIT 1 But I'd much rather do something like this: SELECT * FROM table WHERE timestamp=max(timestamp) Howeve...