[sqlite] sqlite3 problems on both 32 and 64 architectures

2004-11-02 Thread Jarosław Staniek
Hallo, assertions like this (btree.c, line 1043) are bad: assert( sizeof(ptr)==sizeof(char*) ); The problem better is described here: http://bugs.kde.org/show_bug.cgi?id=92563 Reporters say that even for intel P4, sizeof pointers is 8, not 4 there. Any plans for fixing these bugs in official

Re: [sqlite] new uploads

2004-11-02 Thread mike cariotoglou
- Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 02, 2004 5:25 PM Subject: Re: [sqlite] new uploads ok, Denis I have fixed the bug and uploaded the new version of sqlite3Explorer. thanks for pointing it out. BTW, I have some

[sqlite] column def vs. constraint at end of create table stmt

2004-11-02 Thread j-marvin
hi- I am working on making my program for viewing sql statement results and changing table structure a little nicer. the reason the question came about below is I thought I'd like to add capability to have more than one field be the primary key and also would like to add the constraint unique

Re: [sqlite] php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed.

2004-11-02 Thread D. Richard Hipp
Per Jessen wrote: I've now rebuilt a copy from the CVS and I still get the: php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed. I didn't rebuild the database though - is it needed? This cannot be the case since in the latest code from CVS, there is no assert() on line 128, either in

[sqlite] php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed.

2004-11-02 Thread Per Jessen
D. Richard Hipp wrote: > Per Jessen wrote: >> I'm running a small php-script in command-line mode - initially everything >> goes fine until a table in the db reaches around 8700 rows, then I see the >> assert failing. >> >> This is 2.8.15, which I'm using with PHP4.3.8/SQLite-1.0.3. I don't

Re: [sqlite] php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed.

2004-11-02 Thread D. Richard Hipp
Per Jessen wrote: FYI, I tried building from CVS - btree.c doesn't compile with -DNDEBUG. We have just begun work on some major enhancements to the library. So issues like this will come up from time to time in CVSHEAD for the next couple of months. You can either fall back to the previous

Re: [sqlite] php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed.

2004-11-02 Thread Per Jessen
Per Jessen wrote: > D. Richard Hipp wrote: > >> This is probably the same as ticket #896 which is fixed in the CVS tree. >> See: > > FYI, I tried building from CVS - btree.c doesn't compile with -DNDEBUG. > And when I edited the Makefile.in to remove -DNDEBUG, I ended up with: Did another

