|
NexusDB, best database I've ever used.
Embedded* (free) or as a server. I use both, depending on the the project.
*embedded in Delphi
|
|
|
|
|
|
Thanks Rick, didn't know of that list.
|
|
|
|
|
Can view/edit with Notepad, great read/write support built into C#, lightweight, fast, structured and robust. All the data that I need! ![Cool | :cool:](https://www.codeproject.com/script/Forums/Images/smiley_cool.gif)
|
|
|
|
|
Seriously, I'm writing automation software for a CAD/CAM system.
|
|
|
|
|
Us too... But we store the tools in a "freakin database" because that CAM thing stores it in a bunch of own structured text files that change with every damn version they release. We've built our own Tool Management Software, because the API doesn't change as often as that proprietary kind of "database" (as they call it), and inject the tools via that API.
Makes updating the customer's "database" a lot easier, just adjust the dlls to those with the new API - done! Same dlls for every updating client instead of lots of files for every single customer. Cost them several days of (our pretty expensive) work days previously. Now they buy our software once ![Wink | ;-)](https://www.codeproject.com/script/Forums/Images/smiley_wink.gif)
|
|
|
|
|
IndexedDB is the only Database I need.
|
|
|
|
|
I know it's actually a cache, but does Redis count? It's still an in memory 'database'.
|
|
|
|
|
|
Wow ... this one looks simple indeed, thanks for sharing.
I've been using C# binding for SQLite since ... 2008,
but I will give LiteDB a try ...
Cheers
|
|
|
|
|
nice db for some internal applications.
|
|
|
|
|
I have a contract with a large gov't agency, and DB2 is a big part of their legacy applications.
On a side note: my client is deemed an essential service, so my work continues uninterrupted - but able now to work from home (yay)
|
|
|
|
|
Let's table that question, for now.*
* US meaning of expression, FYI
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
It does not solve my Problem, but it answers my question
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Our software runs on either SQL Server or MS Access depending on customer environment and needs. I also didn't see sql compact, which I use on a couple of personal apps.
"Go forth into the source" - Neal Morse
|
|
|
|
|
SQL Server is our main db.
but word is that some of our new stuff will be using Mongo DB, which would be cool to learn and add to my skill sets.
|
|
|
|
|
Depends on the use case. I think most projects using NoSQL are only doing so because it's another buzzword.
In most cases a relational database is the one you want and forcing it into NoSQL just risks data integrity and makes everything slow.
|
|
|
|
|
ScottM1 wrote: Depends on the use case.
Of course it does.
|
|
|
|
|
My point was more that these NoSQL databases have been used in loads of places they shouldn't have.
Hopefully your project isn't one of those. I've not worked on a project with a valid use case for it though I would like to at some point.
|
|
|
|
|
|
If any, right now I'm working on embedded systems and that's common for them.
GCS d--(d+) s-/++ a C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
It's a database isn't it?
Wadayamean it isn't? Go check QA and see how many people are using it as one ...
(And so do I for a couple of trivial data storage purposes: How much breakfast cereal Herself ate*, Weight logs for the diet, ...)
* So I can estimate when it will run out, and make sure it doesn't. She gets "grumpy" when she's hungry.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Excel gets very powerful because of its VB.net interface. You can not only use Excel as database, but also connect it to some more powerful database.
I guess that you will need tons of data to get Excel slow on a powerful hardware.
Press F1 for help or google it.
Greetings from Germany
|
|
|
|
|
Excel is underrated. Once I had to find the distribution that best fit an average DB of measuremenents , about 10 thousand samples, no Matlab allowed (my former company was seriously allergic to paying for equipment, licenses and personnel).
Ok, let's get R: its own examples did not work, with syntax errors. It could not open an elephanting text file either.
Let's try a bunch of other software, in trial mode: either they were limited to 100 samples or could not open an elephanting text file. That function was missing anyway.
3 days wasted, then I resorted to Excel: 2 hours later I had a bunch of common distributions with various parameters plotted and the error curves. Found mine, was a Gaussian, job done.
GCS d--(d+) s-/++ a C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Excel is magnificent software, certainly the best spreadsheet around, and a good contender for "best software ever" - though it would lose to Visual Studio!
But ... it's not a DB, and shouldn't be used as such - as soon as you start treating each sheet as a separate table and trying to work foreign keys and relationships, and such like it starts to creak at the seams ... I'm happy with a couple of hundred rows being a "DB lite", or used as a DB for a mailing list, but I've seen people with thousands of rows or hundreds of columns linked to a dozen sheets. One guy I used to work for actually had is build lists, stock control, and personnel allocation as one huge sheet that took 1/2 hour to open. It was clever, yes. It was stupid as well!
People sometimes forget that just because you can do something, that doesn't mean you should.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|