This is a read-only snapshot of the ComputerCraft forums, taken in April 2020.
InDieTasten's profile picture

IDT-SQL - A Lua-SQL Interpreter

Started by InDieTasten, 18 April 2014 - 08:08 AM
InDieTasten #1
Posted 18 April 2014 - 10:08 AM
Hello everyone,
I am working on the following for quite some time:


Platforms:
  • Hosting API allowing to perform operations on the localhost table files
  • Dedicated Server Software as an active running application
  • Background Service-like server application
  • Connector-API for rednet connections and easier iteration through the result sets
Features:
  • Commands(Statements):
    • ​simple select (simplified for the first versions due to high complexity)
    • insert
    • update
    • delete
    • where (simplified for the first versions due to high complexity)
    • limit
    • order by
    • create (simplified for the first versions due to high complexity)
    • simple alter (simplified for the first versions due to high complexity)
    • drop
  • Datatypes:
    • number
    • string
    • worldtime(ddddThh:mm:ss with 'T' as seperator)
    • datetime(yyyy.mm.ddThh:mm:ss as real time (http-api meets time server :3 ))
  • Commands(Functions)
    • sum
    • min
    • max
    • avg
    • count
Progress[40%]:
I expect the first version to be finished in about a week or so. The core is pretty much done for the "Localhost API" and the only thing left is the interpreter itself, which is still, pretty complex but the string library be with me ^_^/>

Ideas:
  • Permission sytem with Grant and Revoke
  • Please comment your own, because the earlier the idea the easier to prepare the api
Download:
Not yet available
Edited on 18 April 2014 - 10:02 AM
Lyqyd #2
Posted 18 April 2014 - 03:23 PM
No code to show; locked. Please report your topic when you have code to add to the post.