Which tools I need for my program
I'm going to make a patients database program for an eye clinic. I'm going to use Visual Studio to make the interface. What database should I use if I don't need a connection? Just a local one where I should be able to see the database file so I can copy it for backup. Thanks.
Hm for databases in general which store bigger amounts of Data, SQL or MySQL is always a good answer. I wouldn't store the data in a single file for safety reason etc. MySQL will enable you to copy and backup the data quickly and organize your data efficiently.
Greetz
Xaser
Greetz
Xaser
Hm for databases in general which store bigger amounts of Data, SQL or MySQL is always a good answer. I wouldn't store the data in a single file for safety reason etc. MySQL will enable you to copy and backup the data quickly and organize your data efficiently.
Greetz
Xaser
I just want to make it real simple. It's just for a friend.
Try SQLite, it's really minimalistic and a good abstraction from larger, conventional databases. It also relieves you of running a separate database server on your local machine, as the database is already integrated in SQLite.
Try SQLite, it's really minimalistic and a good abstraction from larger, conventional databases. It also relieves you of running a separate database server on your local machine, as the database is already integrated in SQLite.
Ok so how does this work? I make the program with Visual Studio then use SQLite for the database? Like making the table in command prompt? Or can I make the table in Visual Studio? I dunno how SQL works. I mean connecting to the server and stuff. How about MS Access?
Well SQL has its own "Language" so to speak. I Don't know SQLite very well, but it seems appropriate for your problem. If it works the same way as MySQL you can get for example data from the table via a library you need to include and then call commands to the database like:
which will then return you data
Have a short look at the SQLITE Documentation to see whether you can use it or not. You will find that SQLite is basically like normal SQL but doesn't need an SQL server and just uses a File as Database.
Xaser
SQL QUERY: SELECT * FROM 'PATIENTS' WHERE NAME = 'George Walmer';
which will then return you data
Have a short look at the SQLITE Documentation to see whether you can use it or not. You will find that SQLite is basically like normal SQL but doesn't need an SQL server and just uses a File as Database.
Xaser
Do you even need a SQL database? A BinaryFormatter and a serializable data structure would be much easier unless you're planning on making large changes to your data structures all the time.
Are there going to be millions of patients? Will there be multiple people accessing the data at the same time?
Are there going to be millions of patients? Will there be multiple people accessing the data at the same time?
Don't use a database, even Sqlite.
Seriously, it's massive overkill. Just store a list of records in structures in memory, and serialize them to disk as needed.
Seriously, it's massive overkill. Just store a list of records in structures in memory, and serialize them to disk as needed.
Don't use a database, even Sqlite.
Seriously, it's massive overkill. Just store a list of records in structures in memory, and serialize them to disk as needed.
In this situation you are probably right. His Problem doesn't seem to have any chances to be used as a real product. However if it was an SQL database would be better as it could be extended more easily to Server Application, easier access, faster access etc. etc. So it depends on the extend of the program.
Xaser
This topic is closed to new replies.
Advertisement
Popular Topics
Advertisement