Jump to content
  • Advertisement
Sign in to follow this  
Levistus

Which tools I need for my program

This topic is 2683 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

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.

Share this post


Link to post
Share on other sites
Advertisement
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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
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:

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

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!