• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu

Recent posts

#1
General Board / Copy table to another database...
Last post by cj - July 06, 2023, 09:11:53 PM
#INCLUDE "sqlitening.inc"

FUNCTION PBMAIN AS LONG

 LOCAL sArray() AS STRING

 slOpen    "old.db","C"  'old schema: firstname,lastname,id
 slExe     "create table if not exists T1(firstname text,lastname text, id integer primary key)"
 slExebind "insert into T1 values(?,?,null)",bindstr("Heidi") + bindstr("Klum")
 slExebind "insert into T1 values(?,?,null)",bindstr("Robert")+ bindstr("Hope")
 slExebind "insert into T1 values(?,?,null)",bindstr("Bugs")  + bindstr("Bunny")
 slClose

 slOpen    "new.db","C"
 slAttach  "old.db","old" 'new schema: id,name
 slExe     "create table if not exists T1(id integer primary key,name text)"
 slExe     "insert or replace into T1(id,name) select id,lastname||', '|| firstname from old.T1"

 slselary  "select firstname,lastname from old.t1 " +_
           "union all " +_
           "select id,name from t1",sArray(),"Q9c"
 MSGBOX    JOIN$(sArray(),$CRLF)

END FUNCTION

#2
General Board / Default first record
Last post by cj - June 11, 2023, 02:54:55 PM
create table if not exists CounterTable(c1 integer,c2 text, c3 text);

insert into CounterTable (c1,c2,c3)              
 select 1,'cool','beans'                                
 where not exists (select * from CounterTable);


#3
You've got Questions? We've got Answers! / Timing (cache)
Last post by cj - May 19, 2023, 10:02:03 AM
SELECT * FROM WORDLIST WHERE LENGTH = 10  'missing column name

https://sqlite.org/forum/forumpost/fc1209eb59bcdbc0ec81e193561063707bcd36953d78a7c295521cd20277d674

QuoteThis is usually due to the operating system keeping recently used disk blocks in memory and/or SQLite doing the same with recently used pages from the database file.

#4
You've got Questions? We've got Answers! / Re: Timing problem
Last post by Fim - May 19, 2023, 06:55:58 AM
Now it wasn't the select statements that were the problem, they work as they should. The problem is that the first select statement takes 6 seconds but the next select statement only takes 0.6 seconds.
#5
You've got Questions? We've got Answers! / Timing problem
Last post by Fim - May 18, 2023, 10:10:00 AM
In a program to find words from a database of 4 million words, I have a timing problem.
If I execute a select statement, for example
SELECT * FROM WORDLIST WHERE LENGTH = 10
and then downloads all the selected data, it takes 6 seconds on a completely just started PC. The second time when I execute another select statement, SELECT * FROM WORDLIST WHERE LANGD = 12, and then retrieve all the selected data, it takes 0.6 seconds. If I exit the program without restarting the PC, restart the program, all the select statements take less than a second.
I've come so far in my research that it's not the Select statement itself that takes time, it's the subsequent fetching of data that takes time.
Anyone have a good explanation?
#6
You've got Questions? We've got Answers! / HELP SQLitening + VB.Net2019
Last post by xela - March 04, 2023, 12:22:08 PM
Hi Jonas
I take the liberty of writing to you directly because I saw that you were using Sqlitening with VB.Net 2015.
I wanted to ask you if you still use it and if you would be willing to help me with my problem connecting to a remote sqlite DB and multi-user.
I am willing to acknowledge your possible help.
Thank you for your answer
#7
You've got Questions? We've got Answers! / Re: SQLitening + VB.Net2019
Last post by xela - March 04, 2023, 12:12:55 PM
Yes
But I can't answer you. I am not authorized????
I will try to look at the settings
#8
You've got Questions? We've got Answers! / Re: SQLitening + VB.Net2019
Last post by cj - March 04, 2023, 12:07:11 PM
Did you receive an email alert  that I posted this message? :)

There are lots of settings by clicking down arrow to the right of your login name.
I have no idea of the default settings.
#9
You've got Questions? We've got Answers! / Re: SQLitening + VB.Net2019
Last post by cj - March 04, 2023, 11:56:57 AM
Might consider adding an interpreter like PHP to your choice of server.
I use Abyss Web server which allows adding PHP as an extension.
Abyss also directly supports free TLS for life using LetsEncrypt.
It automatically updates itself each year once setup.  Everything is free!

I know people use SQLite as a backend with web pages so it might be a way to go.
I don't know why a private message would fail.  I'll try sending you one.

Note: I was not getting email notifications.  Apparently it is working for me now.
Also, if you are not receiving email alerts, there is a button to receive email alerts in upper right and lower right corner.
I think there is also some setting that may need to be set.
#10
You've got Questions? We've got Answers! / Re: SQLitening + VB.Net2019
Last post by xela - March 04, 2023, 11:56:21 AM
Sorry CJ
I'm trying to send a personal message to Jonas Hdez
but when i press enter i get this message
"You are not allowed to access this section"
What am I missing?