Re: [sqlite] Rowid After Sorting

aaa 32 xxx 4 1 zzz So, rowid '2' would be missing. PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/ ___ sqlite-users mailing list sqli

Re: [sqlite] Limiting the number of results from a query per group

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik Sent: Thursday, March 06, 2008 7:57 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Limiting the number of results from a query per group "Paul Hilton" <[EMAIL PROT

[sqlite] Limiting the number of results from a query per group

simultaneous groups as there are. I will then mark these IDs as done, and go on to the next lot until they are all done. Paul Hilton ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key?

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Monday, March 03, 2008 6:38 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key? Paul

Re: [sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key?

? Paul Hilton wrote: > Hello, > > I have source tables Talker and Listener, each with fields ID (PK, Integer) > and Group (Integer): > > CREATE TABLE Talker (ID INTEGER, Group INTEGER, Primary Key (ID)); > Ditto Listener > > I would like to make a table Communications wit

[sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key?

47 15 2 2 15 47 2 3 37 47 2 4 37 15 Thanks for any help. Paul Hilton

Re: [sqlite] which is faster, PHP or SQLite?

al scan to get the result, it can be quicker to do, say, two indexed scans in SQLite and then operate on the two result sets (eg doing a union or intersect) to produce the final result set, but this is the exception rather than the rule (for us anyway). Paul Smith _

Re: [sqlite] Sqlite insertion performance

On 17/09/2007, John Machin <[EMAIL PROTECTED]> wrote: > On 17/09/2007 1:07 PM, Joe Wilson wrote: > > --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > > I have been struggling with the performance of insertion in sqlite. > > > > Here we have a very simple case : > > > > A

Re: [sqlite] Creating index takes over an hour

Hi Mike, i have noticed that things take a lot longer if they aren't surrounded by a BEGIN; do work; COMMIT; does that make a difference for you? Paul On 09/08/07, mos <[EMAIL PROTECTED]> wrote: > I'm building my first index on a large table using the "Create index >

Re: [sqlite] Re: auto_increment - why does it do the opposite?

mn from abc; " didn't work ! not essential, just a nice-to-have. thanks Paul On 09/08/07, miguel manese <[EMAIL PROTECTED]> wrote: > Igor has answered this before. Roughly: > > 1. all tables has an implicit integer column named "rowid" that is > auto increment >

[sqlite] Re: auto_increment - why does it do the opposite?

On 09/08/07, Paul Harris <[EMAIL PROTECTED]> wrote: > Hi, > > Can someone please explain why adding the auto_increment term seems to > STOP the auto_increment behaviour? > > $ sqlite3 > SQLite version 3.3.17 > Enter ".help" for instructions > sqlite&

[sqlite] auto_increment - why does it do the opposite?

lite> insert into def (id,value) values (null,'withid'); sqlite> select * from def; id|value 1|justvalue 2|withid sqlite> Note that abc (the one with auto_increment) does NOT fill in the id primary key. Baffli

Re: [sqlite] Re: Is SQLite Case Sensitive?

hing is documented? This sort of information is gold, and while I've only been on the mailing list a short time, many of the messages have revolved around the SQL language and varying behaviours across platforms. thanks Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite.org needs online forms

On 03/08/07, john s wolter <[EMAIL PROTECTED]> wrote: > Wiki's. I have not used them myself. What's the general idea? Is there a > form type that would be easy to use? > wikis are very easy to use. in short, its basically a "forum" where people can write and store information in a form that

Re: [sqlite] Re: Re: how do i declare and use variables in sqlite?

On 03/08/07, Nikola Miljkovic <[EMAIL PROTECTED]> wrote: > [In the message "Re: [sqlite] Re: Re: how do i declare and use variables in > sqlite?" on Aug 3, 11:47, "Paul Harris" writes:] > > > >> create temporary table vars (name text, value someth

Re: [sqlite] SQLite.org needs online forms

i haven't been around long, but here's my 2c anyway, i find the sourceforge forums hopeless, any time I need to look for info on one of their projects, i end up looking through their mailing list - where forum posts are automatically sent to anyway. mailing lists are good for on-going issues.

Re: [sqlite] Re: Re: how do i declare and use variables in sqlite?

, value something); insert into vars set name="x", value=0; update vars,table2 set column2=value where name = 'x'; something like that. thanks, Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: how do i declare and use variables in sqlite?

= (select value from vars where name="x")... > > I real life you might want to create better named temporary table > directly with select and use its values without having to > search through names. > If this is slow you can attach in memory database which w

Re: [sqlite] how do i declare and use variables in sqlite?

some light on this for me? > > AFAIK, this isn't something you do with SQLite. You can retrieve values > into variables in the host language (C, C++, or some wrapping language), > and you can bind

[sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

release? thanks Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

release? thanks Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Database designer for SQLite

Thanks but i forgot to specify that i'm on Mac :( Something else for me ?? Le 13 juin 07 à 16:44, Jim Dodgen a écrit : www.datanamic.com

[sqlite] Database designer for SQLite

Début du message réexpédié : De : Paul KOENIG <[EMAIL PROTECTED]> Date : 13 juin 2007 16:26:56 HAEC À : sqlite-users@sqlite.org Hi, I'm new with SQLite. Do someone know a database designer like DBDesigner for SQLite? I want to create a graphic Entity-RelationShip schema.

Re: [sqlite] Is this a valid syntax

C/C++ syntax in with SQL there. You don't use '==', you should just use '=' You don't use '!=', you should use '<>' So, try SELECT PO.* FROM Koppel LEFT JOIN PO WHERE (Koppel.K_App = PO.App) AND (Koppel.K_naam = 'MVE') AND (PO.ALL_answered <>

Re: [sqlite] Optimize a query

indices on columns A and B, you need to consider having another index on both columns at once. PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk

[sqlite] Re: FTS does not support REPLACE

Very simple to replicate: CREATE VIRTUAL TABLE fts_table USING fts2(text); INSERT OR REPLACE INTO fts_table (rowid, text) VALUES (1, 'text1'); INSERT OR REAPLCE INTO fts_table (rowid, text) VALUES (1, 'text2'); The first insert succeeds, the second fails. Is FTS not supposed to

Re: [sqlite] Master table with child FTS table

! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Paul Quinn [mailto:[EMAIL PROTECTED] Sent: Saturday, April 07, 2007 11:54 AM To: sqlite-users@sqlite.org Subject: Re:

[sqlite] FTS does not support REPLACE

Quite simply, both the FTS1 and FTS2 modules return an error on INSERT OR REPLACE when there is a conflict. The rowid is being supplied with the INSERT statement which is generating the conflict. Is this by design, a known issue, or a defect? I'm also having trouble with FTS inserts/deletes

Re: [sqlite] Master table with child FTS table

I did set up a trigger for DELETEs, but even then the fts_table would find a way to have more rows than master after a short while. Some delete's are simply being ignored/failed by the FTS module it seems. I would have liked to also use triggers for INSERTs, but how do you create a trigger

Re: [sqlite] API for backups

ll other access copy the file on the file system rollback transaction to release the lock -Clark - Original Message From: Paul Richards <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, April 5, 2007 4:23:18 AM Subject: [sqlite] API for backups Hi, Are there funct

[sqlite] API for backups

Hi, Are there functions in the SQLite API for creating live backups of a database? I see that the sqlite3 command line tool has a "dump" command, but can this feature be accessed through the normal C API? -- Pau

Re: [sqlite] Storing contacts list for each user

em, my wife's version would change too. That, in a nutshell, is normalization. I hope that helps, but like I said at the start, it depends how you see your app working. Your original question implied that you would have 1 file and many tables in it (1 for each user) which would be wrong (well, ineff

Re: [sqlite] Can't get results from PRAGMA

ny IDE. I only have 2 requirements:- 1) It must work (without needing a PHd in computing to make that happen!) 2) It must cost me very little (i.e. nothing!!!) So, Code::Blocks is ok if only 1) can be solved! Can you help? -- Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Can't get results from PRAGMA

> Hi, > > Paul Simpson wrote: >>> Hi, >>> >>> Paul Simpson wrote: >>>> Hi, >>>> >>>> I'm trying to use the dll version of SQLite within an application >>>> written >>>> in C++ using wxWidg

Re: [sqlite] Can't get results from PRAGMA

> Hi, > > Paul Simpson wrote: >> Hi, >> >> I'm trying to use the dll version of SQLite within an application >> written >> in C++ using wxWidgets. >> > [snip] > > > In case you missed, there is already an interface: > > http:/

Re: [sqlite] Can't get results from PRAGMA

ON_ERROR, NULL); >> return false; >> } > > I don't see a Step() up there. Maybe it's never executing the pragma > to set the user-cookie. > Doh! How stupid am I? Thnks for that ;-) -- Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Can't get results from PRAGMA

