Jump to content
Sign in to follow this  
Bluestorm

Database element

Recommended Posts

So I was wondering.

 

We will be able to script in LUA, which is pretty cool.

But what if we were able to have databases as well to store and fetch data?

 

Think about the world of programming it would open : statistics, history, logging, stock situation of a warehouse, forecast... basically all information-based services!

 

It could be done with a database element that would whether :

- Connect to a reserved database on NQ servers, one on each account to which you could assign rights (to allow organizations to use it)

- Connect to an external database on the user's PC or on online.

 

Thoughts?

 

Share this post


Link to post
Share on other sites

So I was wondering.

 

We will be able to script in LUA, which is pretty cool.

But what if we were able to have databases as well to store and fetch data?

 

Think about the world of programming it would open : statistics, history, logging, stock situation of a warehouse, forecast... basically all information-based services!

 

It could be done with a database element that would whether :

- Connect to a reserved database on NQ servers, one on each account to which you could assign rights (to allow organizations to use it)

- Connect to an external database on the user's PC or on online.

 

Thoughts?

I think the LuaSocket library does db connections.  And if we're going to manage our own economies, how else would we build exchanges?  A script would lose any information it was storing in arrays when the host computer goes offline.  But yeah, say you have a mech and you've mapped the control keys the way you want; if you don't have a way of persistently storing your preferences, you'd have to remap the controls every time (or maybe you'd have to modify a code file directly which you probably can't do while the script is executing.)  Even if it's just flatfiles, there has to be some way of storing data.

Share this post


Link to post
Share on other sites

really wish NQ takes good examples of LSL for LUA

 

Can you provide a link or explain more in detail your answer please? I couldn't find any reference of LSL for LUA.

Share this post


Link to post
Share on other sites

Can you provide a link or explain more in detail your answer please? I couldn't find any reference of LSL for LUA.

sorry, was a reference but didnt wanted to bring up the name of Second Life.

LSL is the name of the scripting language they use. and it is based on C.

 

so if you dont know, Second Life is a %100 ftp virtual world, released in 2003, and is entirely %100 built ingame by players.

it has a very powerfull building tool based on prims, and a very complete scripting system.

 

Second Life has implemented a lot of functions to call for external databases, for reading websites adresses, displaying online videos...

 

scripting possibilities are absolutly endless. at a point that you could design and build a gameboy and run a self scripted mario.

 

but the freedom of Second Life has a price, and attracted tons of trolls and griefers, what NQ wanna avoid and this from begining

 

check LSL wiki for a list of functions they have ingame. see if there is one your topic idea is refering to.

http://wiki.secondlife.com/wiki/Category:LSL_Functions

Share this post


Link to post
Share on other sites

So this would be like an ingame internet type of thing?

 

If possible that would be very cool.

one other thing is that NQ wanna control 100% of DU s content. and wanna completly split it from real life.

 

functions that will call for external databases might be used against NQ will

Share this post


Link to post
Share on other sites

Still, adding in a way to create/access external databases and services would be a great supplement to the ingame economy. Players could then create things like zkillboard or eve-central.com, services which pull data from the game to help everyone function more efficiently.

Share this post


Link to post
Share on other sites

Still, adding in a way to create/access external databases and services would be a great supplement to the ingame economy. Players could then create things like zkillboard or eve-central.com, services which pull data from the game to help everyone function more efficiently.

 

Well... I wouldn't expect it to be in the _initial_ release, but say you have an in game DB object. The players/organizations that want access to more than a pittance of storage space, could pay a bit extra every month to cover the storage cost of the object.

 

NQ would have a lua script library for access to these DB objects. They'd let you store data using an "SQL" like type connector... so you point your script at the connector object, and authenticate... then you can access what data is held in that object. Remote access would be feasible with this, but... I wouldn't want to be the one designing the security safeguards for doing the remote access.

 

But in game, this would give you an object you could share data across multiple other objects with.

 

-M

Share this post


Link to post
Share on other sites

one other thing is that NQ wanna control 100% of DU s content. and wanna completly split it from real life.

 

functions that will call for external databases might be used against NQ wil

Since the scrips are executing on your own machine, I don't know if they'll be able to disable calls to local content.  So if you want to play porn videos stored on your PC on a billboard on the side of your space station, they probably can't stop you.  However, they can prevent you from linking to commercial content outside of your local machine or approved game content servers.

Share this post


Link to post
Share on other sites

Since the scrips are executing on your own machine, I don't know if they'll be able to disable calls to local content. So if you want to play porn videos stored on your PC on a billboard on the side of your space station, they probably can't stop you. However, they can prevent you from linking to commercial content outside of your local machine or approved game content servers.

its all about the functions they will give us for the LUA.

check LSL content.

 

they will base ingame scripting syntax on LUA, but implement their own functions...

if they dont implement a function to call for external data, you could try any function you ll find on internet about LUA for that, you will never compile your script ingame...

Share this post


Link to post
Share on other sites

its all about the functions they will give us for the LUA.

check LSL content.

 

they will base ingame scripting syntax on LUA, but implement their own functions...

if they dont implement a function to call for external data, you could try any function you ll find on internet about LUA for that, you will never compile your script ingame...

So they may not implement LuaSQL?

https://www.tutorialspoint.com/lua/lua_database_access.htm

Share this post


Link to post
Share on other sites

no idea.

it might be more simplified than that.

 

maybe they will just retain the original LUA syntaxes, and implement their own functions proper to the game mechanics, and in future releases, implement new functions

Share this post


Link to post
Share on other sites

no idea.

it might be more simplified than that.

 

maybe they will just retain the original LUA syntaxes, and implement their own functions proper to the game mechanics, and in future releases, implement new functions

They may wrap their database calls in something to create sealed classes so they get to define the db schema and content servers the way they want to, but I can't see an economy working without writing all the proposed transactions to a database.  And they've said they want the players to create the markets.  Maybe they'll make the fundamental technology for accessing market data into an element that market terminals will have to use to connect to the legit databases.

Share this post


Link to post
Share on other sites

They may prevent us for accessing external stuff even on our PC with sandboxes for example.

 

That is why we must tell them how cool it would be to let us do so!

Share this post


Link to post
Share on other sites

Market

 

They may wrap their database calls in something to create sealed classes so they get to define the db schema and content servers the way they want to, but I can't see an economy working without writing all the proposed transactions to a database.  And they've said they want the players to create the markets.  Maybe they'll make the fundamental technology for accessing market data into an element that market terminals will have to use to connect to the legit databases.

 

Take a look here. It's got plenty of information about how NQ is planning on doing player markets.

 

But regardless of market handling, I agree that we should have some ability to store databases of information. I currently have no preference to having a Storage element vs having access to an external database. I'm curious what NQ is thinking.

Share this post


Link to post
Share on other sites

I agree, it might be easier for programmers to use external databases but since they wish to make LUA scripting as easy as possible they might implement their own stuff.

Share this post


Link to post
Share on other sites

Market

 

 

Take a look here. It's got plenty of information about how NQ is planning on doing player markets.

 

But regardless of market handling, I agree that we should have some ability to store databases of information. I currently have no preference to having a Storage element vs having access to an external database. I'm curious what NQ is thinking.

OK so the Market Units and Trade Service Units are predefined elements so the db connections for the economy are inside sealed classes, which is not to say totally unhackable but I'm sure it would be a whopping violation of TOS if someone figured out a way to directly access the trade database.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...