|
First thing: don’t use Access for anything more than prototyping and local, personal projects.
Second, if you do use Access, check their licensing terms.
Lastly, if you expect to have multiple users using one central database, don’t use Access.
Don’t misundertake me: Access is a great tool for what it is, but it’s definitely not suited for some things.
Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall
Mark
Just another cog in the wheel
|
|
|
|
|
Have you considered rolling your own? It really depends on what your project needs are. If you are just storing information and not linking (making relational), then simple serialize/deserialize of JSON files can work very easily and would not have any outside dependencies.
If you are needing relational, LocalDB (SQLExpress) would be a solid choice but does come with a size limit. I think its 10GB now. Used to be 4.
I would not use Access.
|
|
|
|
|
Yep, I considered lighter file formats for storage such as XML and JSON. What I've read so far suggests that appending specific data chunks to these files become heavier as the data increases. And considering that this method needs pulling of entire file to memory, it might get slower over time as the DB size approaches several hundred MBs or even a GB? In contrast, Sqlite driver just performs CRUD operations on the file, so performance might be better?
|
|
|
|
|
There are only two options currently for an embedded, desktop database engine... SQLite, which is the easiest to use with a .NET provider, which is now fully supported by the SQLite Development Group.
To manage your SQLite database, get a copy of the free database manager tool for SQLite, "DB Browser". It has everything you need to create and manage your databases.
The Firebird Database Engine is your second option, using the embedded mode for the database engine setup.
Unlike SQLite, Firebird Embedded provides everything that a standard RDBMS would offer such as stored-procedures.
The best database manager for Firebird is IBExpert's Personal Edition, which is freely available. The interface is not as intuitive as "DB Browser" but it provides all of the necessary tools to manage your Firebird databases.
Firebird is also a tough database engine to work with as the documentation is not nearly as well defined as for other engines. Nonetheless, it is a very powerful engine and if you want to move your application into a multi-user environment, then you can simply use Firebird Server with literally no change in your desktop database structures.
Steve Naidamast
Sr. Software Engineer
Black Falcon Software, Inc.
blackfalconsoftware@outlook.com
|
|
|
|
|
Consider whether MongoDB is a better choice for a more document centric solution.
|
|
|
|
|
|
SQLite, next question.
|
|
|
|
|
if you are looking for portability without having to install software on the host machine and do not need to share the DB with another process, go with SQLite. it works fantastic, most languages have support baked in, and you can still pass structured queries. last I read I think there is a 4TB limit.
if the *.mdb gives you something more that SQLite doesn't have, choose that. to be honest I haven't touched an Access db from code in a couple decades, so I'm not all sure what it offers currently.
if you are not worried about portability use SQL express, or a no-SQL DB for document storage. both are good, it all depends on what you plan to do with the data.
|
|
|
|
|
Porter rejected my name tag. (7)
|
|
|
|
|
GATEMAN?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yep, you solved it Paul.
Porter rejected my name tag. (7)
Porter = definition
rejected my = reversal indicator
name tag = gat eman (reversed)
Gateman
Porter
|
|
|
|
|
Not Guinness then
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
THIS time I did not "reject" my Latin roots schooling and I solved your clue!
A fun clue BTW. (And I'm not just saying that because I solved it.)
|
|
|
|
|
After three years, when we broke up, she returned exactly $100.
I lost interest in that relationship.
Now I'm just left a loan.
|
|
|
|
|
You didn't establish a bond, that's why.
GCS/GE 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
|
|
|
|
|
At least you still have your principal.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Principles are ( as you now know ) expensive
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Participles are cheap, but they are a thing of the past.
GCS/GE 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
|
|
|
|
|
I'll give you the credit for that one.
|
|
|
|
|
She was a cheapskate; you should have taken that into account.
|
|
|
|
|
Was she a cheap lesson?
PartsBin an Electronics Part Organizer is finally available for download.
JaxCoder.com
|
|
|
|
|
Sander Rossel wrote: when we broke up, You won a lot in extrinsic value
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Like a deposit on an apartment. At least she was honest.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
wow..
a bunch of people cashing in on a poor dudes life.
It makes cents if you think about it with how society is today....
I could wax liracal about this but I dont want to pound the issue in to the ground.
I'll be franc here, mark my words... there will be an accounting...
Cegarman
document code? If it's not intuitive, you're in the wrong field
|
|
|
|
|
So 40 years of cooking, and I discover this (maybe other people have too) - slice the onion on a plate in the sink with a gently running stream of water streaming over the onion. Prevents all that stray spray of slicing / dicing / chopping. The stream of water, not the plate.
|
|
|
|