wxOK | wxICON_ERROR, NULL); return false; } My apologies for what is probably a silly mistake, but this is driving me mad! Any help ratefully received! -- Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: New (ish) to C== and new to SQLite error with prepare.

> Paul Simpson <[EMAIL PROTECTED]> > wrote: >> sqlite3_stmt **ppStmt; >> const char **pzTail; >> >> rc = (sqlPrepareAdd)(newdb, >> getDBVersion.c_str(),getDBVersion.length(),ppStmt,pzTail); > > Make it > > sqlite3_stmt* pSt

[sqlite] New (ish) to C== and new to SQLite error with prepare.

and the prepare_V2 functions. I know it is that line, because if I comment it out! pologies for the poor coding (I'm learning!) but could anyone tell me what I'm doing wrong, please? Many thanks -- Paul Code:- dbConnection.h #include "sqlite3.h" typedef int (*SQLCALLBACK)(void *,int,ch

Re: [sqlite] Passing parameters Python and CGI

Think I managed to solve it using:- print '%s' % (row[0], row[1]) Paul Paul Issott wrote: Hi, I'm a newbie using sqlite 3 via Python 2.5, I've created a db using CREATE TABLE messages ( id INTEGER PRIMARY KEY, subjectTEXT ) Populated it with a few lines and one of the row

[sqlite] Passing parameters Python and CGI

Hi, I'm a newbie using sqlite 3 via Python 2.5, I've created a db using CREATE TABLE messages ( id INTEGER PRIMARY KEY, subjectTEXT ) Populated it with a few lines and one of the row of rows is (1, u'News') after:- rows = curs.fetchall() How do I pass these parameters in a cgi

[sqlite] Query planner confusion

s.msg = m.id AND s.name = ? ; Is there any way to convince SQLite to use the index I want? Thanks, Jean-Paul - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: new sqlite-based webserver

On 10/20/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote: You didn't use the CGI module, did you? If you must know it was POE based and no I did not use the CGI module. I have implemented later versions that where capable of using database servers. SQLite amoung them of course as well as MySQL

Re: [sqlite] new sqlite-based webserver

d with your work though. I will take a look and see what I can use this thing for, because it sounds like something that can be useful. One last remark, when I built mine I spent hours deciphering HTTP's exact workings. I hope you didn't have to do the same. Paul M

Re: [sqlite] Question - Multiple Users, Multiple files

and all, but in your case as I have said would be far more trouble than its worth. Sincerely, Paul

Re: [sqlite] Can anyone recommend some ISAM db to me?

database files. PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/ - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Memory Usage

one insert, so anyone have any suggestions on what could be the cause? Thanks in advance. Paul

Re: [sqlite] Best way to compare two databases

rnal entries after that number, and they can run the SQL on their end. which will give. You can make your routine which modifies the database just keep a copy of the SQL used whenever the action succeeds, and store that in the Journal table. PaulVPOP3 - Internet E

Re: [sqlite] i have a few Qs - sqlite3

On 7/8/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: Nuno Lucas wrote: > Please don't feed the troll... Well, I have to add my two cents here. I've been following this thread and alot of people have been generous enough to the troll. I think its nice to see a community such as this that is

Re: [sqlite] Windows DB manager?

On 7/1/06, Bernie Cosell <[EMAIL PROTECTED]> wrote: What's the current state of GUI-based managers for SQLite? I know there have been various admin apps for SQLite, but I've been out of touch and I didn't see any linked out of the sqlite.org web page. Hi, Well my personal favourite and the

Re: [sqlite] Index usage

one index for the query. (It tries to pick the best one) PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

Re: [sqlite] speed of ORDER BY clause?

of the suitable indices helps a lot. Read http://www.sqlite.org/optoverview.html - this gives some details of the limited optimisations that SQLite can do, so you can try to take advantage of them PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

for wrapper users (tcl perl) and one for those using the C API. Regards, Paul Nash

Re: [sqlite] Cannot load sqlite3.dll

Excellent - thanks for the recommendation. I'm assuming the wrapper dll doesn't contain the sqllite dll embedded in it? John Newby wrote: I was having this problem also but I just copied the dll file into the directory, and it worked fine with the ado.net wrapper at

[sqlite] Cannot load sqlite3.dll

I'm trying to add sqlite3.dll ot my application in VS 2005. I downloaded the dll from the sqlite home page. VS simply says that it is not a valid assembly and can't be loaded. I have no idea what to do next... Can anyone point me in the right direction? Cheers Paul Hunnisett

Re: [sqlite] Most appropriate Web based database? (Newbie)

On 4/24/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > > Keep in mind, there's *WAY* more Windows users than Linux users; that > doesn't mean Windows is a better OS. Indeed also keep in mind both Postgres and MySQL are cross platform as well. One final thought: the support you'll be able to get

Re: [sqlite] Converting ver 2 to ver 3

Welcome to quoting hell. :-) But I had a tcl tablecopy, and my databases all have a data definition so doing it the right way was real easy. But I did want to point out that the recommended .DUMP method is flawed. Regards, Paul Nash webscool.org - Original Message - From: &quo

