Re: [sqlite] Datatype for prices (1,500)

On 2016-11-30 16:39, Werner Kleiner wrote: << All you need to store in the database table is the number. How it is formatted for viewing or printing is controlled by the user interface. yes thats right, but it would be nice to have same behavior between MySQL and sqlite I think to use a char

Re: [sqlite] Proposed new sqlite3_open_v3() in terface - offt

"Andy Gibbs" <andyg1...@hotmail.co.uk> wrote on 1.7.2010 21:12:57: >Miha Vrhovnik wrote on 1/7/2010: >> >Content analysis details: (10.3 points, 7.0 required) >> > >> > pts rule name description >> > -- >>

Re: [sqlite] Proposed new sqlite3_open_v3() in terface - offt

"Andy Gibbs" wrote on 1.7.2010 15:05:01: >Content analysis details: (10.3 points, 7.0 required) > > pts rule name description > -- -- > 2.4 DNS_FROM_OPENWHOIS RBL: Envelope sender

Re: [sqlite] sorting records in random order

I think he's trying to do sth. like that SELECT quote FROM quotes ORDER BY RAND() LIMIT 1 On 5/8/2008, "John Stanton" <[EMAIL PROTECTED]> wrote: >Sorting in random order is a definite contradiction in terms. What are >you actually trying to do? > >Barbara Weinberg wrote: >> Hi >> I was

Re: [sqlite] Unicode searches

Someone sent a sqlite3_unicode.c file to this mailing list in the last week of December, 1st week of January which implemented upper/lower and some other functions. File was released as public domain if I remember correctly and used data from Unicode 5.1 standard. As ICU brings a lot of bulk

Re: [sqlite] Sqlite3Explorer Version 3.0 is available

