[sqlite] Database protected

2006-12-05 Thread made hendra
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

2006-11-28 Thread made hendra
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

2006-11-28 Thread made hendra
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

2006-11-27 Thread made hendra
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

2006-11-27 Thread made hendra
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]
-