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
-~----------~----~----~----~------~----~------~--~---
