Re: RE: [sqlite] about SQLite Explore wit h dll(3.2.7) problem

thanks for your good tool,I test it more,it cause by chinese character in the path,there maybe some mistake in the dll version,in my application,I complie source directly,it works. and more suggestion for this tool,there need some more task to do on the behavor,such as when closing the

[sqlite] Delay during insert - Was: [sqlite] How to cross compile sqlite-3.2.7 for arm9 s3c2410?

Hi Ron, > I have noticed that when I create a database and do a simple INSERT, (using > the sqlite3 binary), there is an appreciable delay (1-2 seconds) before > sqlite3 returns to the prompt. When doing SELECT there is no delay. Mmm, can't say that I have seen any strange delays on the arm

[sqlite] Accessing SQLite from VB.NET 2002

I've been trying to access SQLite3 from VB.NET 2002 using SQLite ADO.NET data providers and I keep getting the following error message: "An unhandled exception of type 'System.IO.FileNotFoundException' occurred in system.windows.forms.dll Additional information: File or assembly name

Re: [sqlite] Tool to load a database and see all tables and fields.

Is there a version for Linux? So far I have only found slqbrowser being useful/free free Linux. Sqlitespy for windows looks pretty nice, btw. Eno Ralf Junker wrote: Hello Koen, have you tried SQLiteSpy? It has a nice schema tree and multiple, tabbed SQL edits to execute commands and

Re: [sqlite] How to cross compile sqlite-3.2.7 for arm9 s3c2410?

On Tue, September 27, 2005 7:39, Frank van Vugt said: > There's some info in the wiki on it, but basically the steps are: Hello, Frank - I successfully created an ARM sqlite3 (3.2.7) and it is running on my Archos PMA400 - thanks! I have noticed that when I create a database and do a simple

RE: [sqlite] about SQLite Explore with dll(3.2.7) problem

