RE: [sqlite] ANN: Sqlite3Explorer
I am afraid not. the components I am using do not port to Linux. > -Original Message- > From: Leif Jensen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 30, 2005 7:56 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: Sqlite3Explorer > >Any chance for a Linux version ? Or a web version ? > >Greetings, > > Leif > > > Cariotoglou Mike wrote: > > >New version is out. Since the problem with size limits was > not lifted > >from contrib, I created a home site for the program. You will now be > >able to get latest version from > > > >http://www.singular.gr/sqlite > > > >Latest is 1.1 , 24/3/2005 (ignore the typo in the date) > > > >Regards,mike > > > > > > > > > > >
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: Noel Frankinet wrote: I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this problem. Well, I don't know why it doesn't work on your windows PC, I am sorry :-( Any other comment from other ? That flash interface will be used with a PHP5 class file to manage, with user and password, your online sqlite files too, should be interesting ? Regards, Andrea Giammarchi A virtual machine is a test a test config inside vmware. The trace back I have sent should show where the error is. Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
RE: [sqlite] sqlitebrowser alternative
I gave it a try, and it told me a DLL was missing. So I put that DLL (msvcr71.dll, I believe) in my Windows\System32 directory, then it told me another DLL was missing, so at that point I gave up. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Andrea Giammarchi [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 1:18 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlitebrowser alternative Noel Frankinet wrote: > I was not able to do anything, the rogram crashed immediately, I have > several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this problem. Well, I don't know why it doesn't work on your windows PC, I am sorry :-( Any other comment from other ? That flash interface will be used with a PHP5 class file to manage, with user and password, your online sqlite files too, should be interesting ? Regards, Andrea Giammarchi
Re: [sqlite] sqlitebrowser alternative
Noel Frankinet wrote: I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this problem. Well, I don't know why it doesn't work on your windows PC, I am sorry :-( Any other comment from other ? That flash interface will be used with a PHP5 class file to manage, with user and password, your online sqlite files too, should be interesting ? Regards, Andrea Giammarchi
Re: [sqlite] working with dates
On Mar 29, 2005, at 11:17 PM, Charles Mills wrote: How have people writing SQLite bindings (or in general) dealt with inserting/binding and selecting time values? I find it helpful to use the julianday representation in timestamp fields, since it sorts correctly and SQLite can convert it to pretty formats or unix time in SQL. -- Randall Randall <[EMAIL PROTECTED]> "Are you hungry? I haven't eaten since later this afternoon." -- Aaron, _Primer_
Re: [sqlite] ANN: Sqlite3Explorer
Any chance for a Linux version ? Or a web version ? Greetings, Leif Cariotoglou Mike wrote: New version is out. Since the problem with size limits was not lifted from contrib, I created a home site for the program. You will now be able to get latest version from http://www.singular.gr/sqlite Latest is 1.1 , 24/3/2005 (ignore the typo in the date) Regards,mike
[sqlite] working with dates
How have people writing SQLite bindings (or in general) dealt with inserting/binding and selecting time values? Some issues are * sort order * equivalence * recognizing time values when selecting from a database * allowing users to manipulate time values using SQL (specifically SQLite's built in date time functions). What kind of conventions helpful, required, or unnecessary? -Charlie
[sqlite] Deleting journal files
Hello all, We've been using SQLite for our database needs in our new program version, and unfortunately, we've run into some corruption issues. We believe that the corruption has been caused by deleting journal files. The program is a music manager and when managing a portable device, we copy the database locally before opening it. If the program crashed in the middle of a transaction, a journal file would be left there. Therefore, the next time the database was opened, it did not match the journal file, and would cause "strange stuff" to happen. We detected the problems this caused, and our fix was to always delete the journal file before opening with sqlite_open(). After some more research, we discovered that always deleting the journal wasn't quite right. We now only delete the journal file when we know that the database and journal don't match. So are there any other cases when we should delete the journal file when opening a database? Can always we leave the journal alone if we open the database while a transaction is active? We are using SQLite 2.8.16. Thanks, Aaron
[sqlite] ANN: Sqlite3Explorer
New version is out. Since the problem with size limits was not lifted from contrib, I created a home site for the program. You will now be able to get latest version from http://www.singular.gr/sqlite Latest is 1.1 , 24/3/2005 (ignore the typo in the date) Regards,mike
[sqlite] A questionable bit of code
I have been trying to track down a crasher in my multi-threaded sqlite 3.2.0 application. I was seeing crashes in highly contentious situations where many threads are opening and closing a database frequently. The crash was consistently in the following bit of code: src/main.c in sqlite_close starting on line 527 #ifndef SQLITE_OMIT_GLOBALRECOVER { sqlite3 *pPrev = pDbList; sqlite3OsEnterMutex(); while( pPrev && pPrev->pNext!=db ){ pPrev = pPrev->pNext; } if( pPrev ){ pPrev->pNext = db->pNext; }else{ assert( pDbList==db ); pDbList = db->pNext; } sqlite3OsLeaveMutex(); } #endif The problem is that pPrev can be left dangling since the pDbList pointer is saved off before entering the mutex. It is possible that another thread already in the mutex at that time ends up sqliteFree'ing what was the pDbList head, invalidating pPrev for the other thread, causing the crash. Swapping these two lines fixes the problem: sqlite3 *pPrev = pDbList; sqlite3OsEnterMutex(); change to: sqlite3OsEnterMutex(); sqlite3 *pPrev = pDbList; Once I made this change, the crash vanished. I just looked in the 3.2.1 source and this bit of code is the same. -Kyle
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: Noel Frankinet wrote: windows 2000 prof. well, I have tried on windows 2000 prof. SP4 right now ... it works perfectly, are you sure to have opened an uncorrupted sqlite *version 2 *file ??? Really strange if you are sure, anyone should tell me if this program works correctly ? See you, andr3a I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlitebrowser alternative
Noel Frankinet wrote: windows 2000 prof. well, I have tried on windows 2000 prof. SP4 right now ... it works perfectly, are you sure to have opened an uncorrupted sqlite *version 2 *file ??? Really strange if you are sure, anyone should tell me if this program works correctly ? See you, andr3a
[sqlite] Version 3.2.1
SQLite version 3.2.1 is now available on the website. This release fixes a few problems with the new ADD COLUMN command. Upgrade only if you plan to use ADD COLUMN. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: Hello andrea, Thank you Noel Frankinet for this repot , I just use this application to manage my sqlite database files ... well, Windows XP SP2 and flash player 7, no problema with a lot of database files .. -very heavy download I am working to have a better host ... I am sorry, I know this is slow ... -Install a lot a multi-megabytes dll I have used py2exe, it installs itself a lot of dlls ... because I've not created any dll ... you know that wxpython is just 4,5 megabytes ... -does not work (see log) should you please tell me what version of windows are you using ? windows 2000 prof. - I would prefer a statically linked single exe program written in c that works. he he ... but it works too, however it's an alternative with some features that sqlitebrowser has not :-) ( but has not some features that sqlite browser has ... ) Regards, andr3a Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlitebrowser alternative
Thank you Noel Frankinet for this repot , I just use this application to manage my sqlite database files ... well, Windows XP SP2 and flash player 7, no problema with a lot of database files .. -very heavy download I am working to have a better host ... I am sorry, I know this is slow ... -Install a lot a multi-megabytes dll I have used py2exe, it installs itself a lot of dlls ... because I've not created any dll ... you know that wxpython is just 4,5 megabytes ... -does not work (see log) should you please tell me what version of windows are you using ? - I would prefer a statically linked single exe program written in c that works. he he ... but it works too, however it's an alternative with some features that sqlitebrowser has not :-) ( but has not some features that sqlite browser has ... ) Regards, andr3a
Re: [sqlite] RegEx w/ sqlite, yet?
In PHP it's very easy to create user defined functions. Just look in manual: http://lv2.php.net/manual/en/function.sqlite-create-function.php There you can find an example how to create sort of md5 function in SQLite as a callback. In similar way you can in very simple way create preg_match/ereg funcion callbacks. -- Martins From: Win a 2 [EMAIL PROTECTED] Date: Mon, 28 Mar 2005 21:01:33 +0300 To: Cariotoglou Mike sqlite-users@sqlite.org Subject: Re: [sqlite] RegEx w/ sqlite, yet? > Hello Cariotoglou, > > Monday, March 28, 2005, 7:23:23 AM, you wrote: > > > If you are working with delphi, I could have a solution for you. > > >> -Original Message- > >> From: Jay [mailto:[EMAIL PROTECTED] > >> Sent: Saturday, March 26, 2005 3:41 AM > >> To: sqlite-users@sqlite.org; Win a 2 > >> Subject: Re: [sqlite] RegEx w/ sqlite, yet? > >> > >> > >> > Hello sqlite-users, > >> > > >> > any news on that? > >> > >> It's not part of the sql standard, so I would bet the answer > >> is going to be 'you have to add that yourself'. I did for my project. > >> > > No, I'm working with PHP. > I'm actually thinking about reading the data fields and to parse them > via PHP-regex. > But if it could be completly done in sqlite it would be better. > > -- > bye, > -=winne=-mailto:[EMAIL PROTECTED] >
Re: [sqlite] ALTER TABLE ... ADD COLUMN crashes with too many columns
On Tue, 2005-03-29 at 03:13 -0800, Andy Lutomirski wrote: > I can crash sqlite3 like this: > > % cat test.sql > create table a (id INTEGER PRIMARY KEY); > alter table a add column f1 TEXT; > alter table a add column f2 TEXT; > alter table a add column f3 TEXT; > alter table a add column f4 TEXT; > alter table a add column f5 TEXT; > alter table a add column f6 TEXT; > alter table a add column f7 TEXT; > alter table a add column f8 TEXT; > alter table a add column f9 TEXT; > alter table a add column f10 TEXT; > alter table a add column f11 TEXT; > alter table a add column f12 TEXT; > alter table a add column f13 TEXT; > % sqlite3 foo2.db < test.sql > *** glibc detected *** double free or corruption (out): > 0x005136f0 *** > Aborted > Ticket #1183 has already been fixed. Version 3.2.1 will be out in a day or so. Or you can grab the latest from CVS. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] concatenation of row with NULLS suppresses all values
On Mon, 2005-03-28 at 21:38 -0800, Jim Dodgen wrote: > thanks Derrell , > I guess I expect to see just the null values suppressed and the values that > exist to show up > > something like this: > > 1-- > 2-- > 3-33-333 > NULL concatenated with anything is still NULL. So the output should be NULL NULL 3-33-333 -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: I have just uploaded an "SQLITEBROWSER like" application made in Python and Flash 7. This application requires windows ( it's an exe file ) and Flash Player 7 installed. It works perfectly with all sqlite 2.X database files and it's easy to use ( I hope ). Please tell me what do you think about this little program, thank you :-) http://cmslim.3site.it/download.php?id=6 Andrea Giammarchi Hello, -very heavy download -Install a lot a multi-megabytes dll -does not work (see log) I would prefer a statically linked single exe program written in c that works. Best regards Traceback (most recent call last): File "Sqlite_2_Manager.py", line 136, in ? File "wx\_core.pyc", line 5301, in __init__ File "wx\_core.pyc", line 4980, in _BootstrapApp File "Sqlite_2_Manager.py", line 113, in OnInit File "Sqlite_2_Manager.py", line 20, in __init__ File "wx\lib\flashwin.pyc", line 40, in __init__ File "wx\activex.pyc", line 221, in __init__ wx._core.PyAssertionError: C++ assertion "wxAssertFailure" failed in contrib\activex\wxie/wxactivex.cpp(322): m_ActiveX.CreateInstance failed Traceback (most recent call last): File "Sqlite_2_Manager.py", line 136, in ? File "wx\_core.pyc", line 5301, in __init__ File "wx\_core.pyc", line 4980, in _BootstrapApp File "Sqlite_2_Manager.py", line 113, in OnInit File "Sqlite_2_Manager.py", line 20, in __init__ File "wx\lib\flashwin.pyc", line 40, in __init__ File "wx\activex.pyc", line 221, in __init__ wx._core.PyAssertionError: C++ assertion "wxAssertFailure" failed in contrib\activex\wxie/wxactivex.cpp(322): m_ActiveX.CreateInstance failed -- Noël Frankinet Gistek Software SA http://www.gistek.net
[sqlite] ALTER TABLE ... ADD COLUMN crashes with too many columns
I can crash sqlite3 like this: % cat test.sql create table a (id INTEGER PRIMARY KEY); alter table a add column f1 TEXT; alter table a add column f2 TEXT; alter table a add column f3 TEXT; alter table a add column f4 TEXT; alter table a add column f5 TEXT; alter table a add column f6 TEXT; alter table a add column f7 TEXT; alter table a add column f8 TEXT; alter table a add column f9 TEXT; alter table a add column f10 TEXT; alter table a add column f11 TEXT; alter table a add column f12 TEXT; alter table a add column f13 TEXT; % sqlite3 foo2.db < test.sql *** glibc detected *** double free or corruption (out): 0x005136f0 *** Aborted The backtrace is: #0 0x003aa212ec49 in raise () from /lib/tls/libc.so.6 #1 0x003aa213014e in abort () from /lib/tls/libc.so.6 #2 0x003aa2167b84 in malloc_usable_size () from /lib/tls/libc.so.6 #3 0x003aa2168646 in free () from /lib/tls/libc.so.6 #4 0x2ab0c55e in sqlite3FreeX (p=0x5146f0) at ./src/util.c:287 #5 0x2aae3097 in sqliteResetColumnNames (pTable=0x512750) at ./src/build.c:397 #6 0x2aae3174 in sqlite3DeleteTable (db=0x50b580, pTable=0x512750) at ./src/build.c:450 #7 0x2ab097ab in sqlite3RunParser (pParse=0x7fffdaa0, zSql=0x512720 "alter table a add column f9 TEXT;", pzErrMsg=0x7fffda98) at ./src/tokenize.c:425 #8 0x2aaf508e in sqlite3_prepare (db=0x50b580, zSql=0x512720 "alter table a add column f9 TEXT;", nBytes=-1, ppStmt=0x7fffdc20, pzTail=0x7fffdc28) at ./src/main.c:1056 #9 0x2ab1e0c6 in sqlite3_exec (db=0x50b580, zSql=0x512720 "alter table a add column f9 TEXT;", xCallback=0x402311 , pArg=0x7fffdd10, pzErrMsg=0x7fffdc90) at ./src/legacy.c:56 #10 0x00405b16 in process_input (p=0x7fffdd10, in=0x3aa231fb60) at ./src/shell.c:1503 #11 0x0040657f in main (argc=2, argv=0x7328) at ./src/shell.c:1795 This is sqlite 3.2.0, running on Gentoo amd64. Should I submit a bug report? Thanks, Andy
[sqlite] sqlitebrowser alternative
I have just uploaded an "SQLITEBROWSER like" application made in Python and Flash 7. This application requires windows ( it's an exe file ) and Flash Player 7 installed. It works perfectly with all sqlite 2.X database files and it's easy to use ( I hope ). Please tell me what do you think about this little program, thank you :-) http://cmslim.3site.it/download.php?id=6 Andrea Giammarchi