[sqlite] Database corruption with fts table after closing/reopening the database

Hello, I'm testing the fts extensions and experiencing a 'database disk image is malformed' problem that I can reproduce the following way: - Create a database - Open the database to insert/update rows. 'match' queries work at this point - Close the database - Open the database. 'match' queries

Re: [sqlite] sqlite3_step getting core dumbed.

On 10 Feb 2012 at 07:55, bhaskarReddy wrote: > PRAGMA table_info(yourtablename); will display colNumber, colName, colType, > > ex: 0|slotId|INTEGER|0||0 > 1|ponChannelId|INTEGER|0||0 > 2|onuType|INTEGER|0||0 > 3|onuSerialNumber|TEXT|0||0 > 4|onuId|INTEGER|0||0 >

Re: [sqlite] Database corruption with fts table after closing/reopening the database

On Fri, Feb 10, 2012 at 5:20 AM, Julien LF wrote: > Hello, > > I'm testing the fts extensions and experiencing a 'database disk image > is malformed' problem that I can reproduce the following way: > - Create a database > - Open the database to insert/update rows.

Re: [sqlite] Database corruption with fts table after closing/reopening the database

> Did you try surrounding them strings with single quotes, instead ? I got the same problem using single quotes. However the machine I was performing those tests on is a vmware virtual machine. Performing the same steps on physical hardware (identical os & sqlite version) worked fine, so I guess

[sqlite] Phrase in the docs

Hi, working with sqlite and mysql, noticed that they're different in regard of mixed types. Select '24' < 25 Select 24 < 25 have the same results in MySql and different sqlite. Actually it's no news (my sqlite queries contained CAST(.. as INT) ), but I decided to look at the docs and noticed

Re: [sqlite] Database corruption with fts table after closing/reopening the database

On 10 Feb 2012, at 11:01am, Julien LF wrote: >> Did you try surrounding them strings with single quotes, instead ? > > I got the same problem using single quotes. > However the machine I was performing those tests on is a vmware virtual > machine. > Performing the same steps on physical

[sqlite] Database locked in multi process scenario

I have a 'database is locked' issued which can be reproduced as follows. I have two applications opening the database in WAL mode. The threading mode is SERIALIZED. Environment is PC/Linux. Step1: Launch App1 followed by App 2 ( same executables) Step 2: App1 Prepares a SELECT statement and

Re: [sqlite] Interpolation

I've rethought the interpolation strategy. It's not important to be able to look up any timestamp, just the timestamps that actually have values in at least one table. Let's say I have N tables, each with a timestamp as primary key. For instance: tab1: timestamp|value1|value2 1328873000|1|2

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 6:47 AM, Sreekumar TP wrote: > I have a 'database is locked' issued which can be reproduced as follows. > > I have two applications opening the database in WAL mode. The threading > mode is SERIALIZED. Environment is PC/Linux. > > > > Step1:

Re: [sqlite] Phrase in the docs