Hi Mike, Thanks for updated version, but still no drag n drop support for opening database files :( Regards, Miha "Cariotoglou Mike" <[EMAIL PROTECTED]> wrote on 29.11.2007 9:09:59: >New version with a lot of enhancements to the user interface, also >updated to be compatible with >the

Re: Re: [sqlite] How is the windows binary built?

> strip sqlite3.exe is not ok at least for DLL, because it strips everything even reallocation info. strip --strip-unneeded sqlite3.dll Regards, Miha "Joe Wilson" <[EMAIL PROTECTED]> wrote on 21.4.2007 5:48:00: >--- [EMAIL PROTECTED] wrote: >> I'm using cygwin under windows XP. >> gcc version

Re: Re: [sqlite] Re: How to optimize a select that gets 17 rows from a 700k row DB (via perl using DBI)?

I'm gonna cut all the content and say just one thing. If Sqlite supported table partitioning this would be piece of cake without any complications. http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html -- It's time to get rid of your current e-mail client ... ... and start using

Re: [sqlite] How to create DLL for windows?

Why don't you use mingw + msys enviroment? Google for more. Regards, Miha "Yuvaraj Athur Raghuvir" <[EMAIL PROTECTED]> je ob 3.10.2006 3:19:21 napisal(a): >Hello, > >I have sync'ed and created the exe using Cygwin on Windows. I also have the >libtool available. > >Now, I donot see the dll that

Re: [sqlite] new file / existing table testing.

"Tony Harris" <[EMAIL PROTECTED]> je ob 18.6.2006 8:03:03 napisal(a): >Or is there a way within the api that I haven't found to test for existance of >tables? SELECT name FROM sqlite_master WHERE type='table' ORDER BY name; SELECT name FROM sqlite_master WHERE type='index' ORDER BY name;

Re: Re: [sqlite] WHERE clause syntax error

>Something like: > >SELECT A.ID >FROM A >LEFT JOIN B >ON A.ID = B.ID >WHERE B.ID IS NULL > >Might be more efficient? Nope. I rewrote such query to SELECT ID FROM A WHERE ID NOT IN (SELECT ID FROM B); SELECT COUNT(*) AS unread FROM mboxes WHERE idMbox = %d AND idMsg IN (SELECT idMsg FROM

Re: [sqlite] questions about performance

>This problem has been coming up with more and more frequency. >I need to either figure out a solution or at least write up >some official documentation on it. I think that table partitioning as I purposed about a month ago would be a solution if data is of nature, that it can be partitioned

[sqlite] support for table partitioning?

Hi drh and others, Regarding the issues they appear on ML with very large tables and knowing that sqlite now enforces constraint checks on tables, is there any chances of suporting table partitoning? Regards, Miha

Re: [sqlite] support for table partitioning?

On 3/21/2006, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: >> Hi drh and others, >> >> Regarding the issues they appear on ML with very large tables and knowing >> that sqlite now en

[sqlite] bug in NOT EXISTS?

using sqlite 3.2.8. CREATE TABLE movies (id INTEGER PRIMARY KEY, catalogIDNumeric INTEGER); INSERT INTO movies (catalogIDNumeric) VALUES(1); INSERT INTO movies (catalogIDNumeric) VALUES(2); INSERT INTO movies (catalogIDNumeric) VALUES(3); INSERT INTO movies (catalogIDNumeric) VALUES(5); INSERT

Re: [sqlite] sqlite3_create_function in delphi

juan perez <[EMAIL PROTECTED]> je ob 3.12.2005 17:16:00 napisal(a): >There is a "nocase" collation for that purpose. > >jp Which works only on ASCII characters I need unicode version of Lower function. Regards, Miha

[sqlite] sqlite3_create_function in delphi

Does anybody know how to add custom function to sqlite3 in Delphi? Cariotoglou Mike? I'd like to add function 'Lower' so I can match case insenisitive text columns in table. Regards, Miha

Re: Re: [sqlite] Rewriting a query

[EMAIL PROTECTED] je ob 30.9.2005 12:22:47 napisal(a): >(Side note: I am experimenting with a new Mail User Agent that >uses SQLite to store all its email messages. I appologize in advance >if this message is misformatted or otherwise garbled.) Am. Who stole that idea from me? -- It's time to

[sqlite] Re: bug in SELECT DISTINCT ?

"Igor Tandetnik" <[EMAIL PROTECTED]> je ob 17.9.2005 16:20:03 napisal(a): >Why did you expect the latter? DISTINCT in SELECT DISTINCT detects >identical rows, not identical first columns. The three first rows with >an id of 1 differ in the columns you chose not to show (specifically in >the

[sqlite] bug in SELECT DISTINCT ?

Hi! I think there is a bug in SELECT DISTINC. I'm using sqlite 3.2.5 dll CREATE TABLE t1(id INTEGER PRIMARY KEY, d0 INTEGER, d1 TEXT); CREATE TABLE map(idT1 INTEGER , d0 INTEGER); INSERT INTO t1 VALUES(1, 1, 'dd'); INSERT INTO t1 VALUES(2, 1, 'dd'); INSERT INTO t1 VALUES(3, 1,

Re: [sqlite] Problems with threadsafe opt correction #2623

"D. Richard Hipp" <[EMAIL PROTECTED]> je ob 5.9.2005 18:45:42 napisal(a): >SQLite has *never* supported the ability of a handle to be used >by more than one thread. By luck, such use would sometimes work on >some operating systems. But it would fail on others. Such a >situation is very

RE: [sqlite] bug in sqlite 3.2.5 compila tion and ANALYZE

"Cariotoglou Mike" <[EMAIL PROTECTED]> je ob 5.9.2005 14:49:54 napisal(a): >ok. >I use sqlite3Explorer (which should not matter), I create a new >database, then I run : > >create table test1(id integer); >analyze > >this crashes immediately, with dll 3.2.5. it works fine from the >command-line. >

[sqlite] bug in ORDER BY ?

Hi, sqlite dll is 3.2.1 I have the folowing query: SELECT * FROM Mactor WHERE id < 9223372036854775807 ORDER BY id DESC LIMIT 1; where 9223372036854775807 is Maximum value of signed Int64. Table is defined as: CREATE TABLE Mactor ( id INTEGER PRIMARY KEY, name TEXT, birthName TEXT, birthday