|
- The OP described a reasonably complex database, that requires maintenance and enforcement of relationships. This is just the kind of use case at which relational databases excel.
- Speed, while important, is not the primary criterion for a database engine. Data and relationship integrity is.
- When choosing between a mature database engine that is used in billions of devices and a relatively unknown engine, the mature product will usually win. Very few people can afford to bet their product (or their reputation) on unknown quantities.
This does not mean that I would never try unknown products. It does mean that I will use them only in non-critical (i.e. non-production) environments until I am sure that (a) they can do what they claim to do and (b) are better in some significant way than the mature product.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
That are some good points, SQLite is of course on the market for quite a long time and LiteDB undoubtedly still has some bugs as it is a relatively young product.
So we will see what CodeWraith thinks of it (if he decides to use it).
Exciting times! 
|
|
|
|
|
I will try both of them. At the moment I can't yet sayhow much of a database I'm going to need. While I will have a few tables, I doubt that many of them will contain more than 1000 rows. Enforcing referential integrity is important, because I have come to rely on it as a safeguard against sloppy application logic. And my queries? They will not be very complex, as far as I can say at this early stage. Let's just wait and see where this leads to.
Anyway, thanks for both suggestions.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
|
I would prefer this one[^], but that would be a sinfully expensive toy[^].
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
I've used sql ce for a couple of personal apps...works fine, but has limitations. (no views and windows only being big ones) If it's windoze only, there's always ms access. (the older free version)
"Go forth into the source" - Neal Morse
|
|
|
|
|
Thanks, but that does not help very much. I think that both will not work very well in a DirectX graphics context.  I have a homemade UI that needs some more development and I need something that provides the model part of the MVP pattern it is built around.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
Marc wrote, in the "It's weird when" post (here) he thought his brain might need an "augment."Quote: On Wednesday, scientists reported a driver of aging that, in contrast, even the lead researcher diplomatically calls “counterintuitive”: neuronal activity. Aging, of course, affects the brain. But the brain seems to affect aging, too, they found: In creatures from worms to mice to people, high levels of neuronal firing spell a shorter life span. Lower levels — naturally, or due to drugs that dampen neurons’ activity — increase longevity.
The discovery was so surprising that it’s taken two years to be published (in Nature) because of how much additional data the outside scientists reviewing the study requested. Geneticist Bruce Yankner of Harvard Medical School, who led the research, understood their skepticism. “If you say you have a cat in your backyard, people believe you,” he said. “If you say you have a zebra, they want more evidence.”
[^]
That was just the reminder I needed to post this provocative study which, given that so many of you are roundworms, I think is relevant.
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
in that case I don't want to think about this!
Message Signature
(Click to edit ->)
|
|
|
|
|
I don't know why this is so surprising given the correlation between metabolic rate and longevity.
|
|
|
|
|
for human beings:
1 Basal metabolic rate (BMR) declines, naturally, with age
2 BMR does not correlate with longevity: that assumption, scientifically "popular" since 1908, has been refuted by modern research
3 the topic here is neuronal activity, not metabolic rate
Your science needs topping up
cheers, Bill
«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali
|
|
|
|
|
Judging by the code I've had to work with, many programmers will live to be in the 100's... 
Management is immor(t)al, no neuronal activity was found in their brains.
|
|
|
|
|
Sander Rossel wrote: Management is immor(t)al, no neuronal activity was found in their brains.
Thank god they are not!
Wannabe manager stumbles in my penthouse office: "What is your status?"
Me, annoyed: "Still not married. Have you come to propose?"
Idiot: "No, are you still working on your project? I want you too <generic stream="" of="" nonsense="">. And put that into your database!"
Me, even more annoyed now: "No. There is no time for that if we want to make our deadline."
Idiot blinks, reboots for a few seconds and repeats the sream of generic nonsense.
Me: "I understood you the firat time. The problem is that the database will not even take this because of the constraints, not to speak of the changes I would need to make to the application."
Idiot:"Can't we just use another database with less constraints?"
Me, slowly getting devious: "Great! Why don't you take this to the boss? That would really solve a lot of problems. And don't forget to mention that I will need one or two more months to make your changes."
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
"The other database is not SQL, meaning it's only consistent eventually."
That'll scare him off 
|
|
|
|
|
I'm not sure 'idiot' knows what 'consistent' or 'eventually' means - those words are far to long...
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
Other DB bad. No SQL. Not consistent. No more money.
|
|
|
|
|
|
Turn left when you get to Ukraine, and follow the mud weevils.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
FTFYOriginalGriff wrote: Turn left when you get to UkraineTaiwan, and follow the mud weevils lies to their source.
shame about the soapbox.(EOM)
Message Signature
(Click to edit ->)
|
|
|
|
|
The Mud Weevil is the Elbonian National Animal.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I thought that was the Noplee.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
In Scott Adams' mind.
Elbonia seems to represent different things at different times, or not represent anything in particular.
|
|
|
|
|
When you reach wristonia your real close.
They call me different but the truth is they're all the same!
JaxCoder.com
|
|
|
|
|
Soooo... nowhere near Astoria?
|
|
|
|
|
Not even within the radius.
They call me different but the truth is they're all the same!
JaxCoder.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
