Frank 177 Posted March 8, 2016 Report Share Posted March 8, 2016 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 Quote Link to post Share on other sites
nichewebstrategies 12 Posted March 8, 2016 Report Share Posted March 8, 2016 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. Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 9, 2016 Report Share Posted March 9, 2016 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 Quote Link to post Share on other sites
Bot-Factory 602 Posted March 9, 2016 Report Share Posted March 9, 2016 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 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.