Re: [sqlite] Understanding Sqlite

2014-06-07 Thread Stephen Chrzanowski
I took a course back in the day when MSSQL-2000 was just coming out, or
just had come out.  I learned the nuts and bolts (Right down to the freak'n
file format used at the time -- Ironically, that was the best part and I
did enjoy that the most), the concepts, the attitude, and the mentality of
MS-SQL and some of its features.  Anything else I've picked up over the
years, I've referred to the Mediocre Metacrawler (Back when it was good and
not spam haven) and Glorious Google to give me the answers I needed without
having to dust off the old manuals.  I avoided Yahoo like the plague.
Still do even today.  I've purchased SQL cook books, read through their
scenarios, attempted to come up with my own result, sometimes succeeding,
other times failing so badly I had to ask myself why I even bothered.

If you're looking for a certificate, there are online courses.  Use Google
to find references for the different sites to VERIFY that they're worth
their salt and SELECT statements.  Don't look SPECIFICALLY for SQLite as
there are no certificates that I'm aware of, so going with another RDBMS,
learning what this relational transaction stuff is all about, learn how the
SELECT/DELETE/UPDATE statements work with all their parameters and
functions, get the foundation to build a working database ground up, THEN
translate that into any other language with relative ease.  Often times,
depending on the position you're applying for, if you put that you have a
certificate founded in the RDBMS arena, it won't matter what the back end
you're using is, because you can/should be able to easily adapt to whatever
technology is there.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] FTS module and DB close

2014-06-07 Thread gwenn
Hello,
How do you prevent double free/finalize of statements created by the
FTS module ?
I am using sqlite3_next_stmt to finalize all dangling statements
before closing the connection but the program crashes because the FTS
module finalizes them too when sqlite3_close is called...
May be I should use sqlite3_close_v2 (not available on MacOS X: SQLite
version 3.7.13) ?

Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users