Database
by J Sears · in General Discussion · 12/15/2007 (1:54 pm) · 16 replies
Didn't know where else to put this but I was wondering if anyone knew of a free or very cheap program out there that works as a database with a simple user interface. One that doesn't require a seperate database server just runs all on it's own in one small program.
Would be great if you could modify the tables and searchs easily as well. Thanks
Would be great if you could modify the tables and searchs easily as well. Thanks
#2
Basically I don't need anything fancy at all it could just be a windows program that you enter information it saves it in any kind of file it wants and then you could search it and have it give you a list back that shows all the matches. Doesn't even need to be an actual database if it just wants to use a text file. Not looking for any networking at all with this program
12/15/2007 (2:24 pm)
That's not what I'm looking for.Basically I don't need anything fancy at all it could just be a windows program that you enter information it saves it in any kind of file it wants and then you could search it and have it give you a list back that shows all the matches. Doesn't even need to be an actual database if it just wants to use a text file. Not looking for any networking at all with this program
#3
12/15/2007 (2:27 pm)
Well it sounds like your talking about a folder... It will do what you say, and try a writeFile() function for writing data.
#4
You have a file that stores that there's 10 of those ITEMS and a decription.
Now let's say 2 different people take an ITEM I want that original file to know 2 were taken and a new file contain who has the ITEM and the date they got it.
Now let's say a person makes 10 ITEMS I want the original file to update that there's now 18 ITEMS and the second file to say that 10 ITEMS made by who.
Hopefully that makes sense, then you can say who has one of these ITEMS and it shows a list of those people how many date they got it etc.
If you just search for ITEM it will show how many there are left, then a list of who has one date they got it ETC.
I am looking for a stand alone program that you can manually enter this information and then search it with just a simple no need to be fancy Windows interface. I'm hoping to find something close to that before I try to learn how to make a program that does it all on my own since that will take a while.
12/15/2007 (2:29 pm)
Maybe to make it clearer here's a basic example let's say you have any given item so let's call it ITEM.You have a file that stores that there's 10 of those ITEMS and a decription.
Now let's say 2 different people take an ITEM I want that original file to know 2 were taken and a new file contain who has the ITEM and the date they got it.
Now let's say a person makes 10 ITEMS I want the original file to update that there's now 18 ITEMS and the second file to say that 10 ITEMS made by who.
Hopefully that makes sense, then you can say who has one of these ITEMS and it shows a list of those people how many date they got it etc.
If you just search for ITEM it will show how many there are left, then a list of who has one date they got it ETC.
I am looking for a stand alone program that you can manually enter this information and then search it with just a simple no need to be fancy Windows interface. I'm hoping to find something close to that before I try to learn how to make a program that does it all on my own since that will take a while.
#5
You say that if a person makes 10 of some item, you want it to update. How do you wish to update it? It sounds like you want to do this manually, which is really tedious.
12/15/2007 (2:34 pm)
How would the file be updated?You say that if a person makes 10 of some item, you want it to update. How do you wish to update it? It sounds like you want to do this manually, which is really tedious.
#6
12/15/2007 (2:38 pm)
Well it seems you could try the writeFile() function, and it would do that.
#7
Yes for now I want it to all be manual just type in the fields and click save
12/15/2007 (2:59 pm)
I'm not using the TNL for this so please let that go, that's a ridiculous thought.Yes for now I want it to all be manual just type in the fields and click save
#9
12/15/2007 (3:53 pm)
Tyler please, I want a simple small, tiny even, stand alone program for this
#10
12/15/2007 (4:33 pm)
Well then try making a "simple" macro, you would need a bigger program to make it, but then you only need to double click on it.
#11
If you are wanting something smaller and less powerful than that, it would take a decent programmer about 1 week to code it up for you in C++ or C#. More time would be allotted for testing, revisions, and debugging of course.
12/15/2007 (4:34 pm)
In my honest opinion, I think going with something like MySQL would be a lot quicker and easier. That's what my team is going to be using for our games and projects. It does exactly what you want, and is accessible from the web, a local computer, a 3rd party client, and even C++/C#If you are wanting something smaller and less powerful than that, it would take a decent programmer about 1 week to code it up for you in C++ or C#. More time would be allotted for testing, revisions, and debugging of course.
#12
I'll keep searching
12/15/2007 (5:43 pm)
That's why I was hoping someone out there already made something like that to keep from having to make it.I'll keep searching
#13
It's a very small package, has full SQL query support, stores as a file without the need of a dedicated server. You'll need to check the license but it should be ok to distribute with your game. It's compatible with C, C++, Win, Mac, Linux.
12/18/2007 (11:26 am)
Try SQLite.It's a very small package, has full SQL query support, stores as a file without the need of a dedicated server. You'll need to check the license but it should be ok to distribute with your game. It's compatible with C, C++, Win, Mac, Linux.
#14
If you need a GUI, just search sqliteadmin in google.
12/20/2007 (8:05 am)
I'm agree with Nikos, SQLite rules!, and the license is permissive enough so you can redistribute without problems. If you need some examples just ask for it and I will send it to you.If you need a GUI, just search sqliteadmin in google.
#15
You can take a look at my Event Driven Database resource on this site and it would be easy enough to port to SQLite.
12/20/2007 (10:21 am)
A friend of mine wrote a great book on SQLite as well. Check it out... it's easy to read and easy to integrate with Torque.You can take a look at my Event Driven Database resource on this site and it would be easy enough to port to SQLite.
#16
12/21/2007 (4:50 pm)
Thanks I will look into that, I had started using MS Access and man that program sucks
Torque Owner Tyler Slabinski
It's pretty cheap considering the others out there. You can also just have a normal server and put the server folder in your game there.