sqlite

FULL-TEXT Search in SQLite

Simple question: does SQLite support FULL-TEXT searches? If not, is there any way I can implement that feature? ...

Best way to save complex Python data structures across program sessions (pickle, json, xml, database, other)

Looking for advice on the best technique for saving complex Python data structures across program sessions. Here's a list of techniques I've come up with so far: pickle/cpickle json jsonpickle xml database (like SQLite) Pickle is the easiest and fastest technique, but my understanding is that there is no guarantee that pickle output...

Counter variable in SQLite

I'm working on a simple todo app that has a column for each day of the week. On startup, the app checks to see if there are any incomplete tasks from before the current date. If so, they're moved to the top of the current date's column. The app is cloud-based, but the tasks are backed up for offline mode with an SQLite db. I can easily ...

Readonly connections with ADO.NET, SQLite and TSQL

My code reads via one connection and writes via another. I dont want to accidentally write with the read connection. How can i make the connection readonly? I am using SQLite ATM and will convert sections of code to tsql when the prototype is over. ...

Using 'Auto-Sync' feature of DBML with SQLite

I'm having trouble trying to use the 'Auto-Sync' feature of DBML with SQLite. I have a class in my data model that contains a primary key (id). This key is defined as "INTEGER PRIMARY KEY", which SQLite maps to the rowid of the row. To support this, I have set "Auto Generated Value" to 'True' and "Auto-Sync" to 'OnInsert'. The proble...

Combining a datastore with Mapkit

Does anyone have any advice on using a datastore with mapkit to provide a database of locations (Restaurants) that are query-able by location? I would like to use Core data but importing the information into it seems like a project in itself. If anyone has good advice on converting an existing sqlite/cvs file to a coredata sqlite file t...

static database class to use with any activity

Hello, I am new to Android, and I haven't developed any app regarding databases on Android yet. So I have a few basic questions. I am after a good database class sample, that will let me to run the CRUD operations. I would like to use it as a static class like: clsDB->Select("select * from clients"); or objClient->Delete(clientid); I a...

Should I put my faith in SQLite transactions to avoid file corruption?

Short version If my process is terminated in the middle of a transaction, or while SQLite is committing a transaction, what are the chances that the database file will be corrupted? Long version My application uses an SQLite database for storage (directly, not via Core Data). I'm working on a new version of the application which will ...

How to check if i am in a transaction?

I have a piece of code i recently expanded but now must use a transaction. It looks like it can only be access while in a transaction but looks like doesnt make me feel comfortable. Using SQLite and ADO.NET i wrote if(cmd.Transaction==null) but it is null and in a transaction. How should i check? NOTE: I will be using this code with TSQ...

Database abstraction layer for AIR (JS)?

Hello guys, I was wondering if there are any abstraction layers for the SQLite database thats integrated into Adobe AIR. I don't expect something like Doctrine or Zend_Db (coming from the PHP world) but a bit more abstraction and comfort would be really nice. I'm using the HTML/JavaScript flavor of AIR so any ActionScript stuff is of ...

How do I do a ResultSet in SQLite in Iphone for getting a set of values and to traverse through it?

I am doing a program involving a database. I have a query that will fetch all the data from the table. But I want to traverse through each record and get each column values of each record. For that, we usually use a ResultSet. But since I am a beginner in SQLite, I dont have any idea on how to do this? Do anyone have an idea? ...

Simpler than SQLite

Do you know any SQLite-like database that stores its data in easily readable plain text format (like multi-line json or yaml)? I'd like to store some data along with my project in version control system but if I use sqlite I can't merge data changes that occurred in different working copies. I don't want to use just some kind of config...

How to set timezone for SQL?

I'm using SQLite for my cgi application, but the timezone I'm in is different from that of the shared server this stuff is running on. Can I set my timezone somehow in SQLite so I don't need to mess up my application with time conversions and I can use things like NOW() in my SQL? If not: what are my other options? ...

Displaying bold text from SQLite in UITableViewCell

We're storing text in SQLite and displaying it in UITableViewCell within our iPhone application. UITableViewCell seems to recognize line breaks from SQLite, but not bold text. Any suggestions would be much appreciated. ...

SQLite query runs 10 times slower than MSAccess query

I have a 800MB MS Access database that I migrated to SQLite. The structure of the database is as follows (the SQLite database, after migration, is around 330MB): The table Occurrence has 1,600,000 records. The table looks like: CREATE TABLE Occurrence ( SimulationID INTEGER, SimRunID INTEGER, OccurrenceID INTEGER, Occurren...

What's the correct way to ship static (read-only) data in Core Data persistent store?

I want to ship static read-only data for use in my Core Data model. The problem is that there are obviously different persistent store types and I don't know if the format of those types is supposed to be opaque or if I'm supposed to be able to construct them by hand. Right now I just have a plist and it's very small (maybe 30 entries t...

C# System.Data.SQLite Designer Code

I've been messing around with the SQLite Designer in Visual Studio 2008 and I have noticed that when I use the generated Insert/Update statements they run extremely slow. Example: I have a data table with four columns and 5700 rows it took ~5 mins to insert the data into the database table However, I wrote my own database connection an...

SQlite: select into?

I'm not sure if I can use select into to import data from another table like this: select * into bookmark1 from bookmark; Is it true that SQlite doesn't support this syntax? are there any other alternatives? ...

SQLite Virtual Table Match Escape character

Heya, I'm working on an applications where the indices are stored in a SQLite FTS3 virtual table. We are implementing full text matches which means we send through queries like: select * from blah where term match '<insert term here>' That's all well and good until the term we want to match contains a hyphen in case the SQLite virtua...

Can't rename SQLite database file after using it

I'm trying to rename my SQLite database file after I'm done using it, however the file still appears to be opened by SQLite even after all my connections are closed. Here is an example of what I'm doing: using (DbConnection conn = new SQLiteConnection("Data Source=test.db")) { conn.Open(); DbCommand command = conn.CreateCommand...