Renegade Public Forums
C&C: Renegade --> Dying since 2003™, resurrected in 2024!
Home » Tiberian Technologies / Blackhand Studios » Other Products » The brenbot SQLITE database is poorly constrcucted.
The brenbot SQLITE database is poorly constrcucted. [message #69395] Sun, 29 February 2004 01:27 Go to next message
Alkaline is currently offline  Alkaline
Messages: 1132
Registered: November 2003
Karma: 0
General (1 Star)
Deleted
If your using a relation databse, at the very least use some Relations with the tables rather than having them just being there independantly...

Right now there are just tables holding data, running a delete query in the database is pain. E.g. iff you have to delete all info for a single person, you have to go in and manually delete each record from each table id from each table...

Although it takes less cpu power, running queries is a pain, espically edit queries...


The brenbot SQLITE database is poorly constrcucted. [message #69396] Sun, 29 February 2004 01:32 Go to previous messageGo to next message
mac is currently offline  mac
Messages: 1018
Registered: February 2003
Karma: 0
General (1 Star)
Administrator/General
Quote:


FOREIGN KEY constraints
FOREIGN KEY constraints are parsed but are not enforced.


http://www.sqlite.org/omitted.html

I guess you know it better.

Have fun doing relations on a database that doesn't actually support it.


Quote:


danpaul88: buggy bugs brenbot because buggy befriends brainlessness

The brenbot SQLITE database is poorly constrcucted. [message #69467] Sun, 29 February 2004 09:38 Go to previous messageGo to next message
Alkaline is currently offline  Alkaline
Messages: 1132
Registered: November 2003
Karma: 0
General (1 Star)
Deleted
puft,
Well then I don't understand how you can call it a relational database system then :rolleyes: I had to use coding for to create a ghetto relational database structure for it :/

Anyway, I have almost completed a web administration for brenbot if anyone needs it.

Features:

-Reset N00b list
-Reset Recommendationl ist
-Display comments made by players on website (e.g. the noobs/bans/kicks)
- Essentially Edit anything with in brenbot.dat on the web.

However, seing as no one has "ANY USE" for a such an app, I won't be releasing it, however, you can pm for it and I'll give it to you.

I'm also working on a win32 gui for brenbot...


The brenbot SQLITE database is poorly constrcucted. [message #70261] Sat, 06 March 2004 07:59 Go to previous message
cmdr1337 is currently offline  cmdr1337
Messages: 39
Registered: May 2003
Location: Canada
Karma: 0
Recruit
It would be nice if I could figure out how to even view the banlog Surprised
no good with sqlite.exe
Previous Topic: !ladder/Rank
Next Topic: !setnextmap / !maplist || Strange problem
Goto Forum:
  


Current Time: Wed May 08 19:04:58 MST 2024

Total time taken to generate the page: 0.00646 seconds