Re: [sqlite] Advice on which to use (SQLite or SQL Server) for the following app.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robel Girma wrote: > I'm trying to choose the most efficient db for this application and my main > criteria is response time. Will SQLite do this more efficiently than SQL > Server. I'm planning to allocate upto 1GB memory. SQLite doesn't operate

[sqlite] Advice on which to use (SQLite or SQL Server) for the following app.

Hello, I am in need for a database to hold a couple of tables with max 10,000 rows each that I will update frequently and query frequently. Example, 5000 users connect to our server every 10 seconds and each time they connect, I need to update a table with their IP and Last_connect_time.

Re: [sqlite] Compite with DSQLITE_THREADSAFE=1 but application has mulitple threads using the same connection

On Tue, 9 Jun 2009 15:23:42 -0700 (PDT), Joanne Pham wrote: >Sorry Couldn't locate the email about Compite with> DSQLITE_THREADSAFE=1 bu the application has multiple >threads using the same connection? >Would you pleas direct me to any document that has this info. >Thanks,

Re: [sqlite] Topics 1 - Re: sqllogictest tool - please help :-)

What have you been able to do so far? Have you been able to build sqllogictest (SLT)? Were you able to retrieve some of the test files for SLT? Have you gotten MySQL installed? Are you able to use MySQL via an ODBC interface? (SLT uses an ODBC interface to non-SQLite databases.) On Wed, Jun

Re: [sqlite] Order by term not in result set

Pavel Ivanov wrote: > It mentions "from" and "column_name" where column name in this > particular case is "selected". ;-) > > @Igor: I thought that sql standard in this case doesn't guarantee that > outer select will return rows in the same order that were enforced in > inner select by "order by",

Re: [sqlite] Order by term not in result set

Note to self: Do not ask questions before I finish my coffee. ;) On Wed, Jun 10, 2009 at 11:27 AM, Pavel Ivanov wrote: > It mentions "from" and "column_name" where column name in this > particular case is "selected". ;-) > > @Igor: I thought that sql standard in this case

Re: [sqlite] Order by term not in result set

It mentions "from" and "column_name" where column name in this particular case is "selected". ;-) @Igor: I thought that sql standard in this case doesn't guarantee that outer select will return rows in the same order that were enforced in inner select by "order by", does it? Pavel On Wed, Jun

Re: [sqlite] Order by term not in result set

Just out of curiosity, where in the syntax documentation does it mention "selected from"? On Wed, Jun 10, 2009 at 10:57 AM, Igor Tandetnik wrote: > Rand Huck wrote: > > In addition to what was already said, if you absolutely to omit the > > 'name' from the final result set,

Re: [sqlite] Topics 1 - Re: sqllogictest tool - please help :-)

I think your problems have nothing to do with SQLite, yet. To begin you need some help related to the "C" programming language. The three files you have listed are the "Make", "Source" and "Header" files for a C program. You must compile these to develop an executable program. Once you have

Re: [sqlite] Order by term not in result set

Rand Huck wrote: > In addition to what was already said, if you absolutely to omit the > 'name' from the final result set, you should be able to put the > result of the union in a temporary table. Or else add an extra layer of indirection: select id, url, selected from ( SELECT id, url,

Re: [sqlite] Order by term not in result set

In addition to what was already said, if you absolutely to omit the 'name' from the final result set, you should be able to put the result of the union in a temporary table. CREATE TEMPORARY TABLE `tmp` (`id`, `url`, `selected`, `name`); INSERT INTO `tmp` ( SELECT id, url, selected, name FROM

Re: [sqlite] help,low RAM problem

You have to configure the page size and cache size (number of pages) to fit your 30K RAM. To be specific: page size * cache size < 30K. 徐中华 wrote: > > > > > hi, > I have a project based on an embedded platform. > the platform just has 30K RAM and a large NAND Flash, > so I want to use

[sqlite] Topics 1 - Re: sqllogictest tool - please help :-)

> > Hi, we are working with SQLite in our company. we need a tool that check if SQL returns the correct answer and to compare with MySQL. I got a new job and its my first assignment ( to start working on sqlogictest) , and I don't understand much about sqllogictest. Please help.

Re: [sqlite] sqlite-users Digest, Vol 18, Issue 41

> > Hi, we are working with SQLite in our company. we need a tool that check if SQL returns the correct answer and to compare with MySQL Tsachi > > -- > > Message: 1 > Date: Tue, 9 Jun 2009 16:12:30 -0400 > From: "D.