[sqlite] Does Substr() use index?

Hello, just a short question: Does this use the index on f select * from t where SUBSTR(f,1,1) = 'a' so that it is an alternative for select * from t where ( f >= 'a' and f < 'b' ) Thanks a lot Paul

[sqlite] Converting ver 2 to ver 3

in .DUMP. Maintaining the textedness of values in columns with text affinity in ver 2 would ease the move to ver 3. Regards, Paul Nash

Re: [sqlite] Small enhancement: BEGIN SHARED

[EMAIL PROTECTED] wrote: > Paul Bohme <[EMAIL PROTECTED]> wrote: > >> I have a small patch that adds "BEGIN SHARED" syntax in addition to >> IMMEDIATE and EXCLUSIVE. I have an application that requires a >> consistent view of the data

[sqlite] Small enhancement: BEGIN SHARED

I have a small patch that adds "BEGIN SHARED" syntax in addition to IMMEDIATE and EXCLUSIVE. I have an application that requires a consistent view of the data across a number of individual statements. What is ideal is a way to simply lock the database with a SHARED lock for the duration, but

Re: [sqlite] Persistent user-defined functions

Daniel Franke wrote: > Layering. Wrap sqlite3_* into your own set of functions. Create another > library, say libyourapp. Most functions will just forward the arguments to > sqlite, but others, e.g. yourapp_open_db() will not only open the database, > but also attach a couple of functions,

