Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Newcomers DBPro Corner / Database Tutorial

Author
Message
Somarl
13
Years of Service
User Offline
Joined: 11th Feb 2011
Location: UK
Posted: 23rd Mar 2012 14:38
Link
Hi, i am looking to make a simple database just so i can learn some different ways of storing and saving info and recalling it/editing it etc later. I was wondering if anyone had written something that i could follow. All i could find using search was a dead link.
Back to top
Profile PM
DAEvo
12
Years of Service
User Offline
Joined: 3rd Mar 2012
Location: Arizona Territory, USA
Posted: 23rd Mar 2012 16:35
Link
I've found SQLite very easy to work with, but, in all honesty, ARRAYS have worked wonders for me in terms of speed and flexibility. Without know what exactly you are doing or the amount of data you need to store, that is all I can off by way of suggestions.

BUT... there are some really good coders here what will come along and give you some very specific tips.

Also check this thread:

http://forum.thegamecreators.com/?m=forum_view&t=89100&b=19

Specifically the 20 September 2006 post from RiiDii. It may 'splain a few things.

Game Designer
Rig Specs: Intel i7 2600k 3400 Mhz, 16 GB RAM, GeForce GTX 560 Ti, 64-Bit OS, 27" ASUS (x3)
Back to top
Profile PM
Somarl
13
Years of Service
User Offline
Joined: 11th Feb 2011
Location: UK
Posted: 23rd Mar 2012 19:17
Link
Thanks for the reply. All i was after was a simple way of inputting simple information like numbers and text onto some form of gui, then it saving those records. Only to boost some things i should be practicing in DBpro.
For example:
A shopping database that asks for the name of an item of food (tomato)
Then asks the price it is in one shop(asda 99p), then the price it is in another (sainsburys £1.09) and if not known you fill in what you know and can update it later and save it out to a text file. Then perhaps the option to compare a list of the food items and where they are cheaper so like a query system that outputs to a text file. If i can do this i think it will help with other things i am trying to learn.

So to recap, a simple GUI, a method of storing and a query for sorting.

Thanks.
Back to top
Profile PM
Pincho Paxton
21
Years of Service
User Offline
Joined: 8th Dec 2002
Location:
Posted: 24th Mar 2012 00:18 Edited at: 24th Mar 2012 00:20
Link
I wouldn't start with a database in DbPro. If I was making a Database I would use Visual Basic. It is better to start with a simple game in DBPro, like a card game. But it's up to you. You are starting on a project that will not be very useful when making games however.

Back to top
Profile PM Email Website
MrValentine
AGK Backer
13
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 24th Mar 2012 00:24
Link
why not use DarkData?

Back to top
Profile PM
Penfold
20
Years of Service
User Offline
Joined: 3rd Dec 2003
Location: RED postbox houses of parliment
Posted: 24th Mar 2012 01:52
Link
to do this in the simple sense you need to learn 2 things.

how to store variables in a dimensional array.

and how to read and write data to your drive.

use the search tool and look for

dimensional array or DIMS and READ and WRITE to file. All three of these have example code inside DBPro. which should helpyou to understand them. then try and mege the two together.

I'm assuming you can already text to screen and now how to do input commands and IF statements and the like?

'Ooh 'eck chief'...'crumbs'
Back to top
Profile PM
DAEvo
12
Years of Service
User Offline
Joined: 3rd Mar 2012
Location: Arizona Territory, USA
Posted: 24th Mar 2012 15:14
Link
Quote: "why not use DarkData? "


Wha? Off to look at TGC products with CC in hand!

Game Designer
Rig Specs: Intel i7 2600k 3400 Mhz, 16 GB RAM, GeForce GTX 560 Ti, 64-Bit OS, 27" ASUS (x3)
Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2024-11-22 04:50:53
Your offset time is: 2024-11-22 04:50:53