Re: [sqlite] php: src/auth.c:128: sqliteAuthRead: Assertion `pStack!=0' failed.

2004-11-02 Thread Per Jessen
D. Richard Hipp wrote: > This is probably the same as ticket #896 which is fixed in the CVS tree. > See: FYI, I tried building from CVS - btree.c doesn't compile with -DNDEBUG. And when I edited the Makefile.in to remove -DNDEBUG, I ended up with: ./libtool --mode=link gcc -g -O2 -DOS_UNIX=1

Re: [sqlite] Question about UTF8 encoding in SQLite version 2.8.13

2004-11-02 Thread Cory Nelson
Not a whole lot. For the most part, change sqlite_ to sqlite3_, and add 16 to the end of funcs you want in unicode. Have you tried using setlocale() to use a swedish codepage? On Tue, 02 Nov 2004 16:54:40 +, Liz Steel <[EMAIL PROTECTED]> wrote: > Thanks for your reply, however, wcstombs

Re: [sqlite][adodotnetsqlite] Writing an in-memory database to file

2004-11-02 Thread D. Richard Hipp
Didier BRETIN wrote: Cmd.CommandText = "ATTACH DATABASE database AS main"; The original memory database is called "main". Choose a different name. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] new uploads

2004-11-02 Thread D. Richard Hipp
Dennis Cote wrote: I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error from Hurricane Electric. Please use http://www.sqlite.org/contrib instead. That particular link should not be

Re: [sqlite] Question about UTF8 encoding in SQLite version 2.8.13

2004-11-02 Thread Liz Steel
Thanks for your reply, however, wcstombs uses the default code page rather that UTF8, which is where I was going wrong with using it originally. Unfortunately, it is unlikely that I will get approval to use libiconv as it is third-party software. How much effort is involved with converting to

Re: [sqlite] Question about UTF8 encoding in SQLite version 2.8.13

2004-11-02 Thread Cory Nelson
Well, wcstombs uses WideCharToMultiByte() internally, with some more locality checks added in. Maybe you are using it wrong? If you cant get that to work, libiconv is great for converting charsets. Is there any reason you can't use sqlite 3.x? It has native unicode support. On Tue, 02 Nov

Re: [sqlite] Question about UTF8 encoding in SQLite version 2.8.13

2004-11-02 Thread Christian Smith
On Tue, 2 Nov 2004, Liz Steel wrote: >However, when I call sqlite_open with a multibyte string, it doesn't seem to >work as I expect. > >To clarify: I have a database name with Swedish characters in, which are >converted to multibyte characters, however, the filename that is created >treats each

Re: [sqlite] Crypt the database file

2004-11-02 Thread Ng Pheng Siong
On Tue, Nov 02, 2004 at 01:58:42PM +0100, Didier BRETIN wrote: > I'm new to SQLite, and I try to know if it is possible to crypt de > database file used by > SQLite. I try to find some documentation on this but I found nothing :(. http://www.sqlcrypt.com Currently in beta testing. Signups are

Re: [sqlite] new uploads

2004-11-02 Thread Massimiliano
Dennis Cote wrote: Richard, I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error from Hurricane Electric. may is that the link you're looking for: http://www.sqlite.org/contrib Ciao

Re: [sqlite] help with ADO.NET Data Provider for SQLite from Finisar

2004-11-02 Thread Didier BRETIN
Hi Giuliano, ISA Informatica a écrit : Hello, I downloaded the ADO.NET Data Provider for SQLite from Finisar http://sourceforge.net/projects/adodotnetsqlite but when i start the project i receive always the error message that a reference is missing... NUnit... I added the reference, but still

Re: [sqlite][adodotnetsqlite] Writing an in-memory database to file

2004-11-02 Thread Didier BRETIN
Hi, D. Richard Hipp wrote : Gerhard Haering wrote: On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote: Hello all, I wonder if there is a possibility to save (dump) an in-memory database to file (and vice versa, loading from file) in a fast way? (Without having to create a new database

Re: [sqlite] Join function in select statement

2004-11-02 Thread Dan Keeley
Loading shared libraries is easy enough on windows and Linux, but throw AIX and HPUX and Solaris into the mix and suddenly things become more complicated. SQLite is a cross-platform library. It has to work on more than just windows. Really? Both these platforms support shared libraries - I use

Re: [sqlite] new uploads

2004-11-02 Thread Dennis Cote
CARIOTOGLOU MIKE wrote: > I have uploaded the new version of sqlite3Explorer, which fixes a bug > with the schema treeview. Richard, I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error

RE: [sqlite] Join function in select statement

2004-11-02 Thread CARIOTOGLOU MIKE
> -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 4:49 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Join function in select statement > > > CARIOTOGLOU MIKE wrote: > > Why not provide some extra functionality on one platform

Re: [sqlite] Join function in select statement

2004-11-02 Thread D. Richard Hipp
CARIOTOGLOU MIKE wrote: Why not provide some extra functionality on one platform ? Because that's not what SQLite does. SQLite works the same on all platforms. Note also that were this policy to change and SQLite were allowed to have extra features on selected platforms, it is most likely that

Re: [sqlite] Join function in select statement

2004-11-02 Thread Gerhard Haering
On Tue, Nov 02, 2004 at 04:36:41PM +0200, CARIOTOGLOU MIKE wrote: > [user-defined functions loadable through shared libraries] > true. OTOH, since, as you say, it *is* simple, why not provide some extra > functionality on one platform ? it does not affect other platforms, and it > is s nice to

RE: [sqlite] Join function in select statement

2004-11-02 Thread CARIOTOGLOU MIKE
true. OTOH, since, as you say, it *is* simple, why not provide some extra functionality on one platform ? it does not affect other platforms, and it is s nice to have.. it would be an IFDEF thingy, anyway.. of course, you know best. > -Original Message- > From: D. Richard Hipp

Re: [sqlite] Anyone knows any sqlite based bullettin board ?

2004-11-02 Thread DJ Anubis
Le mardi 2 Novembre 2004 09:36, George Ionescu a ÃcritÂ: > I'm looking for an sqlite-based bulletin board to run under linux. > Any recommendations? All PHP CMS, forum and boards using adodb php class can use sqlite. Google with sqlite cms -- JCR aka DJ Anubis LAB Project Initiator &

Re: [sqlite] Join function in select statement

2004-11-02 Thread D. Richard Hipp
CARIOTOGLOU MIKE wrote: write a user-defined function in your hosting code. the only problem is, people that use your database (as opposed to your code), will not be able to use the function. DRH, what about DLL-loadable functions ? this should be easy to arrange, and would be of enormous help.

Re: [sqlite] Writing an in-memory database to file

2004-11-02 Thread D. Richard Hipp
Gerhard Haering wrote: On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote: Hello all, I wonder if there is a possibility to save (dump) an in-memory database to file (and vice versa, loading from file) in a fast way? (Without having to create a new database and copying records by

Re: [sqlite] Crypt the database file

2004-11-02 Thread Tito Ciuro
Hello Didier, Check: http://www.hwaci.com/sw/sqlite/prosupport.html The second paragraph in particular... Regards, -- Tito On Nov 2, 2004, at 13:58, Didier BRETIN wrote: Hello, I'm new to SQLite, and I try to know if it is possible to crypt de database file used by SQLite. I try to find some

[sqlite] Crypt the database file

2004-11-02 Thread Didier BRETIN
Hello, I'm new to SQLite, and I try to know if it is possible to crypt de database file used by SQLite. I try to find some documentation on this but I found nothing :(. Is it possible ? I would like to use SQLite for my application but if the database file can be read by every body it's a bad

Re: [sqlite] Writing an in-memory database to file

2004-11-02 Thread Gerhard Haering
On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote: > Hello all, > > I wonder if there is a possibility to save (dump) an in-memory > database to file (and vice versa, loading from file) in a fast way? > (Without having to create a new database and copying records by > select and

[sqlite] Writing an in-memory database to file

2004-11-02 Thread Oliver Bienert
Hello all, I wonder if there is a possibility to save (dump) an in-memory database to file (and vice versa, loading from file) in a fast way? (Without having to create a new database and copying records by select and inserts) Oliver

[sqlite] new uploads

2004-11-02 Thread CARIOTOGLOU MIKE
I have uploaded the new version of sqlite3Explorer, which fixes a bug with the schema treeview.

Re: [sqlite] Join function in select statement

2004-11-02 Thread Eric Bohlman
Marcel Strittmatter wrote: Hi all I like to have a join function that I can use in a select statement like this: select join(name, ',') from people; this should produce something like this: scott,martin,jones,adams It is not possible to use perl or another script language. The only language I

RE: [sqlite] new uploads

2004-11-02 Thread CARIOTOGLOU MIKE
I believe I know what is wrong, it has to do with tables that have implicit indexes. I will upload a new version in an hour. pls give it a try, and let me know. if it does not work, send me your database (zipped). regards. > -Original Message- > From: Dennis Cote [mailto:[EMAIL

[sqlite] Anyone knows any sqlite based bullettin board ?

2004-11-02 Thread George Ionescu
Hello Dr. Hipp, hello sqlite users, I'm looking for an sqlite-based bulletin board to run under linux. Any recommendations? Thanks. Regards, George Ionescu