Seems interesting, could you point on the issues in sqlite3 and compare them
with H2 and how H2 solved them?
Best regards,
Sylvain
On Fri, Apr 9, 2010 at 5:57 AM, James Gregurich bayouben...@mac.com wrote:
On Apr 8, 2010, at 8:58 PM, Sylvain Pointeau wrote:
You will probably end-up with a
The key feature that attracted my attention was MVCC. Based on what I have
read, that technique is what all the big boys are using to maximize their
performance. I figured that approach would likely work well for my needs.
I also spent time studying the source code for Firebird Postgresql to
Thank you for sharing your experience,
let's see, I may switch from sqlite to your H2 C++ version :-)
Best regards,
Sylvain
On Fri, Apr 9, 2010 at 8:15 AM, James Gregurich bayouben...@mac.com wrote:
The key feature that attracted my attention was MVCC. Based on what I have
read, that
Also a big thanks from me for sharing your experiences in such a clear
headed fashion.
There are people on this list who are interested to hear other people's
experiences about h2 codebase.
And to hear comparisons with other databases was most interesting!
- rami
On 9.4.2010 10:15, James
I am assuming you have two columns like
REF_KEY = a foreign key pointing to the table that has (contains) the array.
VALUE = the value that the array holds.
If I am right then where do you have the array index?
If you have no index then your collection is not an array but a bag (or
set if you
Hi,
I keep getting this error when I try to access my DB. I spent several
hours translating my MySQL schema into an H2 one, I close the db
(properly), and I can't reopen it or test the connection to it. It
looks like a parent 63 isn't found, but I don't understand what this
means: I never
Hi.
Looks like your database file is corrupted. Try to recreate database
from scratch.
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
Hi,
AFAIK by default this is impossible but you can try to write your
function which will
have file name as parameter and will return InputStream, create alias
in sql for it
(LOAD_FILE for example) and then insert like this
INSERT INTO mytable (id,name,file)
See also http://h2database.com/html/features.html#user_defined_functions
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
Hi,
This sounds like a custom data synchronization solution. To support
that, you either need a way to read from the transaction log, or you
have to build this system yourself using a trigger / triggers.
Reading from the transaction log would be nice, but there are
problems: the old data is not
Hi,
You are using version 1.2.129. There was a bug that was fixed in
version 1.2.131: In versions 1.2.129 and 1.2.130, a database could
not be opened sometimes after dropping tables or indexes, and then
creating new indexes for existing tables. The exception contained the
text parent not found
Hi,
See also http://www.h2database.com/html/functions.html#file_read
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
In your parlance I was talking about Table 2.
Here is the terminology mapping
You Me
--- --
ARRAY_KEY REF_KEY
ARRAY_ITEM VALUE
And I feel my analysis still holds (although you can model data many ways)
I think H2 will be just fine without primary
Edit: Correction, I misinterpreted.
Interesting approach. I can't find a mention in the H2 grammar page
about using REFERENCES without also specifying FOREIGN KEY, so I'll
assume that's what that's doing. I'm a bit unclean on how that
composite key works, though. I assume it's another way of
no. boost, STL libICU are sufficient as best I can tell. for the core of a
db, you need basic data structures, thread support and file I/O. boost and STL
provide most of that. ICU provides the unicode processing.
However, I have not investigated the needs for network connectivity and such as
On some consideration, I don't mind having just a bag rather than an
array, so I'll scratch that matter off the list. I can always add an
extra key if needed. But thanks for clearing that up. I didn't want
to just continue on with that assumption.
The only matter really is size, then. But I
On some consideration, I don't mind having just a bag rather than an
array, so I'll scratch that matter off the list. I can always add an
extra key if needed. But thanks for clearing that up. I didn't want
to just continue on with that assumption.
The only matter really is size, then. But I
On Apr 9, 4:30 pm, dmiche...@googlemail.com
dmiche...@googlemail.com wrote:
For instance, if I want to test my sql statement from the H2 GUI front-
end before doing via my JDBC java code.
I tried to pass the path , i.e. INSERT INTO mytable (id,name,file)
Hi,
Indeed I'm using that version, it's the one I downloaded when I wanted to
start the project, but it seems a bit outdated now that I'm actually
starting it.
I just tested with the 1.2.131 (since it has the label Latest Stable
unlike 1.2.132) and it works like a charm!
Thank you very much:
thanks
i start translating this two file.
On 4/7/10, Thomas Mueller thomas.tom.muel...@gmail.com wrote:
Hi,
The translation of this software is split into the following parts:
* H2 Console: src/main/org/h2/server/web/res/_text_*.prop
* Error messages:
20 matches
Mail list logo