Re: [sqlite] SQLITE_BUSY [5] database is locked

I tried it. Apparently the error gets thrown by the stmt.execDML() statement. It never makes it to any code past the execDML. Paul - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, March 31, 2006 10:49 A

[sqlite] SQLITE_BUSY [5] database is locked

Compiling Insert Statement C_DAOPerformer Binding values C_DAOPerformer Executing DML C_DTOPerformer::insertInfo()DAO executed The function gets as far as the Executing DML line, then it stops. After some seconds, a message box appears with the error message in it. Any ideas from anyone would be greatly appreciated. TIA, Paul

Re: [sqlite] Extrange files

- Original Message - From: "Nuno Lucas" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 01, 2006 10:36 PM Subject: Re: [sqlite] Extrange files The only problem is that it can be a race condition between the closing of the handle and the actual delete command

Re: [sqlite] testing Avg() function in other database engines

963 1 cosdb=>insert into t values (3, 3); INSERT 973964 1 cosdb=>insert into t values (4, 4); INSERT 973965 1 cosdb=>select avg(a), avg(b) from t; avg | avg +------ 3. | 3.33 (1 row) cosdb=&g

RE: [sqlite] disk locality (and delta storage)

debating your VCS, Trac forces you into SVN (mostly). There is currently work to support varying VCS backends, monotone is not on the list of supported systems yet... But there is a ticket to have it added. http://projects.edgewall.com/trac/ticket/1492 --paul -Original Message- From

[sqlite] Versioning in SQL database?

that means being able to compare versions, roll back erroneous edits, get what the database looked like before a particular editor came along, etc. Is there anything written on this topic? Has anybody ever tried it before? -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/

[sqlite] Error accessing sqlLite.so

