Re: Re: [sqlite] Compiling Linux SQLite with thread safe
> hi, the directory .libs is hidden, and you can use ls .libs find it. > > --- 马上到http://www.126.com申请260M全国最大免费邮;! 提供新邮件到达手机短信提醒功能, 随时掌握邮件信息!
Re: [sqlite] QNX and PPC
On 8/9/2004 6:36 PM, Eric Pankoke wrote: > I believe he's talking about Power PC, but since you brought up the > PocketPC, what development environment do you use? I've been messing > around with PocketPC development using SQLite, but I really don't > like eVC++ for developing GUI interfaces. > I use eVC++ 3.0 and eVC++ 4.0. I know I know ;-), C# and .NET is your favourite IDE, but sorry I have no experience in sqlite + c# + pocket pc. I don't like .NET at all so I use sqlite with C++. Greets -- Mateusz Łoskot mateusz at loskot dot net
[sqlite] new DBD::SQLite versions are available
I would like to announce that new versions of DBD::SQLite are available. This includes 1.03, which embeds SQLite 3, and a renamed 0.32, which embeds SQLite 2; it is now possible to use both SQLite 3 and SQLite 2 databases from the same Perl program. This is what *I've* been waiting for. This message is posted by me instead of Matt Sergeant because Matt can't get through directly, because: "The sqlite list is preventing me posting due to ezmlm checking MAIL FROM rather than header From, and my MAIL FROM not being subscribed". The details are posted here, and I also quote that link at the bottom of this email: http://use.perl.org/~Matts/journal/20319 -- Darren Duncan - Monday August 09, 2004 12:01 PM ANNOUNCE: DBD::SQLite-1.03 and DBD::SQLite2-0.32 [#20319 ] OK, so these releases are a bit confusing, so let me explain: DBD::SQLite is the active release of the driver, tracking the current release of sqlite (currently 3.0.4) DBD::SQLite2 is the old release of the driver, tracking sqlite 2.x (currently 2.8.15), and I won't be updating it very much at all. Everything is renamed, including all the internal C functions, so that you can definitely load both DBD::SQLite and DBD::SQLite2 in the same program and not have conflicts. The only significant changes since 0.31 are the update to sqlite 2.8.15, and the addition of the busy_timeout API from DBD::SQLite-1.0. And yes, before the bikeshed painter brigade comes out, I know the "2" on the end makes the second one look more up to date. There are multiple reasons I chose this scheme. Available on CPAN as soon as local CPAN mirrors update.
RE: [sqlite] QNX and PPC
I believe he's talking about Power PC, but since you brought up the PocketPC, what development environment do you use? I've been messing around with PocketPC development using SQLite, but I really don't like eVC++ for developing GUI interfaces. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Mateusz Âoskot [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 5:33 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] QNX and PPC On 8/9/2004 9:45 AM, Jakub Adamek wrote: > thank you for your notes. Could you please tell me more about "That's > the case"? Is it possible to use SQLite on PPC or not possible? Did you > hear about a big-endian port of SQLite? Do you mean Power PC or Pocket PC ? If you mean the second one, I can say sqlite works great on Pocket PC ;-) I use it for almost all database driven projects. Greets -- Mateusz Åoskot mateusz at loskot dot net
Re: [sqlite] QNX and PPC
On Aug 9, 2004, at 4:51 AM, Jakub Adamek wrote: No, I meant Power PC. We use SQLite in our Pocket PC car navigation system with big success also. SQLite runs just fine on a PowerPC. I use it all the time on my Mac.
Re: [sqlite] static int checkReadLocks
Hi Rubens. I also use LCC-32 and SQLite since a long time. Of course I also have since today SQLIte.3.0.4 in the system. So far as I can see Rubens it works fine. you only have to recompile the DLL that is all. If you need the files todo it just let me know. Groetjes en laat het mij wel weten op je de files noedig hebt. Erwin - Original Message - From: "Rubens Jr." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 09, 2004 6:31 PM Subject: [sqlite] static int checkReadLocks > Hi ! > > I have used Sqlite 3.03 with no problem with LCC-win32 compiler (Windows). > When I upgrade to 3.04 the compiler shows : > > "Error sqlite\btree.c: 1538 invalid storage class 'static' for 'int > function(pointer to struct Btree,unsigned int,pointer to struct BtCursor) > checkReadLocks" > > I thing that LCC does not like this king of 'static' use :( > If I remove the 'static' in this line (1538) and in line 3426 (the body of > this function) then no erros occurs !! > > Is there any 'problem' in removing the 'static' ? > > Thanks > > Rubens Jr. > > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.727 / Virus Database: 482 - Release Date: 7/26/2004
Re: [sqlite] QNX and PPC
No, I meant Power PC. We use SQLite in our Pocket PC car navigation system with big success also. Jakub Mateusz Łoskot wrote: On 8/9/2004 9:45 AM, Jakub Adamek wrote: thank you for your notes. Could you please tell me more about "That's the case"? Is it possible to use SQLite on PPC or not possible? Did you hear about a big-endian port of SQLite? Do you mean Power PC or Pocket PC ? If you mean the second one, I can say sqlite works great on Pocket PC ;-) I use it for almost all database driven projects. Greets
Re: [sqlite] QNX and PPC
On Mon, 9 Aug 2004, Jakub Adamek wrote: >Hi Armin, > >thank you for your notes. Could you please tell me more about "That's >the case"? Is it possible to use SQLite on PPC or not possible? Did you >hear about a big-endian port of SQLite? I've used SQLite on SPARC, PowerPC and PA-RISC, all big endian, with no problems. The SQLite database file is platform independent, being endian agnostic and 32/64 bit clean. BTW, you may want to upgrade to a later version of SQLite, 2.8.15 being the latest 2.x release. > >Thanks, >Jakub > >Armin Steinhoff wrote: > >> [EMAIL PROTECTED] schrieb am 06.08.04 19:40:55: >> >> >>>Hello everybody, >> >> >>>does someone have any experience with building for the QNX operating >>>system? And for the Power PC processor? >> >> >>>QNX 6.2.1 is a real-time Linux but it behaves strangely sometimes. >> >> >> No .. it doesn't behave 'strangely" at all :) >> >> >>>It has not gcc but a qcc compiler. >> >> >> qcc is only a frontend of the gcc ... so QNX has gcc. >> >> >>>Our testing program runs correctly on >>>the x86 PC. It creates a database, a table, inserts and selects data. >>>But the same program cross-compiled on the same computer for PPC ends at >>>the first "CREATE TABLE" statement with SQLITE_BUSY. >> >> >>>I am using SQLite 2.8.6. Is it possible that the little-or-big-endian >>>thing could cause this trouble? >> >> >> That's the case .. >> >> Regards >> >>Armin Steinhoff >> >> >> >> >> >>>Or do you have any other ideas? >> >> >>>Thank you very much, >>>Jakub >> >> >> >> >> Aufnehmen, abschicken, nah sein - So einfach ist >> WEB.DE Video-Mail: http://freemail.web.de/?mc=021200 >> > -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
Re: [sqlite] QNX and PPC
On 8/9/2004 9:45 AM, Jakub Adamek wrote: thank you for your notes. Could you please tell me more about "That's the case"? Is it possible to use SQLite on PPC or not possible? Did you hear about a big-endian port of SQLite? Do you mean Power PC or Pocket PC ? If you mean the second one, I can say sqlite works great on Pocket PC ;-) I use it for almost all database driven projects. Greets -- Mateusz Łoskot mateusz at loskot dot net
Re: [sqlite] assertation failed in btree_rb.c [backtrace]
> Unfortunatelly I can't provide a backtrace yet - there's still a problem > with gdb, hopefully I will sort it out soon. It took quite a while, but here's the backtrace: -- Assertion failed: res == 0, file ../src/btree_rb.c, line 1341 Program received signal SIGABRT, Aborted. 0x7fff7eda7944 in _libc_kill () from /usr/lib/64/libc.so.1 (gdb) bt #0 0x7fff7eda7944 in _libc_kill () from /usr/lib/64/libc.so.1 #1 0x7fff7ed3d224 in abort () from /usr/lib/64/libc.so.1 #2 0x7fff7ed3d51c in _assert () from /usr/lib/64/libc.so.1 #3 0x7fff7f74eb0c in execute_rollback_list (pRbtree=0x10011bec0, pList=0x45366d360) at ../src/btree_rb.c:1341 #4 0x7fff7f74eb6c in memRbtreeRollback (tree=0x10011bec0) at ../src/btree_rb.c:1365 #5 0x7fff7f72854c in sqliteRollbackAll (db=0x10011bc80) at ../src/main.c:605 #6 0x7fff7f7489d8 in sqliteVdbeReset (p=0x19a0141d0, pzErrMsg=0x7fffedf8) at ../src/vdbeaux.c:874 #7 0x7fff7f748c50 in sqliteVdbeFinalize (p=0x19a0141d0, pzErrMsg=0x10011bc80) at ../src/vdbeaux.c:929 #8 0x7fff7f7286e0 in sqlite_finalize (pVm=0x19a0141d0, pzErrMsg=0x7fffedf8) at ../src/main.c:798 #9 0x7fff7f728828 in sqlite_exec (db=0x10011bc80, zSql=0x19a011690 "INSERT INTO haploshare SELECT id1, id2, locus, CASE WHEN p1 == 0 OR p2 == 0 THEN NULL WHEN p1 != p2 THEN 0 ELSE -1 END, CASE WHEN p1 == 0 OR m2 == 0 THEN NULL WHEN p1 != m2 THEN 0 ELSE -1 END, CASE WH"..., xCallback=0, pArg=0x0, pzErrMsg=0x7fffedf8) at ../src/main.c:666 #10 0x7fff7f924308 in GEDatabase::exec (this=0x100114c30, sqlfmt=0x1f328 "INSERT INTO haploshare SELECT id1, id2, locus, CASE WHEN p1 == %s OR p2 == %s THEN NULL WHEN p1 != p2 THEN 0 ELSE -1 END, CASE WHEN p1 == %s OR m2 == %s THEN NULL WHEN p1 != m2 THEN 0 ELSE -1 END, CAS"...) at ../../src/gedatabase.cpp:88 #11 0x00017138 in mhsApplication::doCreateWorkingTables ( this=0x72b0) at ../../src/main.cpp:556 #12 0x0001cf70 in mhsApplication::exec (this=0x72b0) at ../../src/main.cpp:163 #13 0x0001cfb4 in main (argc=13, argv=0x7398) at ../../src/main.cpp:114 -- regards Daniel P.S. Is this the correct list to post assertation failures, backtraces and so on? -- Dipl.-Math. (FH) Daniel Franke Institut fuer Medizinische Biometrie und Statistik Medizinische Universität zu Luebeck Ratzeburger Allee 160, Haus 4 23538 Luebeck Telefon: 0451-500-2786 Telefax: 0451-500-2999 [EMAIL PROTECTED]
Re: [sqlite] QNX and PPC
Hi Armin, thank you for your notes. Could you please tell me more about "That's the case"? Is it possible to use SQLite on PPC or not possible? Did you hear about a big-endian port of SQLite? Thanks, Jakub Armin Steinhoff wrote: [EMAIL PROTECTED] schrieb am 06.08.04 19:40:55: Hello everybody, does someone have any experience with building for the QNX operating system? And for the Power PC processor? QNX 6.2.1 is a real-time Linux but it behaves strangely sometimes. No .. it doesn't behave 'strangely" at all :) It has not gcc but a qcc compiler. qcc is only a frontend of the gcc ... so QNX has gcc. Our testing program runs correctly on the x86 PC. It creates a database, a table, inserts and selects data. But the same program cross-compiled on the same computer for PPC ends at the first "CREATE TABLE" statement with SQLITE_BUSY. I am using SQLite 2.8.6. Is it possible that the little-or-big-endian thing could cause this trouble? That's the case .. Regards Armin Steinhoff Or do you have any other ideas? Thank you very much, Jakub Aufnehmen, abschicken, nah sein - So einfach ist WEB.DE Video-Mail: http://freemail.web.de/?mc=021200
