[sqlite] Database protected
Hello sqlite-users, Are there a way to protected sqlite database? with password maybe. So it can not be easily opened with "sqlite3.exe somedatabase.db" or with some sqlite browser. Thank You -- Regards made hendra <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re[2]: [sqlite] Music Files
Hello John, Wednesday, November 29, 2006, 1:08:56 AM, you wrote: > Here are a couple of links to get you started. I suggest you google > your way until you find something which suits you. > http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers > http://www.freevbcode.com/ShowCode.asp?ID=6893 I already have googling and i still not found wrapper that suit on me. I already have try AGS_SQLITE wrapper too, it nice but it still using sqlite2 library. Do you have some reference, where i can learn about making wrapper, a tutorial maybe. I intend to cook wrapper for my self (i hope) :) Best Regards, made hendra - To unsubscribe, send email to [EMAIL PROTECTED] -
Re[2]: [sqlite] Music Files
Thanks John, Btw, i'm not a sqlite advance nor vb. I'm not fully understand about vb wrapper. I always using ODBC to create database connection. Any suggest or clue? where i can find vb wrapper for sqlite(3). Tuesday, November 28, 2006, 11:11:04 PM, you wrote: > I cannot help you with ODBC, but if you have an embedded sqlite database > you may be much better off to use the Sqlite API directly rather > than SQL/CLI (ODBC). The Sqlite API handles BLOBs very effectively. > Even if you use something like VB you can find an interface (wrapper) > for the Sqlite API which will work effectively. > You should be aware that Sqlite is not a DBMS server like Sql Server, > Oracle or DB2, it is a library of routines to embed in your application. > If you use it that way the ODBC route does not make much sense and you > lose much of the simplicity of Sqlite. > An Sqlite database is just a single file, so you can see how simple that > makes managing your application. Backups and recovery are so simple. > Distribution of databases cannot be simpler. Best Regards, made hendra - To unsubscribe, send email to [EMAIL PROTECTED] -
Re[2]: [sqlite] Music Files
Hello John, Tuesday, November 28, 2006, 4:08:58 AM, you wrote: > sebcity wrote: >> Is it possible to store mp3 files in a SSQLite database? would they be able >> to be played from the database? How would you save them? > Write them as a BLOB. Are there Sqlite ODBC that support BLOB, or maybe other way to access blob without ODBC? - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] vb sqlite
hi I'm a newbies in sqlite, i'm a vb programmer. I want to develop database software (Point of Sales) under vb and sqlite. From the sqlite official website, i fond that sqlite is great database. I need your opinion, is it wrong or right using sqlite as database for my vb application. Can you give me some reference where are the right mailing list (discussing) about vb and sqlite database. Thanks for your sharing. made hendra (Balinese Programmer) - To unsubscribe, send email to [EMAIL PROTECTED] -