!!!SORRY - JUST POSTED THIS MESSAGE WITH WRONG SUBJECT!!! HELP!! I have a problem with a SqLite install. I've been charged with installing PolicyPage, a web site compliance checking tool with uses PHP4 and Sqlite. I've got the web/php content installed such that Apache will serve it. I have

RE: [sqlite] SQLite to MySQL

HELP!! I have a problem with a SqLite install. I've been charged with installing PolicyPage, a web site compliance checking tool with uses PHP4 and Sqlite. I've got the web/php content installed such that Apache will serve it. I have verified that PHP is working on the machine (FC4). I used

Re: [sqlite] SQLite to MySQL

in a reasonable time because the batch applications won't allow the updater to commit until the batch job is finished. -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/ OTOH, the general theme is that lusers should not be allowed to have computers, cars, guns or genitalia. -- Anthony DeBoer

Re: [sqlite] Auto Increment?

Quoting Dennis Cote ([EMAIL PROTECTED]): > Doesn't this mean that SQLite only supports 2^63 rows with autoincrement? That means you can insert one row per millisecond for 29 million years. -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/ In any business, the customer

Re: [sqlite] Decimal separator

sert 12,0 in the column "price", and you're complaining that the value in a different column, "amount", is the default? WTF? > Of course it's not critical but maybe new pragma would be useful. #pragma READ_MY_MIND -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.co

Re: [sqlite] Two problems

is still open. I suppose the only way I'm going to know for sure is to try writing the same sequence of events in C, and it's been so long I'm not sure my C skills are up to it. -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/ If you're not part of the solution, you're part of the precipitate.

