Re: [sqlite] (no subject)

´¯¯¯ >No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols >are represented by 2 bytes when UTF-16 does not. And I had an >understanding that Doug said about this 16-bit guarantee. Also if >we're talking about encoding where any character can be represented by >a single variable

Re: [sqlite] DateTime comparison with custom format

On Aug 21, 2009, at 7:22 PM, Jean-Christophe Deschamps wrote: > > US "standard" for date is also completely awkward MM/DD/ as well > as > most european (german for you, french for me) formats. That is a "style" or "convention", not a "standard". The standard is defined here:

Re: [sqlite] DateTime comparison with custom format

´¯¯¯ >(btw it's the standard datetime format in germany, not custom-designed >:-P) `--- I see this as a confusion between a storage/computational format and human interface representation. US "standard" for date is also completely awkward MM/DD/ as well as most european (german for you,

Re: [sqlite] DateTime comparison with custom format

On 21 Aug 2009, at 11:37pm, Igor Tandetnik wrote: > t-master wrote: >> the problem is, this db is created by another program and I don't >> have the access to change the format > > What do you mean, don't have access? Can't you just run an UPDATE > statement once,

Re: [sqlite] DateTime comparison with custom format

2009/8/21 t-master : > Hi > I have string in a table representing a DateTime. > The format is 21.08.2009 00:25:00 > And I would like to compare it to "now" > How can I do this? > -- > View this message in context: >

Re: [sqlite] DateTime comparison with custom format

Igor Tandetnik wrote: > > t-master wrote: >> I have string in a table representing a DateTime. >> The format is 21.08.2009 00:25:00 > > I recommend you change the format. Yours is custom-designed to make your > life miserable. > >> And I would like to compare it

Re: [sqlite] PRAGMA integrity_check(integer)

On 21 Aug 2009, at 10:44pm, Chang Im (chim) wrote: > I have SQLite 2.x database and sometimes it takes a long time to run > "integrity_check" on the database. How long ? Minutes ? Hours ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] PRAGMA integrity_check(integer)

Hi, I have SQLite 2.x database and sometimes it takes a long time to run "integrity_check" on the database. Looking at the integrity_check option "(integer), we could control how many errors to return from the check. I tried the option, but it generated a syntax error. Is the option supported?

[sqlite] AIX performance

Im looking for some ideas as to why the performance for a select statement takes roughly 5 times longer on AIX as on a linux system. The disk drive on the aix platform is a 10k scsi vs the 7200 rpm drive on linux. AIX: sqlite> .timer on sqlite> .output ken.out sqlite> .read kdo.sql CPU Time:

Re: [sqlite] Reverse string comparison for searches

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) Sent: Friday, August 21, 2009 2:33 PM To: General Discussion of SQLite Database Subject: [sqlite] Reverse string comparison for searches Hello everyone,

Re: [sqlite] Reverse string comparison for searches

On Aug 21, 2009, at 2:49 PM, Shaun Seckman (Firaxis) wrote: > This is great! Exactly what I was looking for. Do you by any chance > know the function name of the standard collation used for string > comparisons? I'd like to use that as a foundation for building a new > one. > /* ** This is

Re: [sqlite] Reverse string comparison for searches

On Aug 21, 2009, at 2:33 PM, Shaun Seckman (Firaxis) wrote: > >Currently, in my database I'm storing thousands of > strings that are formatted in such a way where they share similar > prefixes (i.e. TXT_KEY_FOO, TXT_KEY_BAR). Sadly, this format cannot > be > changed so I was

Re: [sqlite] Reverse string comparison for searches

This is great! Exactly what I was looking for. Do you by any chance know the function name of the standard collation used for string comparisons? I'd like to use that as a foundation for building a new one. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Reverse string comparison for searches

Shaun Seckman (Firaxis) wrote: >Currently, in my database I'm storing thousands of > strings that are formatted in such a way where they share similar > prefixes (i.e. TXT_KEY_FOO, TXT_KEY_BAR). Sadly, this format cannot > be changed so I was wondering

Re: [sqlite] DateTime comparison with custom format

