Programming Help

Web Development



What's Here?

  • Members: 109,156
  • Replies: 413,517
  • Topics: 62,855
  • Snippets: 2,285
  • Tutorials: 605
  • Total Online: 1,097
  • Members: 40
  • Guests: 1,057

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 109,156 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,097 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



database confusion...

 
 Reply to this topicStart new topic

database confusion..., What database will I use on my stand-alone game?
database
What will I choose?
MySql [ 2 ] ** [66.67%]
MS Access [ 0 ] ** [0.00%]
Others (pls specify in your posts) [ 1 ] ** [33.33%]
Total Votes: 3
Guests cannot vote 
ryngonz
post 3 Jul, 2008 - 08:22 PM
Post #1


New D.I.C Head

*
Joined: 15 Jun, 2008
Posts: 13


My Contributions
What database will I use on my stand-alone game? Others say MS Access and others MySql. I will be building my game in flash. So what will be the appropriate one to use that I can apply a searching algorithm so that it will be fast to retrieve data. The database will be used for my dictionary system and for saving your current game. The game is just like a bookworm deluxe type but it is a whole new different rules but it has to do with writing up words and has a storyline.

Please help. blink.gif
User is offlineProfile CardPM

Go to the top of the page


rockstar_
post 3 Jul, 2008 - 10:03 PM
Post #2


D.I.C Head

Group Icon
Joined: 16 Oct, 2006
Posts: 187



Dream Kudos: 275
My Contributions
QUOTE(ryngonz @ 3 Jul, 2008 - 08:22 PM) *

What database will I use on my stand-alone game? Others say MS Access and others MySql. I will be building my game in flash. So what will be the appropriate one to use that I can apply a searching algorithm so that it will be fast to retrieve data. The database will be used for my dictionary system and for saving your current game. The game is just like a bookworm deluxe type but it is a whole new different rules but it has to do with writing up words and has a storyline.

I think your best bet will be something lightweight, like sqlite. MySQL is a bit heavyweight, and I SEVERELY doubt that MS Access should have ever been considered a database. I'm pretty sure there are Flex bindings to SQLite
User is offlineProfile CardPM

Go to the top of the page

aco99
post 4 Jul, 2008 - 11:17 PM
Post #3


New D.I.C Head

*
Joined: 5 Mar, 2008
Posts: 7
^ Agree...

SQLlite is the BEST POLICY! when it comes to games that need databases...
User is offlineProfile CardPM

Go to the top of the page

ryngonz
post 6 Jul, 2008 - 07:39 PM
Post #4


New D.I.C Head

*
Joined: 15 Jun, 2008
Posts: 13


My Contributions
hmmm. Ill try SQLlite. but is the database of SQL and SQLlite are alike or there are added codes?
User is offlineProfile CardPM

Go to the top of the page

dineeshd
post 8 Jul, 2008 - 06:16 AM
Post #5


D.I.C Regular

Group Icon
Joined: 30 Jun, 2008
Posts: 403



Thanked 11 times

Dream Kudos: 575
My Contributions
Instead of dragging the "Resource eating and Slow Processing" databases into scene, why can't you use .ini files to store the info. I agree that we are not supposed to use .ini files for storing heavy data, anyway games are not going to have that much data to store. So why can't you thing about it....
User is offlineProfile CardPM

Go to the top of the page

ryngonz
post 8 Jul, 2008 - 07:29 PM
Post #6


New D.I.C Head

*
Joined: 15 Jun, 2008
Posts: 13


My Contributions
hmm. yeah i believe that ini files can save me memory but can I add searching algorithms to that file so that it will not burn me time on searching?
User is offlineProfile CardPM

Go to the top of the page

dineeshd
post 9 Jul, 2008 - 02:35 AM
Post #7


D.I.C Regular

Group Icon
Joined: 30 Jun, 2008
Posts: 403



Thanked 11 times

Dream Kudos: 575
My Contributions
Definitely you can store your searching algorithms in ini files. How fast you can access the data, its all depends up on the data structure you maintain in ini files. Try to keep it simple and neat.
User is offlineProfile CardPM

Go to the top of the page

ryngonz
post 9 Jul, 2008 - 04:55 AM
Post #8


New D.I.C Head

*
Joined: 15 Jun, 2008
Posts: 13


My Contributions
Im planning to apply a quicksort algorithm and so that it will be fast for the application to search in the dictionary. What will you prefer, have a separate ini file for different letter category or just dump it into one file? BTW, what programming language will the ini file can understand? I believe XML can... am I right?

I'm getting there. I hope you get hold of me. smile.gif
User is offlineProfile CardPM

Go to the top of the page

dineeshd
post 9 Jul, 2008 - 06:24 AM
Post #9


D.I.C Regular

Group Icon
Joined: 30 Jun, 2008
Posts: 403



Thanked 11 times

Dream Kudos: 575
My Contributions
I don't have much idea about game programming and that "quicksort algorithm". But I strongly believe that you can use ini files to store your algorithm, why I am telling this so confidently that I have seen that even some of the games of "Electronic Arts" used ini files to store data, like user profiles, system configurations....

As far as I know most of the programming languages will have a method to mange the ini files. Personally I have used ini files in VB.Net and VB6. It’s pretty easy to handle.

Just check the below link to get some idea about handling ini files using VB.Net. With that you may be able to rewrite the method in your language.

http://www.dreamincode.net/forums/showtopic56479.htm
User is offlineProfile CardPM

Go to the top of the page

ryngonz
post 9 Jul, 2008 - 07:18 PM
Post #10


New D.I.C Head

*
Joined: 15 Jun, 2008
Posts: 13


My Contributions
Tnx for the advice mate. Ill try experimenting ini files for now. If it turns out successful in saving profiles and handling my dictionary module. tnx again

Cheers

Ryan
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 9/5/08 05:13PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month