[sqlite] development vs production

I see that sqlite is great for development but for production would that be a bright idea? see ya sebey ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is this Sorting order right?

What about Japanese Kanji? Will sqlite sort all the Hiragana,Katakana,Kanji. I am having some records with starting Unicode as follows. 6B4C Kanji 歌手生活25周却記念 北島三石1 30A2 Katakana アンテナ I am storing it using sqlite3_bind_text16(). But if I sort the above two the Unicode with

Re: [sqlite] development vs production

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sebastian stephenson wrote: I see that sqlite is great for development but for production would that be a bright idea? http://sqlite.org/famous.html There are many many other people using it production, such as the majority of people on this

[sqlite] sqlite2 download ?

Hi All, where do I find the latest sqlite2 tarball ? Thanks for supporting, Mike ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is this Sorting order right?

Mahalakshmi.m [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What about Japanese Kanji? Will sqlite sort all the Hiragana,Katakana,Kanji. Not out of the box. You will have to implement a custom collation. Or, you can build SQLite with ICU support, then it will use ICU collation

Re: [sqlite] development vs production

2008/5/10 sebastian stephenson [EMAIL PROTECTED]: I see that sqlite is great for development but for production would that be a bright idea? see ya it you develop a single user embedded sw than sqlite is a good solution, if you develop a db for a really BIG with many concurrent write access

Re: [sqlite] development vs production

On Sat, 10 May 2008, sebastian stephenson wrote: I see that sqlite is great for development but for production would that be a bright idea? In addition to Roger's comment, take a look at the web site. The home page shows that Adobe, Mozilla, and Symbian are sponsors. Why would you

Re: [sqlite] sqlite2 download ?

On Sat, May 10, 2008 at 4:38 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: where do I find the latest sqlite2 tarball ? If you have a cvs client: (from http://www.sqlite.org/download.html) All SQLite source code is maintained in a CVS repository that is available for read-only access by

Re: [sqlite] sqlite2 download ?

Thanks Keith, found them here: http://www.sqlite.org/sqlite-source-2_8_17.zip On Sat, 10 May 2008 07:08:44 -0700 Keith Goodman [EMAIL PROTECTED] wrote: On Sat, May 10, 2008 at 4:38 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: where do I find the latest sqlite2 tarball ? If you have a

Re: [sqlite] development vs production

SQLite is rock solid. Also I don't think it wise to develop on a different DBMS that the one you are going to use in production. sebastian stephenson wrote: I see that sqlite is great for development but for production would that be a bright idea? see ya sebey

[sqlite] Another vfs redesign consideration

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Some methods such as xRead return an error that is sometimes considered a success such as SQLITE_IOERR_SHORT_READ. This significantly complicates things in wrappers as sqlite errors map to exceptions, and so sometimes they need to be cleared and

Re: [sqlite] development vs production

On Sat, 2008-05-10 at 10:11 -0700, Jim Dodgen wrote: SQLite is rock solid. Also I don't think it wise to develop on a different DBMS that the one you are going to use in production. Perhaps Sebastian Stephenson was referring to the stand-in for an enterprise database during demos or testing

[sqlite] CASE WHEN sample ?

Hi, I am searching for a sample that uses the case when expression. I like to insert values into a table when these values are not in that table before. My tries to read, understand and try the documentation of expressions failed. Executing this statemen twice creates two rows: replace into

Re: [sqlite] CASE WHEN sample ?

Lothar Behrens [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Executing this statemen twice creates two rows: replace into anwendungen (name) values ('lbDMF Manager') Make name column unique, or create a unique index on it. Igor Tandetnik

Re: [sqlite] CASE WHEN sample ?

Better would be Insert into tablea(ida, value1a) Select idb, value1b from tableb where idb not in(select ida from tablea); Woody from his pda -Original Message- From: Lothar Behrens [EMAIL PROTECTED] Sent: Saturday, May 10, 2008 2:23 PM To: sqlite-users@sqlite.org