t-master wrote: > I have string in a table representing a DateTime. > The format is 21.08.2009 00:25:00 I recommend you change the format. Yours is custom-designed to make your life miserable. > And I would like to compare it to "now" select case when substr(T,

Re: [sqlite] Reverse string comparison for searches

Unfortunately, not all the prefixes are the same or even the same width, they just all share very similar prefixes. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor Sent: Friday, August 21, 2009 2:37 PM To: General

Re: [sqlite] DateTime comparison with custom format

On 21 Aug 2009, at 7:25pm, t-master wrote: > I have string in a table representing a DateTime. > The format is 21.08.2009 00:25:00 > And I would like to compare it to "now" > How can I do this? If you need to know whether it's before or after instead of just equal, then you're going to need

[sqlite] ANN: StepSqlite PL/SQL Compiler for SQLite released

Hi! Metatranz StepSqlite Team is happy to announce the alpha release of StepSqlite - a powerful, web-based PL/SQL compiler for SQLite. The alpha version is available FREE to try out in your browser at http://www.metatranz.com/stepsqlite Features = 1. Compile Targets: x86 linux and

Re: [sqlite] Reverse string comparison for searches

On Fri, Aug 21, 2009 at 1:33 PM, Shaun Seckman (Firaxis) wrote: > Hello everyone, > >                Currently, in my database I'm storing thousands of > strings that are formatted in such a way where they share similar > prefixes (i.e. TXT_KEY_FOO, TXT_KEY_BAR).  Sadly,

[sqlite] Reverse string comparison for searches

Hello everyone, Currently, in my database I'm storing thousands of strings that are formatted in such a way where they share similar prefixes (i.e. TXT_KEY_FOO, TXT_KEY_BAR). Sadly, this format cannot be changed so I was wondering if it would be possible and perhaps faster to

[sqlite] DateTime comparison with custom format

Hi I have string in a table representing a DateTime. The format is 21.08.2009 00:25:00 And I would like to compare it to "now" How can I do this? -- View this message in context: http://www.nabble.com/DateTime-comparison-with-custom-format-tp25085040p25085040.html Sent from the SQLite mailing

Re: [sqlite] (no subject)

Doug, 3. "How are your strings stored in your program?  If they are stored with wchar_t, then using the '16' APIs is probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc)." I have no idea how they are stored, but I would guess as "standard" ASCII. Other community members have

Re: [sqlite] (no subject)

> Is there really anyone using UCS-2 now or did you mean UTF-16? No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols are represented by 2 bytes when UTF-16 does not. And I had an understanding that Doug said about this 16-bit guarantee. Also if we're talking about encoding where

Re: [sqlite] (no subject)

Hi Pavel, ´¯¯¯ >So conversion between wchar_t and >UCS-2 encoding is not always as easy as you can think. `--- Is there really anyone using UCS-2 now or did you mean UTF-16? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Is rowid sequential?

2009/8/21 John Loveys : > Hi All > I am hoping the rowid is sequential.  Then I can simply get the biggest > rowid (using sqlite3_last_insert_rowid), subtract N from it and delete rows > where rowid < last_rowid - N.  Can anyone confirm the rowid is guaranteed > sequential

[sqlite] Is rowid sequential?

Hi All I have an extremely simple little database with one table. I have an embedded app that keeps the database open forever and this table is manipulated by a single thread. I need to make sure this table doesn't get too big - no more than N rows. There is a Start_Time column which holds

Re: [sqlite] (no subject)

> If they are stored with wchar_t, then using the '16' APIs is > probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc). Just don't forget that wchar_t on some platforms (reportedly on Linux for example) is 32-bit integer. So conversion between wchar_t and UCS-2 encoding is not

Re: [sqlite] (no subject)

Hi Erick -- I can only help a little with #3. How are your strings stored in your program? If they are stored with wchar_t, then using the '16' APIs is probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc). That's what I do and all sorts of European and Asian customers don't

Re: [sqlite] Date range in the WHERE clause

Igor Tandetnik wrote: > Angus March wrote: > >> Igor Tandetnik wrote: >> >>> Angus March wrote: >>> >>> I have a table where I need to record the date of each insert. Sometime later I'll then delete all rows that were inserted more than 90 days ago. Is it possible to

Re: [sqlite] Copying an open db file

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Angus March wrote: > I want to copy a db file while it is still open, Have you considered the API specifically designed for this? http://www.sqlite.org/c3ref/backup_finish.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9

Re: [sqlite] Date range in the WHERE clause

Angus March wrote: > Igor Tandetnik wrote: >> Angus March wrote: >> >>> I have a table where I need to record the date of each insert. >>> Sometime later I'll then delete all rows that were inserted more >>> than 90 days ago. Is it possible to do this w/out performing a >>> table scan? >>> >> >>

Re: [sqlite] Date range in the WHERE clause

Igor Tandetnik wrote: > Angus March wrote: > >> I have a table where I need to record the date of each insert. >> Sometime later I'll then delete all rows that were inserted more than >> 90 days ago. Is it possible to do this w/out performing a table scan? >> > > Create an index on the

Re: [sqlite] Date range in the WHERE clause

Angus March wrote: > I have a table where I need to record the date of each insert. > Sometime later I'll then delete all rows that were inserted more than > 90 days ago. Is it possible to do this w/out performing a table scan? Create an index on the date column. Igor Tandetnik

Re: [sqlite] having problem in creating new database in MAC OS

On 8/21/09 14:18 , "shakeeb khan" wrote: > tell me what is a proper way of > creating database in sqllite Here is a sample terminal session on my Mac (possibly very poorly reformatted by my mail client): jdmbook:~ klee$ sqlite3 mydb.db SQLite version 3.6.12 Enter ".help"

[sqlite] Date range in the WHERE clause

I have a table where I need to record the date of each insert. Sometime later I'll then delete all rows that were inserted more than 90 days ago. Is it possible to do this w/out performing a table scan? ___ sqlite-users mailing list

Re: [sqlite] having problem in creating new database in MAC OS

shakeeb khan wrote: > i want to make a database in sqlite using MAC terminal but having > problem in creating.kinldy tell me a proper syntax > > i was trying : "sqlite>sqlite mydb.db " > > it shows me "-->" and hault the program kinldy tell me what is a > proper way of creating database in sqllite

[sqlite] having problem in creating new database in MAC OS

Hi, i want to make a database in sqlite using MAC terminal but having problem in creating.kinldy tell me a proper syntax i was trying : "sqlite>sqlite mydb.db " it shows me "-->" and hault the program kinldy tell me what is a proper way of creating database in sqllite Thanks, -shakeeb