Jump to content
  • Advertisement
Sign in to follow this  
silvermace

DIY Database?

This topic is 5395 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

What's Entailed in writing my own Database software? Hi all, just basically curious as to what would be involved in writing a usable database solution. probably not a heavy lifting system like oracle or mssql, but something light. also, when you buy "Oracle" what exactly is it you get? the DB server, driver and what kind of tools?

Share this post


Link to post
Share on other sites
Advertisement
Given that you're asking about buying existing products as well as asking about creating your own I assume you're choosing between those options?

You could make your own front end to ODBC.
Or are you interested in making your own low-level db implementation? In that case you have to worry about... Encryption, Authorisation, B-Trees, Disk and memory allocation, defragmentation, API, etc etc...

Go for the pre-made I think.

Share this post


Link to post
Share on other sites
yea, thats what i was affraid of lol!

i just kinda want to make a lightweight database as a kind of proof of concept.

but cheers for the reply.
-Danu

Share this post


Link to post
Share on other sites
You need the storage engine, which handles storing of the data.. You also need a query engine which interacts with the storage engine to return data - typically you'd have an API to interact directly with the query engine or an SQL compilant interface to it, allowing the user to throw SQL queries at it and get them back. Naturally you'd need some form of driver to allow software to connect to it and interact with your database. I'm not even going to touch on the more detailed aspects of security, recovery, ACID and all that stuff we take for granted.

You'll need to start researching RDBMS theory (link), perhaps downloading SQLite is one of the first steps you should take as you get to see full source to a small database system.

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.

GameDev.net is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!