sqlite

.db file and MySQL

Hi , I am having real issues with a .db file its around 20gb in size with three tables and the rest data. I am on a mac so i am having to use some crappy apps but it wont open in Access. Does any one know what software will produce a .db file and what software will allow me to open it and export it as a CSV or MySQL file ? Also if...

DBM or SQLite in PHP 5.x

We have a client whose site is hosted on a server (I don't want to disclose hosting company name) which does not provide DB functionality. We have developed a very simple CMS based site but out implementation uses MySQL. I read somewhere that there are DB like functionality built-in in PHP. I have never used them. What are these and ...

How to store masses of data offline and then update it into an SQLite database in batch?

Currently, I am trying to fill an SQLite database with tens of thousands of text data using this this method: SQLiteConnection = new SQLiteConnection(cntnStr); connection.Open(); foreach(Page p in pages) { using (SQLiteCommand command = new SQLiteCommand(String.Format("Insert Into Pages (ID, Data, Name) Values ({0}, '{1}', '{2}')"...

sql unique and setting constraints on inserts

I have a database where I need to avoid inserting duplicates. The requirements are: For the subset of rows with matching column 1, there can not be any that have the same column 2. For the subset of rows with matching column 1, there can not be any that have the same column 3 and 4. I'm new to SQL so is there a way of setting these re...

Use CoreData or SQLite on iPhone?

Since CoreData has become available for the iPhone in OS 3.0, is it meant to be the answer to data persistence and replace all need for direct SQLite? What reasons exist to still use SQLite? What are advantages/disadvantages of SQLite vs. CoreData? ...

Active Record and Linq T4 Templates problem

I've started a C# web application project using subsonic 3.0.3 as my DAL and SQLite for database. It doesn't have any problem when using SimpleRepo, but the problem occurs when I try to use ActiveRecord/Linq T4 templates. It says "Metadata file 'System.Data.SQLite' could not be found". The settings.ttinclude is the one provided with SQLi...

DBMetal generating an invalid class for sqlite_sequence

I'm using DBLinq and DBMetal.exe to generate Linq-to-SQL like classes off an SQLite database. Every time I use DBMetal to regenerate my DataContext, it generates a class for sqlite_sequence. The trouble is is that sqlite_sequence isn't a proper table, so the class isn't complete. The question is, can DBMetal.exe do a better job of gener...

ORDER BY on different columns in different directions in SQLite

I have a table defined by: CREATE TABLE bar_table ( _id INTEGER NOT NULL PRIMARY KEY, index INTEGER NOT NULL DEFAULT '65535', _date DATE ) My basic select statement is: SELECT * FROM bar_table ORDER BY <your-clause-here> How do I order my selection by index ascending, and date descending? i.e. small indexes come before lar...

read-only sqlite database with temporary changes

I have an sqlite database, and I would like to keep it read-only without any write operations on the database file. Is there a way to make temporary modifications to the database, without flushing them to disk permanently? Right now I am doing this in a workaround way, by storing the temp data in an in-memory database with the same sc...

iPhone SQLite date problem

Database gets created just fine, and the insert works just fine. I'm having problem with the select statement below. It returns no records and no error. A select on any other field works just fine. Can anyone spot what I'm doing wrong? "create table if not exists data (pkey integer primary key, doc date)" [db executeUpdate:@"insert int...

Problem about SQLite's integer and int datatype

I meet a problem about: Object of type 'System.Int64' cannot be converted to type 'System.Int32' when run the SubSonic.Examples.SimpleRepo project base on SQLite provider. I fond that the data type for table Categories's column CategoryID is 'integer', and the 'integer' in SQLite will be return as Int64, in the same time the CategoryID'...

SQLite for client-server

Hi, I've seen a couple of SQLite performance questions here on Stackoverflow, but the focus was on websites, and I'm considering using this DB in a client-server scenario: I expect 1-10 clients for one server for now, could go up to 50 or more in the future. slightly more reads than writes the DB would sit behind a server process (i.e...

Problem about ActiveRecord Templates for SQLite

I try to using the SQLite in SubSonic.Examples.ActiveRecord project so: Add a reference for System.Data.SQLite Copy the SQLite.ttinclude and Settings.ttinclude from \T4 Templates\TemplateProviders\ to the Models_Generated\ Change the <#@ include file="SQLite.ttinclude" #> in the SQLite.ttinclude and Settings.ttinclude Change the settin...

locked s3db-journal

Hi, a few days we had a strange error with sqlite. We use a sqlite database on a network share with several computers accessing it. Our client reported, that the database is gone. A quick overview showed, that the database was still there but no computer could access it. It also showed a s3db-journal file indicating that someone is/was ...

ruby on rails sqllite problem

Hi, Am trying out Ruby on Rails in Windows XP using the Hello World example. Encountered this error ? Not sure how to fix this When I downloaded sqllite from the website, copy the dll to windows/system32. then run "gem install sqlite3-ruby". It shows up with lots of "No definition for _wrap_sqlite3_*" then in Firefox, http://loc...

Firebird .NET interoperation

Has anyone had experience with using Firebird in interoperating with the .NET framework and if so, how did it go? ...

Can sqlite load individual tables from individual files?

I've heard that SQLite can do this (to avoid synchronicity issues in heavy traffic scenarios) is this true? If so how would I do this with PDO in PHP? ...

Should I link sqlite3 as plain object code or as a static library in a C++ application?

I am building an application in C++ which uses sqlite3 as an embedded database. The source for sqlite3 is distributed as an amalgamated source code file sqlite3.c and two header files. What are the relative advantages or disadvantages of linking the sqlite3 code directly into my program binary versus compiling sqlite3 as a static libra...

Import data from SQLite to SQL Server with SqlBulkCopy class

I'm trying to transfer the data from SQLite to SQL Server. The schema of target and destination table are just the same: SQL Server: CREATE TABLE [dbo].[Shop] ( [ShopID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](128) NOT NULL, [Url] [nvarchar](128) NOT NULL, PRIMARY KEY CLUSTERED ( [ShopID] ASC )) and SQLite: ...

Storing a double.MinValue with Nhibernate to sqlite.

Hello, I am using nhibernate for my OR persistence and I store a list of doubles into a table using the following mapping (where the list is embedded in another class). <list name="Values" access="field" table="Values_double" > <key column="variable_id"/> <index column="no_data_values_list_index"/> <element column="value" type="...