hi. I am the author of this program. I have not seen what you mentioned, but in any case, I am about to release a new major release 2.0 in a few days, which has been tested with 3.2.7 and does not seem to have any problems. From: Huanghongdong [mailto:[EMAIL

Re: [sqlite] Tool to load a database and see all tables and fields.

spudse bud wrote: I always was a big fan of phpmyadmin because when php/mysql errored I could check table/field names etc to see where my script goes wrong. I am wondering if a easy tool exsists for SQLite, that just lists the tables and fields in a database. I have tried sqlitemanager, but I

Re: [sqlite] Tool to load a database and see all tables and fields.

Hello Koen, have you tried SQLiteSpy? It has a nice schema tree and multiple, tabbed SQL edits to execute commands and queries. Data retrieval is very fast, the memory requirements low. SQLiteSpy is freeware for personal use. Commercial users are kindly asked for a small dontaion. Download

Re: [sqlite] compression

On 9/28/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: > > > This is from my Gentoo 2005.1 Linux system (home) with whatever packages > it installed a few days ago. > At work I use FreeBSD and I've not used loopback devices there, but the > FreeBSD Handbook (online for free) shows how to do it. > >

Re: [sqlite] Tool to load a database and see all tables and fields.

On my site i have a tool, www.hellobasic.com - Original Message - From: "Eno Thereska" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 28, 2005 4:36 PM Subject: Re: [sqlite] Tool to load a database and see all tables and fields. What about

Re: [sqlite] compression

Jay Sprenkle wrote: On 9/28/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: Your third statement is not true. On Linux (and FreeBSD, but FreeBSD does not have Reiser as far as I know) you can treat a regular file as if it were a filesystem and mount that fiel system via the "loop back"

Re: [sqlite] Case-sensitive table names

On 9/28/05, Ivo Kulms <[EMAIL PROTECTED]> wrote: > Sorry, I was a little bit unclear. > > My problem is that I have the need to treat "table1" and "TABLE1" as two > single entities. You need to treat table1 and TABLE1 as *separate* or the same? And I apologize -- at least with the version of

Re: [sqlite] compression

Christian Smith wrote: On Wed, 28 Sep 2005, Sid Liu wrote: Is there a possibility that this Reiser 4 be used on a file, rather than a file system? Hopefully on Windows? Reiser FS is a filesystem. It manages files. So it cannot be used on a file. Your third statement is not

AW: [sqlite] Case-sensitive table names

Sorry, I was a little bit unclear. My problem is that I have the need to treat "table1" and "TABLE1" as two single entities. ivo -Ursprüngliche Nachricht- Von: Austin Ziegler [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 28. September 2005 16:21 An: sqlite-users@sqlite.org; [EMAIL

Re: [sqlite] compression

On Wed, 28 Sep 2005, Sid Liu wrote: >Is there a possibility that this Reiser 4 be used on a >file, rather than a file system? Hopefully on Windows? Reiser FS is a filesystem. It manages files. So it cannot be used on a file. Windows NTFS already has compressed files. Right click a file or

Re: [sqlite] Tool to load a database and see all tables and fields.

What about sqlitebrowser? That's what I currently use. Eno spudse bud wrote: > I always was a big fan of phpmyadmin because when php/mysql errored I could > check table/field names etc to see where my script goes wrong. > > I am wondering if a easy tool exsists for SQLite, that just lists the

[sqlite] about SQLite Explore with dll(3.2.7) problem

I notic if I change the SQLiteExplore's dll to version 3.2.7 and use it to open the database wich created by old version dll then I get the a erro message,it saying something like "can't open the database file",anyone have idea?

[sqlite] Tool to load a database and see all tables and fields.

I always was a big fan of phpmyadmin because when php/mysql errored I could check table/field names etc to see where my script goes wrong. I am wondering if a easy tool exsists for SQLite, that just lists the tables and fields in a database. I have tried sqlitemanager, but I didn't really liked

Re: [sqlite] compression

Is there a possibility that this Reiser 4 be used on a file, rather than a file system? Hopefully on Windows? --- Jay Sprenkle <[EMAIL PROTECTED]> wrote: > If you're on Linux read about the Reiser 4 file > system. > They found they could compress the entire file > system on the fly and achieve >

Re: [sqlite] Rewriting a query

> What happens if you create the index on sCommunityID only? Does > it still do the full table scan? A bit difficult to drop the (sCommunityID, sTransactionID) index, as it's the primary key. > Also, don't overlook using UNION or UNION ALL, ugly as they > can be. Maybe something like this

[sqlite] Case-sensitive table names

Hi there, Is it possible in sqlite to work with case-sensitive table- and column names? (Sorry if this has been already answered somewhere in the documentation, but I did not seem to find it.) Cheers, ivo

Re: [sqlite] Rewriting a query

What happens if you create the index on sCommunityID only? Does it still do the full table scan? Also, don't overlook using UNION or UNION ALL, ugly as they can be. Maybe something like this could be used to avoid creating a very small temporary table: SELECT ... FROM (SELECT ... UNION SELECT

Re: [sqlite] Rewriting a query

The following works for me. The Community table has only one entry per community ID so it's fast to look up. SELECT sCommunityID, (SELECT sTransactionID FROM TransactionList WHERE sCommunityID = Community.sCommunityID

[sqlite] Rewriting a query

I have this query: SELECT sCommunityID, max(sTransactionID) FROM TransactionList WHERE sCommunityID in ('a03061bFi','a03064KDy', 'a03068QhK') GROUP BY sCommunityID There is an index on (sCommunityID, sTransactionID) This forces a table scan (perhaps improved

[sqlite] Re: Patch proposal

2005/9/28, Vivien Malerba <[EMAIL PROTECTED]>: > Hi! > > Here is a small patch which modifies the returned data set of the > PRAGMA table_info() to add a new column named "auto_inc" which > contains 1 if the corresponding field has the AUTO INCREMENT in its > definition and 0 otherwise. > > Could

Re: [sqlite] Schemas

On 9/28/05, Vivien Malerba <[EMAIL PROTECTED]> wrote: > 2005/9/28, Firman Wandayandi <[EMAIL PROTECTED]>: > > On 9/27/05, Vivien Malerba <[EMAIL PROTECTED]> wrote: > > > Hi! > > > > > > I'm working on the SQLite interface between the Libgda library and the > > > SQLite database. For the job, I

Re: [sqlite] Schemas

2005/9/28, Firman Wandayandi <[EMAIL PROTECTED]>: > On 9/27/05, Vivien Malerba <[EMAIL PROTECTED]> wrote: > > Hi! > > > > I'm working on the SQLite interface between the Libgda library and the > > SQLite database. For the job, I need to know information about the > > database schema, and I'm using