fastlinks 16 Posted July 5, 2014 Report Share Posted July 5, 2014 Hi, is it possible to connect to a password protected Sqlite DB? how to write the connection string? as the plugin only ask for the path. Thanks Quote Link to post Share on other sites
Bot-Factory 602 Posted July 5, 2014 Report Share Posted July 5, 2014 Hi, is it possible to connect to a password protected Sqlite DB? how to write the connection string? as the plugin only ask for the path. ThanksI think this is currently not supported with the plugin. Dan 1 Quote Link to post Share on other sites
Aymen 385 Posted July 5, 2014 Author Report Share Posted July 5, 2014 Hi, is it possible to connect to a password protected Sqlite DB? how to write the connection string? as the plugin only ask for the path. Thanks You can't do that for now , i'll add it in a future update! 1 Quote Link to post Share on other sites
Bot-Factory 602 Posted August 13, 2014 Report Share Posted August 13, 2014 Hello. I have some issues to execute a query with WHERE xx LIKE 'yy'The sql query works fine with the sqlite command line tool. But when I try to run it with the plugin it doesn't work. Seems to be related to the LIKE command. Here's the complete query:select urls from profiles WHERE Sprachen LIKE 'deutsch' Thanks in advance for your helpDan 1 Quote Link to post Share on other sites
Bot-Factory 602 Posted August 13, 2014 Report Share Posted August 13, 2014 Update: Seems to be related to the size of the database. It works for a small DB. But for a large one with 5Million entries this doesn't work correctly.But when I run the query with my sqlite admin tool (sqlite expert professional), the query executes in 99ms. Update2:Ok this issue is clearly a time problem. I had to wait a lot longer for the query to finish. So the following query:select urls from profiles WHERE Sprachen LIKE 'deutsch' Took 95ms in my SQLite Tool. With the UBot Plugin the same query against the same database took:2minutes and 47 seconds. Any idea why this happens? Can we improve that? ThanksDan Quote Link to post Share on other sites
kev123 132 Posted August 13, 2014 Report Share Posted August 13, 2014 Update: Seems to be related to the size of the database. It works for a small DB. But for a large one with 5Million entries this doesn't work correctly.But when I run the query with my sqlite admin tool (sqlite expert professional), the query executes in 99ms. Update2:Ok this issue is clearly a time problem. I had to wait a lot longer for the query to finish. So the following query:select urls from profiles WHERE Sprachen LIKE 'deutsch' Took 95ms in my SQLite Tool. With the UBot Plugin the same query against the same database took:2minutes and 47 seconds. Any idea why this happens? Can we improve that? ThanksDanis this the command that returns into a ubot table, how many rows if its a lot then the bottleneck is loading into the ubot table. One quick fix is to use the limit SQLite command process being. 1.check how many rows your database has for the query.2.use the SQLite limit command to read out in chunks of 500.3.add to something like a large table.4.repeat to all are read out. Quote Link to post Share on other sites
Bot-Factory 602 Posted August 13, 2014 Report Share Posted August 13, 2014 is this the command that returns into a ubot table, how many rows if its a lot then the bottleneck is loading into the ubot table. One quick fix is to use the limit SQLite command process being. 1.check how many rows your database has for the query.2.use the SQLite limit command to read out in chunks of 500.3.add to something like a large table.4.repeat to all are read out.Thanks Kev. tested that as well. But that's even slower. Probably because I have to use offset in combination with LIMIT. I also tried to user "where rowid between 1 AND 50000"but that takes over 2 minutes as well. Even when I use "save to file". So no variables or anything involved. Same query executes in 39ms in my tool. So this looks like a performance issue with the sqlite plugin to me? @Aymen: Any idea why this could happen? ThanksDan Quote Link to post Share on other sites
Aymen 385 Posted August 13, 2014 Author Report Share Posted August 13, 2014 Thanks Kev. tested that as well. But that's even slower. Probably because I have to use offset in combination with LIMIT. I also tried to user "where rowid between 1 AND 50000"but that takes over 2 minutes as well. Even when I use "save to file". So no variables or anything involved. Same query executes in 39ms in my tool. So this looks like a performance issue with the sqlite plugin to me? @Aymen: Any idea why this could happen? ThanksDan I'll check that out Dan! Quote Link to post Share on other sites
Bot-Factory 602 Posted September 1, 2014 Report Share Posted September 1, 2014 I'll check that out Dan!Hi Aymen. Have you had time to look into that already? ThanksDan Quote Link to post Share on other sites
Bot-Factory 602 Posted September 25, 2014 Report Share Posted September 25, 2014 I'll check that out Dan! Hi Aymen, any news on the performance issue? CheersDan Quote Link to post Share on other sites
Aymen 385 Posted September 26, 2014 Author Report Share Posted September 26, 2014 Hi Aymen, any news on the performance issue? CheersDanBeen real busy Dan , i'll try to check it out soon! Quote Link to post Share on other sites
tripros 16 Posted October 13, 2014 Report Share Posted October 13, 2014 Regardless of how I set up the db path and what sql command I use, I continue to get the "Object reference not set to an instance of an object" error. Can create a db file, that works, all other sql commands give me this error and can not show any data using the get data command. Tried to create and populate the db file using sqliteexpert as Dan suggested (great program BTW, thanks Dan!) and then get data using ubot, still get the object error and 0 results. Tried this using the special folder (my documents) as well as direct path e:\dbname.sqlite and get the same error. Even tried the exact same data and examples Aymen showed in the video, getting same error. Using latest version (I assume, just downloaded a few weeks ago) Any suggestions? Thanks much! Quote Link to post Share on other sites
Bot-Factory 602 Posted October 13, 2014 Report Share Posted October 13, 2014 Regardless of how I set up the db path and what sql command I use, I continue to get the "Object reference not set to an instance of an object" error. Can create a db file, that works, all other sql commands give me this error and can not show any data using the get data command. Tried to create and populate the db file using sqliteexpert as Dan suggested (great program BTW, thanks Dan!) and then get data using ubot, still get the object error and 0 results. Tried this using the special folder (my documents) as well as direct path e:\dbname.sqlite and get the same error. Even tried the exact same data and examples Aymen showed in the video, getting same error. Using latest version (I assume, just downloaded a few weeks ago) Any suggestions? Thanks much!Could you post or PM your test DB and the code you use in UBot Studio? Dan Quote Link to post Share on other sites
tripros 16 Posted October 13, 2014 Report Share Posted October 13, 2014 Could you post or PM your test DB and the code you use in UBot Studio? Dan Sure thing, thanks Dan, here is the code, file attached: plugin command("SQLlite.dll", "SQLite Create Database", "{$special folder("My Documents")}/pc/pcdb.sqlite")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("My Documents")}/pc/pcdb.sqlite", "create table mytable (name varchar(50), category varchar(25), filename varchar(75))")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("My Documents")}/pc/pcdb.sqlite", "insert into mytable (name, category) values (\'Test Name\',\'category1\')")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("My Documents")}/pc/pcdb.sqlite", "insert into mytable (name, category, filename) values (\'Test Name 2\',\'category2\',\'myfile.zip\')")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Get Data", "{$special folder("My Documents")}/pc/pcdb.sqlite", "select * from mytable order by name desc", &results)alert($plugin function("SQLlite.dll", "sqlite error")) Verified that the create table and insert commands are working, opened the file in sqliteexpert, but when I try to select * with the get data command, I get the object error and zero results. Thanks! -----EDITforum here is telling me can't attach a sqlite or zip file, so not sure how to upload it? No way in PM either. Quote Link to post Share on other sites
Bot-Factory 602 Posted October 13, 2014 Report Share Posted October 13, 2014 Table cells can not be NULL for the Get Data command. You can create the table with empty cells, or you can always add information to all the cells. plugin command("SQLlite.dll", "SQLite Create Database", "{$special folder("Application")}\\test.sqlite")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("Application")}\\test.sqlite", "create table mytable (name varchar(50), category varchar(25), filename varchar(75))")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("Application")}\\test.sqlite", "insert into mytable (name, category, filename) values (\'Test Name\',\'category1\',\'NO FILE\')")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("Application")}\\test.sqlite", "insert into mytable (name, category, filename) values (\'Test Name 2\',\'category2\',\'myfile.zip\')")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Get Data", "{$special folder("Application")}\\test.sqlite", "select * from mytable", &results)alert($plugin function("SQLlite.dll", "sqlite error")) CheersDan Quote Link to post Share on other sites
tripros 16 Posted October 13, 2014 Report Share Posted October 13, 2014 Table cells can not be NULL for the Get Data command. You can create the table with empty cells, or you can always add information to all the cells. plugin command("SQLlite.dll", "SQLite Create Database", "{$special folder("Application")}\\test.sqlite")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("Application")}\\test.sqlite", "create table mytable (name varchar(50), category varchar(25), filename varchar(75))")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("Application")}\\test.sqlite", "insert into mytable (name, category, filename) values (\'Test Name\',\'category1\',\'NO FILE\')")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Query", "{$special folder("Application")}\\test.sqlite", "insert into mytable (name, category, filename) values (\'Test Name 2\',\'category2\',\'myfile.zip\')")alert($plugin function("SQLlite.dll", "sqlite error"))plugin command("SQLlite.dll", "SQLite Get Data", "{$special folder("Application")}\\test.sqlite", "select * from mytable", &results)alert($plugin function("SQLlite.dll", "sqlite error")) CheersDan Got it, thanks a bunch Dan, works like a charm now Appreciate your help! Quote Link to post Share on other sites
mobileconsultant 6 Posted October 30, 2014 Report Share Posted October 30, 2014 Hey Aymen, This looks like a really nice plugin! I just ordered. Thanks,Rich Quote Link to post Share on other sites
The Fixer 1 Posted November 1, 2014 Report Share Posted November 1, 2014 Hi. Does this plugin work with Godaddy shared hosting? Quote Link to post Share on other sites
mobileconsultant 6 Posted November 1, 2014 Report Share Posted November 1, 2014 Hey The Fixer, I believe most Ubotters run SQLite to write to the local disk on their PC and maybe on a hosted VPS or dedicated server. Shared web hosted accounts (usually Linux or Windows based) will most certainly not allow you to run SQLite directly on the server. Here is some SQLite info that may answer your question better, since I'm not sure what your end goal is with SQLite and your data. You may just be looking for a traditional RDBMS like MySQL to store and manipulate your data. About SQLitehttp://www.sqlite.org/about.htmlAppropriate Uses For SQLitehttp://www.sqlite.org/whentouse.html"SQLite is not directly comparable to other SQL database engines such as Oracle, PostgreSQL, MySQL, or SQL Server since SQLite is trying to solve a very different problem." I hope that helps someone...-Rich Quote Link to post Share on other sites
arunner26 51 Posted November 1, 2014 Report Share Posted November 1, 2014 mobileconsultant,Thanks for the info on SQLite. That helps! Quote Link to post Share on other sites
Aymen 385 Posted November 1, 2014 Author Report Share Posted November 1, 2014 Hi. Does this plugin work with Godaddy shared hosting? If it is a windows vps then yes it should work! Quote Link to post Share on other sites
Bot-Factory 602 Posted November 3, 2014 Report Share Posted November 3, 2014 Been real busy Dan , i'll try to check it out soon! Hi Aymen, don't want to be impatiently, but may I ask if you had time to look into this already?If not, any idea when you might have a free timeslot? CheersDan Quote Link to post Share on other sites
Aymen 385 Posted November 3, 2014 Author Report Share Posted November 3, 2014 Hi Aymen, don't want to be impatiently, but may I ask if you had time to look into this already?If not, any idea when you might have a free timeslot? CheersDan Not really Dan, sorry if i promised you something , been buried in work for over 2 weeks , i didn't forget about any update though! 1 Quote Link to post Share on other sites
Bot-Factory 602 Posted January 27, 2015 Report Share Posted January 27, 2015 Hi Aymen, just wanted to ask if you had some time during the last 3 months to look into the things we discussed: 1. Performance issue2. Table to database command with update option. Thanks in advance for your help. Kindest regardsDan Quote Link to post Share on other sites
Aymen 385 Posted January 27, 2015 Author Report Share Posted January 27, 2015 Hi Aymen, just wanted to ask if you had some time during the last 3 months to look into the things we discussed: 1. Performance issue2. Table to database command with update option. Thanks in advance for your help. Kindest regardsDan about the performance issue , can't really have it reproduced properly , what i concluded is that it can be tied to ubot itself , i won't promise you anything about this , will see how things goes !about new features and options i'll have a look at them when releasing the next version which will be in a week or so from now! 1 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.