Accessing An Sqlite Database

[Frank 177]

Hey all, I'd like to hit you all up today to see if you can give me some insights. I've been using the great plugin from Aymen to access sqlite databases, but I'd like to take things a bit further and be able to access the sqlite database directly through jquery calls inside of ubot. Anyone got any ideas on how to accomplish this?

 

It would tremendously improve my tables in the ubot browser.

 

Thanks!

 

Frank

[nichewebstrategies 12]

Hey Frank,

 

You will want to take a look at SQL.js to accomplish this.

 

https://github.com/kripken/sql.js

 

I've used this, but not in UBot. The challenge is loading the db file and saving the db file and I had to use the persistent database example to make it work for my project. I don't think that method will translate well to UBot though.

 

https://github.com/kripken/sql.js/wiki/Persisting-a-Modified-Database

 

Take a look at the web worker example as I think that will be the best bet unless you are using node.js.

 

Hope this helps.

 

 

[Code Docta (Nick C.) 638]

Hey Frank,

I know u said JQuery but this may interest you.

 

http://network.ubotstudio.com/forum/index.php/topic/19021-run-sqlite3-in-ubot-59x-temp-fixworkaround/

 

Nice intro to sqlite3 in python

 

 

CD

[Bot-Factory 602]

Hey all, I'd like to hit you all up today to see if you can give me some insights. I've been using the great plugin from Aymen to access sqlite databases, but I'd like to take things a bit further and be able to access the sqlite database directly through jquery calls inside of ubot. Anyone got any ideas on how to accomplish this?

 

It would tremendously improve my tables in the ubot browser.

 

Thanks!

 

Frank

 

Just out of interested. What is not working for you with the plugin? Or do you try to improve performance somehow?

 

Dan