dankass 52 Posted October 9, 2013 Report Share Posted October 9, 2013 Am I overlooking the existence of a command to create an empty SQLITE database file in UBS 5? Quote Link to post Share on other sites
Big Jay 35 Posted October 9, 2013 Report Share Posted October 9, 2013 http://screencast.com/t/RjMazxb1zty Use the Connect to Database command - when the wizard pops up use the dropdown to select the database type you are interested in. (as seen at the link above) Quote Link to post Share on other sites
dankass 52 Posted October 9, 2013 Author Report Share Posted October 9, 2013 Thanks, but the question is how to CREATE an empty database to start with, not connect to an existing one. However, even when I put a pre-made sqlite file in there I do not get anything but an error establishing a connection. I have been using aymen's sqlite plugin previously, but I cant even make that work with ubot 5 now... kind of having a nighmare right now with several issues at the same time and not sure whats causing what. in order to even file a bug report. http://screencast.com/t/RjMazxb1zty Use the Connect to Database command - when the wizard pops up use the dropdown to select the database type you are interested in. (as seen at the link above) Quote Link to post Share on other sites
dankass 52 Posted October 12, 2013 Author Report Share Posted October 12, 2013 nobody knows if there is a command to create an empty database? Is this somehow an oversight or what? Quote Link to post Share on other sites
kev123 132 Posted October 12, 2013 Report Share Posted October 12, 2013 no command in there like aymens plugin. As a quick get round you can use SQLite manager plugin for firefox to create a DB(if you only plan to use a pre created DB in your software Quote Link to post Share on other sites
dankass 52 Posted October 12, 2013 Author Report Share Posted October 12, 2013 no command in there like aymens plugin. As a quick get round you can use SQLite manager plugin for firefox to create a DB(if you only plan to use a pre created DB in your software Thanks, that's what I thought... Problem is my bot (using Aymens plugin now) needs to create the database on the fly... at least thats how I coded it now (uses a whole new db for each site its scraping because each site is pretty huge (100k+ entries) and scraping hundreds of sites. only reason I was interested in changing from aymens plugin is, I assume end user would not need to install anything extra with the built-in one... but I have yet to even confirm that is the case or not either. I feel kind of under water on this ub5 trying to chase down all the things I cant seem to get working... oh well... thanks for confirming what I thought anyway. Quote Link to post Share on other sites
Nello 0 Posted May 8, 2015 Report Share Posted May 8, 2015 Hello, I suppose you can just open the connection the way Big Jay showed up and then send the CREATE statement in SQL format using the QUERY command (with no results). Of course you might want to test first if the database and the tables are already existing before creating them. 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.