[sqlite] Two problems

} nextID does the following: while (1) { $isTaken->execute($maxNumber); if (@row = $isTaken->fetchrow_array) { print "$maxNumber is already taken\n"; $maxNumber++; } else { last; }

Re: [sqlite] SQLite and Flash memory

[EMAIL PROTECTED] wrote: Has anyone experimented with putting SQLite directly on the Linux MTD flash interface? I.e. by-passing JFSS2. Would this offer any kind of significant efficiency benefit? JFFS2 is designed to wear the flash evenly, preventing you from 'drilling holes' by

Re: [sqlite] ring buffer table

Julien LEFORT wrote: Hi, I would like to implement a log table with a finite dimension, for exemple a table with 500 records, and when the last record is set in the table I would like to come back at the first tuplet and write over the previous value recorded. I think it's the way SQLite

Re: [sqlite] ring buffer table

tities, thus I didn't really expect SQLite to have it. -Original Message- From: Paul Bohme [mailto:[EMAIL PROTECTED] Sent: Viernes, 23 de Diciembre de 2005 02:52 p.m. To: sqlite-users@sqlite.org Subject: Re: [sqlite] ring buffer table Julien LEFORT wrote: Hi, I would like to imp

Re: [sqlite] ring buffer table

Julien LEFORT wrote: Hi, I would like to implement a log table with a finite dimension, for exemple a table with 500 records, and when the last record is set in the table I would like to come back at the first tuplet and write over the previous value recorded. I think it's the way SQLite

Re: [sqlite] SQlite for Linux on the ARM processor.

Ben Clewett wrote: Dear SQLite I wish to compile SQLite for the ARM processor running Linux (ARM720T). The compilation will have to use the cross-compiler arm-linux-gcc version 2.95.2 running on Intel Linux, since the devise it's self has no compiler. Does any person have an image for

RE: [sqlite] Threads and locking

t of using a lock to synchronise access to the > databaseso that only one thread at a time could change the > database although both could read simultaneously? > JS > > Barry Paul wrote: > > > > Hi, I am having some unexpected locking issues with SQLite. > > &

Re: [sqlite] Using time and date values

Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily transform the date from one

[sqlite] Odd query optimization

OK, little puzzled by this one, wondering if my expectations of behavior are off. (Apologies for the longish post..) This is with 3.2.7. I have a reasonably simple 'users' table, with a single compound index (at first) on user last/first name: create table users ( id integer primary key,

Re: [sqlite]cross compiling with powerpc

Julien LEFORT wrote: Hi, I've been struggling for few hours trying to run the configure script the right way so I can cross compile sqlite3 for a powerpc target. I guess it is only a problem of options I pass into the configure script. here is the command I pass: CC=powerpc-linux-gcc

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

I'm guessing it was database corruption because the crash happened in the SQLite DLL, and restoring a backup DB file stopped the crashing) PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 01, 2005 2:08 PM Subject: Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2 > I think it's a bit misleading to call the library "SQL-Lite: if you're > going to redesign >

Re: [sqlite] Multi-threading.

ks. Of course, this assumes a well designed architecture... But, one process per task is very poor in comparison to the other ways (on all the platforms they tested) handling only about 5% of load of the 'one thread for many tasks' architecture. PaulVPOP3 - Internet Email

Re: [sqlite] Multi-threading.

- Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 20, 2005 12:26 PM Subject: Re: [sqlite] Multi-threading. > Dr Hipp, > > I am just playing devils advocate here because I have completed much > Java programming in a

Re: [sqlite] Multi-threading.

- Original Message - From: "Andrew Piskorski" <[EMAIL PROTECTED]> To: Sent: Friday, July 15, 2005 1:05 PM Subject: Re: [sqlite] Multi-threading. > On Fri, Jul 15, 2005 at 04:21:05PM +0300, Cariotoglou Mike wrote: > > > memory and cpu-wise. on Linux, this is

RE: [sqlite] Insert all rows from old table into new table but in sorted order

, and do 'order by no desc' in all your queries requiring that ordering. You'll be glad you did it that way in the future! -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 4:53 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Insert all

Re: [sqlite] Insert all rows from old table into new table but in sorted order

ecessarily in the order they were inserted into the table You should do the sorting when you read 'NEWTABLE' So, instead of Insert into NEWTABLE select * from OLDTABLE order by no desc select * from NEWTABLE do Insert into NEWTABLE select * from OLDTABLE select * from NEWTABLE order by no des

Re: Re[2]: [sqlite] Sqlite low level and Speed.

- Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: "Christian Smith" ; "Yuriy" <[EMAIL PROTECTED]> Sent: Monday, June 20, 2005 12:01 PM Subject: Re[2]: [sqlite] Sqlite low level and Speed. > On Mon, 20 Jun 2005, Yuriy wrote: > > >CS> When

Re: [sqlite] Training opportunity: The Inner Workings Of SQLite

- Original Message - From: "Robert L Cochran" <[EMAIL PROTECTED]> To: Sent: Sunday, June 19, 2005 8:19 PM Subject: Re: [sqlite] Training opportunity: The Inner Workings Of SQLite > I'd like to ask about this too. I'd be very happy to pay for DVDs. I'd > like

Re: [sqlite] license to hack: pager in shmem

- Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, June 17, 2005 9:42 PM Subject: Re: [sqlite] license to hack: pager in shmem > On Fri, 2005-06-17 at 21:21 -0400, Paul G wrote: > > i might put

Re: [sqlite] license to hack: pager in shmem

richard, comments inline: - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, June 17, 2005 8:54 PM Subject: Re: [sqlite] license to hack: pager in shmem > On Fri, 2005-06-17 at 20:16 -0400, Paul G wr

[sqlite] license to hack: pager in shmem

folks, for better or for worse, i'm going to use sqlite3 as a local cache for some of my preciousss objects (permanent persistence target is mysql). this is in a php app, so the obvious problem is having multiple sqlite page caches (one per apache process). therefore, unless well informed people

[sqlite] sqlitebrowser - my db contains sql?

the tables, but they are empty, with no fields etc.. but in the "execute sql" tab i can query the database and get the data out correctly.. is this normal? is it just the way that sqlite stores the data?? am I forgetting a step in the creation of the databases? Paul.

Re: [sqlite] SQLite Advocacy

Fred Williams wrote: Politically, if you are in the organization that was "acquired", you best bite the bullet and learn to dance the Big Gates' version of "I Shall Overcome." I don't think there is a WinCE version of SQL Server, (yet) so that might be your only real chance. My experience with

Re: [sqlite] SQLite Advocacy

Downey, Shawn wrote: I am trying to overcome the attitude of: "If SQLite is as good as you say, then why is it free?" and "If anyone can see the source code, then won't we be venerable to hackers?" Hi, I hope I may be of assistance in this area. I own my own company and we use exclusively open

Re: [sqlite] download db - security question

to your database isn't shown in the downloadable website page source anywhere... PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

<    2   3   4   5   6   7   8   >