Re: Issues with unique object IDs in persistence

"Arne Vajhøj" <arne@xxxxxxxxxx> wrote in message news:4a10ae04$0$90275$14726298@xxxxxxxxxxxxxxxxxx
Seamus MacRae wrote:
Lew wrote:
Seamus MacRae wrote:
A two-megabyte DBMS? That'll be the day.
That day is today. From the website:
Derby has a small footprint -- about 2 megabytes for the base engine and embedded JDBC driver.

Didn't your mother tell you not to believe everything you read on the web? :)

You can easily download Derby and verify yourself.

Now that I think about it. If the uses is uptodate with Java, then
the effective footprint by Derby is 0. Because Derby comes with the
JDK.

Well, not in so many words, but it's an implication that follows naturally from the predictable sequence of events:

1. Programmer uses Derby.
2. Program winds up containing a bug.
3. At a customer deployment, program triggers bug.
4. Database gets b0rked.
5. Customer finds program stopped working properly.
6. Customer finds quitting and restarting it doesn't fix it.
7. Customer calls support...

I'm not sure which of the above you'd argue is implausible. 1 is your own advice. 2 is pretty much inevitable, like it or not, as is 3 given that 2 occurred. 4 is dependent on the nature of the bug, but it doesn't seem implausible. 5 follows from 2. 6 follows from 5, 4, and the database being nonvolatile. 7 is inevitable given 5 and 6.

Nonsense.

An embedded database can run fine without problems.

Probably the most widely used example is FireFox and
Thunderbird which uses and embedded SQLITE database.

A double digit number of millions of users. And it
just seems to work.

There's no separate installation. There's no separate partition.

Apparently there's no actual database in this DBMS, then. How interesting.

Apparently there is.

The entire category of embedded databases are characterized by
the fact that there are no installation.

And raw partitions are largely the way of the 1980's.

they keep backups. If anything goes wrong, there's no apparent way for anyone short of an expert to get into there and make changes. The typical user that even learns of the partition might try reformatting it, probably with catastrophic consequences (even if they don't reformat the wrong partition by mistake).

What are you on about?

The risks and headaches involved in repartitioning a hard disk. Haven't you been paying attention?

I think you have not been paying attention.

Partitioning not needed.

I just thought I'd add that we have been using Derby in a production system for about 3 years and have not had one problem with it. It performs surprisingly well and the end user doesn't even know it exists. It has required zero administration.

--
Regards,

Jarrick

------------------------------------
Jarrick.Chagma@xxxxxxxxxxxxxxxxxxx
(Lose your mind before emailing me)

.

Relevant Pages

  • Re: Issues with unique object IDs in persistence
    ... program triggers bug. ... Database gets b0rked. ... Customer finds program stopped working properly. ... The typical user that even learns of the partition might try reformatting it, probably with catastrophic consequences. ...
    (comp.lang.java.programmer)
  • Re: Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... > UDQ Services has years of experience with MS Excel and VBA (Visual Basic ... > templates, spreadsheet applications, and database applications. ... > P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)
  • Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.programming)
  • Spreadsheet/VBA Consulting - 50% Off or Even Free
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.misc)
  • Spreadsheet/VBA Consulting - 50% Off or Even Free
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.newusers)