Hi, I think your are asking for an encrypted database, but you don't want encryption... I guess that's not possible, sorry.
Regards, Thomas On Sun, Sep 20, 2009 at 6:52 PM, ebrahim <[email protected]> wrote: > > Hi, > > I'm using h2 as embedded db in my application. i want to use in-memory > mode but this implies that the easiest way is to read it from a file: > CREATE TABLE table_name AS SELECT * FROM CSVREAD('file') > > now the file should be clear text and my application is distributed to > every one. the normal mode is protected by password, i don't want > anyone to have my db in a clear text file. > > can we have an in-memory db created from the normal db directly > without going to create it manually. > another point is that the previous SQL query will create table with > all of its columns as VARCHAR i.e. it doesn't preserve the type (e.g. > INTEGER). a solution is to create the table first and then INSERT INTO > table_name SELECT * FROM CSVREAD('file'). but why not creating it in > one go using the first SQL query. > > another question about the format of the db, is it public i.e. can > anybody with basic knowledge get the db without using the password > like in some recovery engines. encrypted db is nice but it kills the > performance. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
