Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

On Tue, Apr 29, 2008 at 10:10 PM, [EMAIL PROTECTED] wrote: P Kishor, http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Oops, that's embarrassing! Do you have a favorite on this page that you would recommend? Thank you, Malcolm tkSQLite at

Re: [sqlite] FTS search negative term syntax

Fair warning, though: It's not entirely clear that the fts search syntax should aim to hew too closely to consumer-oriented search syntax. Interesting point, too. Up to now, I always perceived the FTS search syntax to be very much consumer-oriented. It it just too similar to major search

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

Thanks Robert! tkSQLite at http://reddog.s35.xrea.com/wiki/TkSQLite.html Regards, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] accented characters upper/lower case in SELECT LIKE statements

Hello I know it has already been discussed, but I could not find a detailed and final answer: in my database there will be accented characters (like the word ação, which means action and I have to make SELECT LIKE statements to which AÇÃO and ação would be met in the same query. I'm using

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

On Wed, 30 Apr 2008 13:23:51 -0400, you wrote: I've had good luck with Mike Cariotoglou's free Sqlite3Explorer http://www.singular.gr/sqlite/ I especially like being able execute just the sql command that I've highlighted. I agree. I played with a few other frontends, but always find

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

Thanks Kees! I played with a few other frontends, but always find myself back in Sqlite3Explorer. ... find a way to start FireFox with this add-on opening the database I'm interested in from a shell script, or associate my preferred sqlite3 filename extension (.db3) with it. I've been

Re: [sqlite] accented characters upper/lower case in SELECT LIKE statements

On Thu, May 01, 2008 at 10:45:17AM -0300, Francisco Ares scratched on the wall: Hello I know it has already been discussed, but I could not find a detailed and final answer: This is well documented: http://www.sqlite.org/lang_expr.html Read the section on the 'LIKE' operator. It is

Re: [sqlite] accented characters upper/lower case in SELECT LIKE statements

Thanks Jay. francisco On Thu, May 1, 2008 at 11:09 AM, Jay A. Kreibich [EMAIL PROTECTED] wrote: On Thu, May 01, 2008 at 10:45:17AM -0300, Francisco Ares scratched on the wall: Hello I know it has already been discussed, but I could not find a detailed and final answer: This

Re: [sqlite] In memory data base questions ???

THANKS Igor! On Tue, Apr 29, 2008 at 6:38 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote: Just want to make a note that when I say in-memory data base I don't mean the cache memory I mean the :memory: date base. That's how I understood you, yes. Igor

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

Malcolm: I use Firefox and I installed the SQLite add-in. I really like it! Jeff [EMAIL PROTECTED] wrote: Thanks Kees! I played with a few other frontends, but always find myself back in Sqlite3Explorer. ... find a way to start FireFox with this add-on opening the database I'm

Re: [sqlite] accented characters upper/lower case in SELECT LIKE statements

On May 1, 2008, at 4:09 PM, Jay A. Kreibich wrote: As the document referenced above explains, you can create a user function called like(A,B) that will over-ride the built-in behavior for LIKE. If you're only dealing with one language, such as Brazilian-Portuguese, then you can just

Re: [sqlite] numRows undefined function?

On Wed, Apr 30, 2008 at 4:50 PM, Skip Evans [EMAIL PROTECTED] wrote: But why did so much documentation I found on the web use numRows()? What is the difference between the PDOStatement set of functions and the set to which numRows() belongs to? Different versions of SQLite? Thanks

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

I use Firefox and I installed the SQLite add-in. I really like it! Thanks Jeff! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Recommended pragmas for new SQLite users to focus on

Hi Donald, I think you're right for general purpose applications. But if you have ETL or data conversion/analysis applications that can be re-run after a failure (using source content), this type of pragma sounds like a reasonable choice. I very much agree with your statement -- I turn it

Re: [sqlite] FTS search negative term syntax

On Thu, May 1, 2008 at 1:41 AM, Ralf Junker [EMAIL PROTECTED] wrote: Fair warning, though: It's not entirely clear that the fts search syntax should aim to hew too closely to consumer-oriented search syntax. Interesting point, too. Up to now, I always perceived the FTS search syntax to be very

Re: [sqlite] Recommended SQLite utilities

Hi Malcolm, Looking for recommendations for 3rd party SQLite utilities for browsing, maintaining, importing/exporting and repairing SQLite database files. I'm open to Mac only products as well. I started a tabulated comparison of various SQLite GUI applications for Mac here:

Re: [sqlite] splite database under version control (subversion)?

In the BIG db I have worked on there is a table that log every insert/update on specific and important tables and a log of every sql statement execute but I haven't ever see a db under version control with svn (or csv or git or any other). -- [image: Just A Little Bit Of