Re: [sqlite] SQLITE_ENABLE_ATOMIC_WRITE on windows, good or bad?

On Mon, Sep 13, 2010 at 8:59 PM, Sam Carleton wrote: > When compiling sqlite for Windows desktop OS's (XP, Vista, Win7), should > SQLITE_ENABLE_ATOMIC_WRITE be set or not? > Makes no difference really - windows does not support atomic writes. So the atomic write

Re: [sqlite] Importing csv to SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/13/2010 04:06 PM, BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. SQLite

[sqlite] SQLITE_ENABLE_ATOMIC_WRITE on windows, good or bad?

When compiling sqlite for Windows desktop OS's (XP, Vista, Win7), should SQLITE_ENABLE_ATOMIC_WRITE be set or not? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Importing csv to SQLite

BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. > > On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > >> This is true. You

Re: [sqlite] Importing csv to SQLite

All this talk of replacing multiple commas with pipes, then replacing pipes and so on, though clever and helpful is problematic, cumbersome and even comical for a mature product like SQLite. On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > This is true. You are right. You might argue that

[sqlite] Building On AIX 6.1 Upgraded From 5.3

I am trying to install the perl module DBD::SQLite. Since it didn't work, I figured I would start with SQLite (amalgamation tar ball 3.7.2). I am on AIX 6.1 (upgraded from 5.3) using gcc 4.2.0 which is compiled for 5.3 I have two theories based on some limited research: 1. I need to use the

Re: [sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?

thanks Ralf, nice db-browser, and conversion seems to work. cheers, Stef On 13-09-2010 11:03, Ralf Junker wrote: > On 11.09.2010 20:42, Stef Mientki wrote: > >> is there a program that converts sqlite database from windows-1252 to utf-8? > Yes, SQLiteSpy does this: > > * Open database file > *

Re: [sqlite] Importing csv to SQLite

Rich Shepard wrote: On Mon, 13 Sep 2010, Mithun Nair wrote: When i try importing it into a SQLite table, i get some errors like "expected 2 columns of data but found 1". Later i found that importing a comma separated file into SQlite wont work because a comma is considered as a delimiter by

Re: [sqlite] Importing csv to SQLite

On Mon, 13 Sep 2010, Mithun Nair wrote: > When i try importing it into a SQLite table, i get some errors like > "expected 2 columns of data but found 1". Later i found that importing a > comma separated file into SQlite wont work because a comma is considered > as a delimiter by the the SQLite

Re: [sqlite] Importing csv to SQLite

On 13 Sep 2010, at 11:53am, Mithun Nair wrote: > Its a comma separated file. > When i try importing it into a SQLite table, i get some errors like "expected > 2 columns of data but found 1". Later i found that importing a comma > separated file into SQlite wont work because a comma is

[sqlite] Importing csv to SQLite

Hello everyone, I had a small doubt regarding importing CSV files into SQLite. I have this simple text file with a couple of columns and a few records. Its a comma separated file. When i try importing it into a SQLite table, i get some errors like "expected 2 columns of data but found

[sqlite] Difficulty with sqlite3_backup_init

Sir I wanted to back up my database... I was basically on the look out for the C APIS which would perform the exact same thing as .backup in cli mode. From a link i got redirected to a page.. where i came to know of sqlite3_backup i tried it but I was not able to get it working .. Maybe i am

Re: [sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?

On 11.09.2010 20:42, Stef Mientki wrote: > is there a program that converts sqlite database from windows-1252 to utf-8? Yes, SQLiteSpy does this: * Open database file * Menu Execute -> Text to Unicode Conversion. * Select tables and columns to convert. * Choose database codepage. * Press OK to

Re: [sqlite] memory wasted shm mapped file (3.7.2)

Ok I think that the latest patch I used to try the WAL is the patch that fix the problem. I do not get wasted memory by mapped file ;) good job. Anyway I leave the application running this day. If I have news I'll tell you. Just a question: when you plan to release a new version of sqlite