On Fri, Feb 10, 2012 at 6:11 AM, Max Vlasov wrote: > Hi, > working with sqlite and mysql, noticed that they're different in regard of > mixed types. > Select '24' < 25 > Select 24 < 25 > have the same results in MySql and different sqlite. > > Actually it's no news (my

Re: [sqlite] Database locked in multi process scenario

How is this different from two threads each with a db connection in a single process? Moreover the journal mode is WAL. Hence the writer should be able to append changes to the WAL file as there are no other write transaction. Sreekumar On Feb 10, 2012 6:22 PM, "Richard Hipp"

Re: [sqlite] Interpolation

Steinar Midtskogen wrote: > Let's say I have N tables, each with a > timestamp as primary key. For instance: > > tab1: > timestamp|value1|value2 > 1328873000|1|2 > 1328873100|3|4 > 1328873200|5|6 > > tab2: > timestamp|value3 > 1328873050|7 > 1328873150|8 > 1328873250|9 >

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 11:47am, Sreekumar TP wrote: > I have a 'database is locked' issued which can be reproduced as follows. > > I have two applications opening the database in WAL mode. The threading > mode is SERIALIZED. Environment is PC/Linux. > > > > Step1: Launch App1 followed by App 2

Re: [sqlite] Phrase in the docs

On Fri, Feb 10, 2012 at 4:53 PM, Richard Hipp wrote: > On Fri, Feb 10, 2012 at 6:11 AM, Max Vlasov wrote: > > > Hi, > > working with sqlite and mysql, noticed that they're different in regard > of > > mixed types. > > Select '24' < 25 > > Select 24 < 25

Re: [sqlite] Database locked in multi process scenario

Hi Simon, well, the 'wait' is a simulation of what happens in the real code. The error is fatal to the application as it never ever recovers from it even though the writer has finalized and terminated. Sreekumar On Feb 10, 2012 6:57 PM, "Simon Slavin" wrote: > > On 10

Re: [sqlite] Interpolation

[Igor Tandetnik] >> timestamp|value1|value2|value3|value4|value5|value6 >> 1328873000|1|2| | | | >> 1328873050| | |7| | | >> 1328873075| | | |10|13|16 >> 1328873100|3|4| | | | >> 1328873150| | |8| | | >> 1328873175| | | |11|14|17 >> 1328873200|5|6| | | | >> 1328873250| | |9| | | >>

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 1:32pm, Sreekumar TP wrote: > well, the 'wait' is a simulation of what happens in the real code. > > The error is fatal to the application as it never ever recovers from it > even though the writer has finalized and terminated. In a multi-process environment I recommend that

Re: [sqlite] Phrase in the docs

Max Vlasov wrote: > On Fri, Feb 10, 2012 at 4:53 PM, Richard Hipp wrote: >> In the statement: >> >>SELECT '25' < 25; >> >> There are no columns, only literals. And hence no affinity is applied. > > So if a string looks like a numeral it should be

Re: [sqlite] Database locked in multi process scenario

In the real code, there is no sleep/wait or pause. It so happens that the write of the app2 is scheduled in between. What you are suggesting is that at any point of time only one process can have a transaction open in a database? Sreekumar On Feb 10, 2012 7:12 PM, "Simon Slavin"

Re: [sqlite] Interpolation

Steinar Midtskogen wrote: > [Igor Tandetnik] > >>> timestamp|value1|value2|value3|value4|value5|value6 >>> 1328873000|1|2| | | | >>> 1328873050| | |7| | | >>> 1328873075| | | |10|13|16 >>> 1328873100|3|4| | | | >>> 1328873150| | |8| | | >>> 1328873175| | |

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 1:52pm, Sreekumar TP wrote: > In the real code, there is no sleep/wait or pause. It so happens that the > write of the app2 is scheduled in between. > > What you are suggesting is that at any point of time only one process can > have a transaction open in a database? I

Re: [sqlite] Database locked in multi process scenario

I'm not sure I'm even following how this scenario can happen. Doesn't App1 have a Shared lock on the DB? Doesn't App2 require an Exclusive lock before it can update something? When given the initial scenario, I thought that Step 5 would block waiting for App1 to finalize. > -Original

Re: [sqlite] Database locked in multi process scenario

Isn't it almost a requirement of a transaction that only one be open at a time in a database? If there could be more than one transaction, then transaction 1 might start, transaction 2 starts, transaction 1 fails, transaction 1 is rolled back, and what happens to transaction 2? One could

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 9:01 AM, Marc L. Allen wrote: > I'm not sure I'm even following how this scenario can happen. Doesn't > App1 have a Shared lock on the DB? Doesn't App2 require an Exclusive lock > before it can update something? > The OP is running in WAL

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 9:05 AM, Rob Richardson wrote: > Isn't it almost a requirement of a transaction that only one be open at a > time in a database? If there could be more than one transaction, then > transaction 1 might start, transaction 2 starts, transaction 1

Re: [sqlite] Phrase in the docs

On Fri, Feb 10, 2012 at 5:45 PM, Igor Tandetnik wrote: > Value has TEXT affinity, 5 has none. So 5 is converted to '5', and then > lexicographic comparisons are performed. It so happens that all strings in > the Value column lexicographically precede '5'. > > If you wanted

Re: [sqlite] Database locked in multi process scenario

So, you're assuming the OP actually started a transaction? Because, otherwise, isn't the SELECT in step 2 and the UPDATE in step 5 separate transactions? If there is a BEGIN in there somewhere, we're talking about: App1: BEGIN SELECT UPDATE .. App2BEGIN

Re: [sqlite] sqlite3_close() blocked data base file

i think fixed:: http://synopse.info/forum/viewtopic.php?id=20 -- View this message in context: http://old.nabble.com/sqlite3_close%28%29-blocked-data-base-file-tp33292831p33300699.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 9:19 AM, Marc L. Allen wrote: > > So, you're assuming the OP actually started a transaction? Because, > otherwise, isn't the SELECT in step 2 and the UPDATE in step 5 separate > transactions? > The OP said "Step 3: The statement is not reset

Re: [sqlite] Database locked in multi process scenario

I see. So, the implied commit doesn't occur until you finalize? As a result, the subsequent update in step 5 was added to his non-finalized select? Still.. what is the correct way to handle the explicit scenario? I mean, having one process do a BEGIN SELECT UPDATE and another do BEGIN UPDATE

Re: [sqlite] Database locked in multi process scenario

Marc L. Allen wrote: > I see. So, the implied commit doesn't occur until you finalize? Or reset. > As a result, the subsequent update in step 5 was added to his > non-finalized select? The update was attempted within the same transaction. > Still.. what is the

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 9:32 AM, Marc L. Allen wrote: > I see. So, the implied commit doesn't occur until you finalize? As a > result, the subsequent update in step 5 was added to his non-finalized > select? > > Still.. what is the correct way to handle the explicit

Re: [sqlite] Database locked in multi process scenario

Thanks so much for clarifying that. I was unaware of the BEGIN IMMEDIATE. Sorry.. new to sqlite, used to MySQL and MSSQL. > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Friday, February 10,

Re: [sqlite] Interpolation

[Igor Tandetnik] > Steinar Midtskogen wrote: >> >> Thanks, I didn't think in that simple terms. :) I think about listing >> all the values, so I got lost. I lost a word there: "I didn't think about listing"... >> >> But what if the tables share a timestamp, then I

Re: [sqlite] Database locked in multi process scenario

Sreekumar TP wrote: > How is this different from two threads each with a db connection in a > single process? If each thread uses its own separate connection, it should be no different - you would observe the same issue. > Moreover the journal mode is WAL. Hence the

Re: [sqlite] Interpolation

Steinar Midtskogen wrote: > [Igor Tandetnik] >> Try something like this: >> >> select timestamp, value1, ..., value6 from >> (select timestamp from tab1 >> union >> select timestamp from tab2 >> union >> select timestamp from tab3) >> left join tab1 using (timespamp)

Re: [sqlite] Database locked in multi process scenario

The last transaction should always be the final one. In a a multiprocess/threaded application how can one make assumptions on the order of updates? Sreekumar On Fri, Feb 10, 2012 at 8:16 PM, Igor Tandetnik wrote: > Sreekumar TP wrote: > > How is

Re: [sqlite] Database locked in multi process scenario

One last question or series (I hope)... >From my background, I'm used to SQL statements blocking until appropriate >locks are acquired. From what I've seen, it looks like sqlite doesn't block, >but returns BUSY, is that correct? If two processes start a BEGIN IMMEDIATE, will one return a BUSY

Re: [sqlite] Database locked in multi process scenario

I took traces of the lock/unlock pattern - After App1 SELECT -- fcntl -1212610880 7 SETLK WRLCK 124 1 0 0 WAL806F9D8: acquire EXCLUSIVE-READ-LOCK[1] cnt=1 ok fcntl -1212610880 7 SETLK UNLCK 124 1 0 0 WAL806F9D8: release EXCLUSIVE-READ-LOCK[1] cnt=1 fcntl -1212610880 7 SETLK RDLCK

Re: [sqlite] Interpolation

[Igor Tandetnik] > If you need a particular order, it's best to add an explicit ORDER BY. > Otherwise, you are at the mercy of an implementation. Your current version of > SQLite chooses an execution plan that happens, by accident, to produce rows > in the desired order. Tomorrow you upgrade

[sqlite] VS2008 design support error

I have been trying to get the system.data.sqlite version 1.0.79 working with Visual Studio 2008 Pro (with SP). Each time I try to use Add Connection to create the database connection string, the system.sqlite.data, I VS2008 is popping up an error dialog: Package Load Failure Package

[sqlite] Sql Unions

We are looking at using SqlLite from an access application, but we have run into troubles executing a query that has a UNION. Does SqlLite support Unions? Any help you can provide would be appreciated. ___ sqlite-users mailing list

Re: [sqlite] multiple rows of VALUES in an INSERT incompatible with SQLITE_OMIT_COMPOUND_SELECT

On 07.02.2012 12:28, Ralf Junker wrote: > The new feature to insert multiple rows of VALUES in a single INSERT > > http://www.sqlite.org/src/info/eb3b6a0ceb > > gives wrong results if SQLite is compiled with SQLITE_OMIT_COMPOUND_SELECT. Has the team seen this or has it been overlooked? Shall

Re: [sqlite] Sql Unions

What is the query , and what error do you encounter ? SQLite does support UNION and UNION ALL Regards nobre David Hubbard-4 wrote: > > We are looking at using SqlLite from an access application, but we have > run > into troubles executing a query that has a UNION. > Does SqlLite support

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 3:01pm, Marc L. Allen wrote: > From my background, I'm used to SQL statements blocking until appropriate > locks are acquired. From what I've seen, it looks like sqlite doesn't block, > but returns BUSY, is that correct? You can set a timeout. SQLite tries and retries

Re: [sqlite] Interpolation

On 10 Feb 2012, at 3:24pm, Steinar Midtskogen wrote: > I feared that. As it is, it takes 6 seconds to do a SELECT * FROM > Combined LIMIT 1 ("Combined" is a view representing the merged table). > If I add an ORDER BY, it takes 35 seconds. > > Any way to speed up the ordering? Are you putting

Re: [sqlite] Database locked in multi process scenario

There is no recovery from this situation- If you try to rollback, you get the following error -"cannot rollback savepoint, SQL statments in progress" or if you dont use SAVEPOINT - "cannot rollback, no transaction is active " If you start the transaction with BEGIN IMMEDIATE in App1, the writer

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 4:45pm, Sreekumar TP wrote: > There is no recovery from this situation- > > If you try to rollback, you get the following error -"cannot rollback > savepoint, SQL statments in progress" or if you dont use SAVEPOINT - > "cannot rollback, no transaction is active " > If you

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 9:57 AM, Sreekumar TP wrote: The last transaction should always be the final one. In a a multiprocess/threaded application how can one make assumptions on the order of updates? There are two updates in my example: update t set count = count + 1; update t set count = count + 10;

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 11:45 AM, Sreekumar TP wrote: There is no recovery from this situation- If you try to rollback, you get the following error -"cannot rollback savepoint, SQL statments in progress" or if you dont use SAVEPOINT - "cannot rollback, no transaction is active" If you start the

Re: [sqlite] Database locked in multi process scenario

Though the example of $ is very intuitive, I am not suggesting that we drop one of the transaction and block the database forever (as it is happening now). Instead, it could be serialized such that two $100 transactions are committed to the db. On Fri, Feb 10, 2012 at 10:33 PM, Igor Tandetnik

Re: [sqlite] Database locked in multi process scenario

> On 2/10/2012 9:57 AM, Sreekumar TP wrote: > >> The last transaction should always be the final one. In a a >> multiprocess/threaded application how can one make assumptions on the >> order >> of updates? SQL does not have any concept of 'last transaction' or 'final transaction' or 'order of

Re: [sqlite] Database locked in multi process scenario

Can this situation be handled in sqlite - by upgrading the lock to a writer lock ? Since both applications use the same WAL file for read and writes, it shouldnt be a problem , because all changes will be in linear sequence ? Sreekumar On Fri, Feb 10, 2012 at 10:49 PM, Sreekumar TP

Re: [sqlite] Database locked in multi process scenario

2012/2/10 Sreekumar TP : >  Though the example of $ is very intuitive, I am not suggesting that we > drop one of the transaction and block the database forever (as it is > happening now). Instead, it could be serialized such that two $100 > transactions are committed to the

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 5:29pm, Sreekumar TP wrote: > Can this situation be handled in sqlite - by upgrading the lock to a > writer lock ? Since both applications use the same WAL file for read and > writes, it shouldnt be a problem , because all changes will be in linear > sequence ? SQLite

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 11:45 AM, Sreekumar TP wrote: > There is no recovery from this situation- > The recovery from your situation is to reset or finalize the initial query that is holding the transaction option. > > If you try to rollback, you get the following error

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 5:32pm, Kit wrote: > 2012/2/10 Sreekumar TP : >> Though the example of $ is very intuitive, I am not suggesting that we >> drop one of the transaction and block the database forever (as it is >> happening now). Instead, it could be serialized such that

Re: [sqlite] Interpolation

[Simon Slavin] > On 10 Feb 2012, at 3:24pm, Steinar Midtskogen wrote: > >> I feared that. As it is, it takes 6 seconds to do a SELECT * FROM >> Combined LIMIT 1 ("Combined" is a view representing the merged table). >> If I add an ORDER BY, it takes 35 seconds. >> >> Any way to speed up the

Re: [sqlite] Database locked in multi process scenario

2012/2/10 Simon Slavin : > On 10 Feb 2012, at 5:32pm, Kit wrote: >> A situation in which I read from the database first and then changes >> the data tells me that they are wrong questions. It is such a problem >> to insert SELECT into UPDATE or INSERT? > > Why do you need to

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 5:55pm, Kit wrote: > 2012/2/10 Simon Slavin : >> On 10 Feb 2012, at 5:32pm, Kit wrote: >>> A situation in which I read from the database first and then changes >>> the data tells me that they are wrong questions. It is such a problem >>> to insert SELECT

Re: [sqlite] Sql Unions

We are running this from an access front end and the simplest example of a query that generates this error is: SELECT MDR.MDR_No FROM MDR UNION SELECT MDR_Archive.MDR_No FROM MDR_Archive; The error is: ODBC--call failed. near "(": syntax error (1) (#1) and MDR_No is a string field. On Fri,

Re: [sqlite] Sql Unions

On Fri, Feb 10, 2012 at 1:17 PM, David Hubbard wrote: > We are running this from an access front end and the > simplest example of a query that generates this error is: > > SELECT MDR.MDR_No > FROM MDR > UNION > SELECT MDR_Archive.MDR_No > FROM MDR_Archive; > The above is

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Hi, Not sure if anyone has suggested this already but rather than messing with the shell and bat files, cant you write a little program which reads the database, outputs a CSV file and puts it wherever it needs putting Andy

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Would this be able to run on windows mobile or windows ce? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrew Barnes Sent: Friday, February 10, 2012 1:46 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Compiling

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 12:29 PM, Sreekumar TP wrote: Can this situation be handled in sqlite - by upgrading the lock to a writer lock ? Since both applications use the same WAL file for read and writes, it shouldnt be a problem , because all changes will be in linear sequence ? Consider again: [1]

Re: [sqlite] Database locked in multi process scenario

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Friday, February 10, 2012 2:36 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Database locked in multi process scenario > > On 2/10/2012

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

I still wasn't able to get this to work. It doesn't do anything. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Thursday, February 09, 2012 3:04 PM To: General Discussion of SQLite Database Subject:

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 2:57 PM, Marc L. Allen wrote: MSSQL in its default serialization mode does not guarantee repeatable reads within a transaction. But, it provides locking hints to help enforce it when required. I'm guessing that sqlite does guarantee repeatable reads? SQLite implements only one

Re: [sqlite] VS2008 design support error

Trevor Burns wrote: > > Package Load Failure > Package 'System.Data.SQlite Designer Package' has failed to load properly ( > GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package > vendor for assistance. Application restart is recommended, due to possible > environment

Re: [sqlite] VS2008 design support error

Trevor Burns wrote: > > Package Load Failure > Package 'System.Data.SQlite Designer Package' has failed to load properly ( > GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package > vendor for assistance. Application restart is recommended, due to possible > environment

Re: [sqlite] Slow inserts in indexed table

Modification of big index-tree is disk-expensive operation. You can try to insert pre-sorted data. Did yoy search only by equals conditions? Did you think about packing a set of values in single string or blob like to Insert into t1 values ('1 2 3 4 5 6 7 8 9'); You can search by string content

Re: [sqlite] Elegant printout of table (with header) via TCL

See pragma table_info 2012/2/9 rod : > My apologies if this question should be directed to some other list. > > I'm looking for a better way to printout the: > Column Headers, > followed by the table contents - > in comma separated value (csv) format > from a SELECT

Re: [sqlite] Sql Unions

I suspected the odbc layer, but is there any type of logging for SqlLite to verify the sql it gets? On Fri, Feb 10, 2012 at 11:37 AM, Richard Hipp wrote: > On Fri, Feb 10, 2012 at 1:17 PM, David Hubbard > wrote: > > > We are running this from an access

Re: [sqlite] Sql Unions

On Fri, Feb 10, 2012 at 5:28 PM, David Hubbard wrote: > I suspected the odbc layer, but is there any type of logging for SqlLite to > verify the sql it gets? > No. We've always assumed that the application developer knows what he is sending into SQLite, or else can write

Re: [sqlite] Sql Unions

I will check and get back to you. I have not really studied it. On Fri, Feb 10, 2012 at 3:52 PM, Richard Hipp wrote: > On Fri, Feb 10, 2012 at 5:28 PM, David Hubbard > wrote: > > > I suspected the odbc layer, but is there any type of logging for SqlLite >

Re: [sqlite] VS2008 design support error

Joe After getting the update on the changes I downloaded the installer from the website (the publish dates match today). When I used the installer, the same error message occurred. So I downloaded the VS2008 SDK 1.1, installed, and the "add connection" screen is working. Thanks for your help.

Re: [sqlite] Elegant printout of table (with header) via TCL

2012/2/9 rod : > My apologies if this question should be directed to some other list. > > I'm looking for a better way to printout the: > Column Headers, > followed by the table contents - > in comma separated value (csv) format > from a SELECT statement: > On Fri, Feb

[sqlite] SQLite Random number generator

Hi All, how do you generate a random number between two numbers in your query using the random() function? Thank's. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Random number generator

On 2/10/2012 10:52 PM, Rick Guizawa wrote: Hi All, how do you generate a random number between two numbers in your query using the random() function? Thank's. select random() % (:high - :low) + :low; -- Igor Tandetnik ___ sqlite-users mailing list

[sqlite] custom property db/editor

I need to develop a light-weight, custom property editor using SQLite, Perl, thttpd and HTML/CSS for building and editing recipes. I'm thinking of something like the classic "folder/tree/property sheet" interface and it will (obviously) run in a web browser I suppose I could use XML as well,

Re: [sqlite] custom property db/editor

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/02/12 22:06, Bill McCormick wrote: > ... building and editing recipes ... For real world messy data I'm a huge fan of documented oriented databases (aka NoSQL). There is no schema so you don't have to make every item conform to the same rules,