Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

Database

Eadoin Welles
Registered User
Join date: 5 Jan 2007
Posts: 149
05-19-2007 17:24
Using the notecards in object inventory as a way to parametrize a script is quite cumbersome. It would be useful to define a database object taht could be queried by

string result = llQueryDB(string dbname, string criteria)

where dbname is the DB object in the same inventory of script
Leroy Bigwig
Registered User
Join date: 9 Dec 2005
Posts: 97
05-19-2007 23:55
o.O before anyone who knows what your talking about, and can do something about it, enough attention from laymen needs to be brought upon a subject. Speak english man. WTF did you just say?
ed44 Gupte
Explorer (Retired)
Join date: 7 Oct 2005
Posts: 638
05-20-2007 03:51
Windows programs can put parameters in files or in the windows registry for recall or manipulation. No equivalent system exists in lsl.

The OP is suggesting LL operate a db to store similar values in sl for objects.

Considering LL's priorities, it will be a long time before this feature is implemented. Meanwhild, you cn use http and a web server to maintain long term storage.
Haravikk Mistral
Registered User
Join date: 8 Oct 2005
Posts: 2,482
05-20-2007 05:19
The trouble with actual database implementations is that languages such as SQL are VERY text heavy, queries and large-ish results will require rather large strings, not to mention the parsing of a multi-row/column result! The issue as a result is that the usage of such a system is very limited. An in-house language would be required for fetching single values to keep memory usage down, remember we only have 16k.

Possibilities like this exist however, as you can create a 'database' script and query this with link-messages. This would be perfectly good if all you want to store are simple variables, e.g; objectName = "My Object"
_____________________
Computer (Mac Pro):
2 x Quad Core 3.2ghz Xeon
10gb DDR2 800mhz FB-DIMMS
4 x 750gb, 32mb cache hard-drives (RAID-0/striped)
NVidia GeForce 8800GT (512mb)
Greblak Whitfield
script g33k
Join date: 25 Apr 2007
Posts: 15
05-20-2007 12:49
There are easier ways to do this. Requires a bit of scripting and some ASP, Perl or PHP knowledge. Ofcourse this will be quite a bit of data...

You create a DB script on a webserver. Listening function and outputting function.
use llHTTPRequest(); to send your query.
for example:
llHTTPRequest('http://example.com/?query=SELECT * FROM....'); The whitespaces may be filled with %20 automatically (not sure) If they're not, fill them in yourself. %20 is 'web' for space.

The website queries the database, and outputs in a list format you create. Perhaps a csv style (comma separated values).
use http_response listener to process this. Interpret the input and BOOM! You got your functional database.
This is just a VERY basic framework and can easily be expanded.