Any tool to convert SQLite database to sql server?
DBConvert is one such tool I know. Any open source or any other product? ...
sqlite
Imitate database in C
I am fairly new to C. (I have good knowledge of C# [Visual Studio] and Java [Eclipse]) I want to make a program that stores information. My first instinct was to use a database like SQL Server. But I don't think that it is compatible with C. So now I have two options: Create a struct (also typedef) containing the data types. Find a way...
Using IN with sets of tuples in SQL (SQLite3)
I have the following table in a SQLite3 database: CREATE TABLE overlap_results ( neighbors_of_annotation varchar(20), other_annotation varchar(20), set1_size INTEGER, set2_size INTEGER, jaccard REAL, p_value REAL, bh_corrected_p_value REAL, PRIMARY KEY (neighbors_of_annotation, other_annotation) ); I would like to perform the followin...
How do I get Core Data to create an SQLite DB from my Managed Object Model
I've been strungling with Core Data. I've looked at the examples and documentation but they all seem to copy an existing SQLite DB into the working directory. I've defined my data model and just want Core Data to create a SQLite DB. I then will populate the db im my app. Can anyone show me how? ...
Python / SQLite - database locked despite large timeouts
I'm sure I'm missing something pretty obvious, but I can't for the life of me stop my pysqlite scripts crashing out with a database is locked error. I have two scripts, one to load data into the database, and one to read data out, but both will frequently, and instantly, crash depending on what the other is doing with the database at any...
Verify two columns of two different tables match exactly.
When writing views and nesting views within deeper views I sometimes miss something and end up losing rows/data. How can I check that columns from two different tables have an exact match of data? Example: select count(distinct table1.col1) from table1 where table1.col1 not in (select distinct table2.col1 ...
Will pool the connection help threading in sqlite (and how)?
I currently use a singleton to acces my database (see related question) but now when try to add some background processing everything fall apart. I read the sqlite docs and found that sqlite could work thread-safe, but each thread must have their own db connection. I try using egodatabase that promise a sqlite wrapper with thread safety ...
How to improve the speed of a loop containing a sqlalchemy query statement as conditional
This loop checks if a record is in the sqlite database and builds a list of dictionaries for those records that are missing and then executes a multiple insert statement with the list. This works but it is very slow (at least i think it is slow) as it takes 5 minutes to loop over 3500 queries. I am a complete newbie in python, sqlite and...
Is there a library / tool to query MySQL data files (MyISAM / InnoDB) without the server? (the SQLite way)
Oftentimes I want to query my MySQL data directly without a server running or without having access to the server (but having read / write rights to the files). Is there a tool or maybe even a library around to query MySQL data files like it is possible with SQLite? I'm specifically looking for InnoDB and MyISAM support. Performance is ...
system.data.sqlite .net 4
is there any .net4 version of system.data.sqlite? i get this error: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. what is "additional configuration information"? or is there another version? ...
What are the differences among sqlite3 from python2.5, pysqlite and apsw
Hi, I would like to know the differences among sqlite3 from python2.5, pysqlite and apsw? I have a bumpy run when trying to install pysqlite on windows vista with python2.5, see following: download sqlite from http://sqlite.org/download.html and unzip them into windows/system32 folder and put sqlite3.dll into c:/python25/Lib folder do...
Need suggestions for a good way to encrypt/decrypt data stored in SQLite database on Android.
Title says it all. I have some sensitive data that is stored in SQLite for an Android app. I need to be able to encrypt when persisting but then also decrypting when deserializing from the database too. Not sure what my options are on Android for doing this? ...
Can I create a datetime column with default value in sqlite3?
Is there a way to create a table in sqlite3 that has a datetime column that defaults to 'now'? The following statement returns a syntax error: create table tbl1(id int primary key, dt datetime default datetime('now')); Update: Here's the correct ddl courtesy of Sky Sanders: create table tbl1(id int primary key, dt datetime default c...
ADD COLUMN to sqlite db IF NOT EXISTS - flex/air sqlite?
I've got a flex/air app I've been working on, it uses a local sqlite database that is created on the initial application start. I've added some features to the application and in the process I had to add a new field to one of the database tables. My questions is how to I go about getting the application to create one new field that is ...
Sqlite / SQLAlchemy: how to enforce Foreign Keys?
The new version of SQLite has the ability to enforce Foreign Key constraints, but for the sake of backwards-compatibility, you have to turn it on for each database connection separately! sqlite> PRAGMA foreign_keys = ON; I am using SQLAlchemy -- how can I make sure this always gets turned on? What I have tried is this: engine = sqlal...
Conditional SQLite check constraint?
I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status text NOT NULL, enddate date, /* Checks */ CHECK (status IN ("Current", "Complete")) ); I'd like to add a constraint that requires enddate to be non-null if the status is "Complete". Is this possible? I am...
Android insert into sqlite database
I know there is probably a simple thing I'm missing, but I've been beating my head against the wall for the past hour or two. I have a database for the Android application I'm currently working on (Android v1.6) and I just want to insert a single record into a database table. My code looks like the following: //Save information to my ...
sqlite over network share for failover
As a follow-up of this question: sqlite-over-a-network-share If I put the SQlite DB on a network share, but will not access it concurrently from different machines. I only have the SQLite db stored on a share so a cluster of failover computers can take over where one machine left off. Are there any inherent problems with that approach?...
SQLite fts3: search for a string in a column
Is there any way to search for a particular string in a column? I want to search like SELECT * from email_fts WHERE email_fts MATCH 'to:"[email protected]" OR from:"[email protected]"' Thanks in advance, Manoj ...
How to store and retrieve object of a swing component in database, java
Hi I have written a small java program based on swing application. Now I want to store the object of my swing application (jframe) in database and I want to retrieve the same from database when its necessary. during retrieve i want to get the same object. I am using sqlite as database How to achieve this functionality Thanks Sunil Kuma...