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
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:
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
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
> 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
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?
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
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
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,
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
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
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
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
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
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
>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
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
17 matches
Mail list logo