[sqlite] sqlite on flash devices

What's the consensus on using sqlite with flash based storage such as sd cards on embedded devices? Has anyone done this successfully yet with a real product (that needs to last a few years in the field)? How does one solve the problem of minimizing writes to flash? I've done a search through the

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

Igor Tandetnik wrote: > > "paul schindler" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> sqlite3_column_decltype("select amount from myvirtualtable", 0) >> returns "INTEGER" -> good! >> >> BUT: &

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

D. Richard Hipp wrote: > > > On Sep 5, 2008, at 9:03 AM, paul schindler wrote: > >> >> Hello, >> >> I have a virtual table and some (by me) declared datatypes are >> "TEXT10" or >> "INTEGER" or "DATE"... >

[sqlite] Get declared Datatype of SQLite Virtual Table

Is there a possibility to get the declared datatype of an aggregate function? Because the function sqlite3_column_type() always returns SQLITE_NULL for my virtual tables... Thanks for every help! Paul -- View this message in context: http://www.nabble.com/Get-declared-Datatype-of-SQLite-Vir

[sqlite] Segmentation fault

, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_ENABLE_FTS3

"def" SQLITE_ENABLE_FTS3. I can guess by setting it to some value somewhere. Please tell me how to do this and I will go back to powerbasic and leave you guys alone. thanks, Paul Breen ___ sqlite-users mailin

[sqlite] make import not abort

hange this behavior, simply ignoring the pieces that fail and continuing on? Thanks, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Listing duplicate entries

flakpit wrote: > Is there a way of querying the database to list all duplicate entries from a > column in the same table? > > Something like "SELECT * FROM mytable WHERE last NOT UNIQUE" > > fred, johnson > roger, johnson > > An unoptimised 'off the top of my head' solution would be: select * f

Re: [sqlite] delete rows but the database files still have the big size

Joanne Pham wrote: > Do I miss some commands here? I thought the database file size shoud get much > smaller after the delete operation but it isn't. > Can you please help to let me know how to get the database file szie smaller. > I have tried "VACUUM" but the file's size didn't change. > VACU

Re: [sqlite] How to manage separate lists of ordered items?

[EMAIL PROTECTED] wrote: > If I have something like a real estate database where each customer > can have an ordered list of houses they want to visit, is there a > recommended way to design tables that just link to other tables to > create the ordered list? I have a table of houses and a table of

[sqlite] Windows XP, where should I place the Sqlite .DLL's for best Sqlite operation, for usage with other COM components?

For Windows XP, where should I place the Sqlite .DLL's for best Sqlite operation, and for usage with other COM components? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Rowid After Sorting

27;bbb' row from the table (for example), the results would come back as 14 aaa 32 xxx 4 1 zzz So, rowid '2' would be missing. PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] htt

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 PROTECT

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

me, but as many 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' numberin a second field of a primary key?

rimary key? "Paul Hilton" <[EMAIL PROTECTED]> wrote: > > Here is the problem: I want Slot created to disambiguate the Primary Key, So > that for every value of Group the value of Slot starts at 1 and counts up. These are two different things: (1) Slot needs to disam

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

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

rimary 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 Communic

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

1 47 15 2 2 15 47 2 3 37 47 2 4 37 15 Thanks for any help. P

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

ave to do a sequential 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 table

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 i

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

elect column 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

[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?

es ('justvalue'); sqlite> 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. Baffling to anyone except for me? thanks Paul

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

re an existing wiki page or place on the web where this sort of thing 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 c

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. wik

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

vars (name text, 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?

thing = (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 wh

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

shed 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 their values into SQL statements. > in MySQL, you can do something l

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

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

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

lite3 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 sche

Re: [sqlite] Is this a valid syntax

s the problem, but, for some reason you're mixing 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

Re: [sqlite] Optimize a query

. Instead of having two 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]

[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 support

Re: [sqlite] Master table with child FTS table

nate 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] Maste

[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 as

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 whe

[sqlite] Master table with child FTS table

I have a database setup that creates a master table, and a child 'Full Text Search' (FTS) table that matches it by rowid. My problem is with keeping the FTS table in sync with the master. Let me explain in SQL: setup like so: CREATE TABLE master (a, b); CREATE VIRTUAL TABLE fts_table USING fts2(

Re: [sqlite] API for backups

lock the database from all 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

[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

ited them, 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 wo

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

complete wx-sqlite3 sample project! I have no particular preference for any 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 w

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: > > h

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

; wxOK | wxICON_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

(msg, wxT("File Open Failure"), 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.

d 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

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 a

[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 s

Re: [sqlite] Query planner confusion

On Wed, 15 Nov 2006 03:28:50 +, [EMAIL PROTECTED] wrote: Jean-Paul Calderone <[EMAIL PROTECTED]> wrote: I've hit a case where SQLite is selecting a suboptimal index for my query and I want to do something to tell it to use a different index. I'm familiar with the "+&q

[sqlite] Query planner confusion

statuses AS s WHERE 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 and

Re: [sqlite] new sqlite-based webserver

ressed 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

e is great 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?

ent DB engine supporting xBASE 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

you can just given them all the journal 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. Paul

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 ge

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 o

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?

ich are much quicker). Usually careful creation 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 Paul

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

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 http://adodotnetsqlite.sour

[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 across a number of

[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 t

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, which

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: Sent: Friday, March 31, 2006 10:49 AM Subject: Re: [sqlite] SQLITE_BUSY

[sqlite] SQLITE_BUSY [5] database is locked

Opening Database C_DAOPerformer 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 (because you can't delete

Re: [sqlite] Creating a (really) big table

but not much luck. Thanks for looking 99.99% of the time when somebody wants to make a table with that many columns, it's because they don't understand relational databases and are trying to put information that should be in a joined table into columns in the main table. -- Paul Tom

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 v

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 p

Re: [sqlite] SQLite to MySQL

s can't run 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 cust

Re: [sqlite] Decimal separator

ou insert 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:/

Re: [sqlite] Re: Help with IF NOT EXiSTS

d to mean anyway? I think it's a MySQL-ism. -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/ "An NT server can be run by an idiot, and usually is." -- Tom Holub, a.h.b-o-i

[sqlite] Question about locking

he first one is running: - Can the second one query while the first one is querying? - Can the second one query while the first one is updating? - Can the second one update while the first one is updating? - does committing in the first one release the lock and allow the seocnd one to continue? -

Re: [sqlite] Two problems

hose query 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

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

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 writin

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 jour

Re: [sqlite] ring buffer table

r other entities, 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 woul

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 jour

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 ARM?

RE: [sqlite] Threads and locking

f 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. > > >

[sqlite] Threads and locking

Hi, I am having some unexpected locking issues with SQLite. I have a desktop application that uses SQLite. The application has a low priority worker thread that is constantly analyzing/adding/updating/deleting records in the database. The main application thread mainly reads from the database bu

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 format

<    2   3   4   5   6   7   8   >