• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu

Recent posts

#21
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.
#22
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?
#23
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
#24
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
#25
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.
#26
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.
#27
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?
#28
You've got Questions? We've got Answers! / Re: SQLitening + VB.Net2019
Last post by xela - March 04, 2023, 11:21:48 AM
Thanks CJ
I too read all the messages concerning VBNet and VB6 but they are a bit old and I was looking for confirmation that there are no problems with the latest versions of VBnet

I normally use VBNet to connect to a local DB SQLite.
I have problems there are when I try to do it remotely and in multiuser

I will try to contact someone directly here on the site.
Thanks again for your answer
#29
You've got Questions? We've got Answers! / Re: SQLitening + VB.Net2019
Last post by cj - March 04, 2023, 08:41:39 AM
Searched for VB.NET and .NET in upper right corner and found some hits like this.
https://sqlitening.planetsquires.com/index.php?topic=9622.msg25395#msg25395
Might send a private message to someone in any link found.

Sqlitening does no encryption over the internet and does not use certificates.
A middleware program between the client and server could do that.

SQLitening is a pure joy to work with so I hope you can use it.
I would help on the SQLitening side as I don't use any .NET.

---
Call SQLite using .net  (just placed here as a reference.)
https://www.skotechlearn.com/2021/06/connect-SQLite-in-VB-Net.html

There is https://sqlabs.com/cubesql  (the 2-user version is free according to there site.)
#30
You've got Questions? We've got Answers! / SQLitening + VB.Net2019
Last post by xela - March 04, 2023, 07:23:57 AM
Hello everyone
I just discovered the existence of SQLitening that it can help me to solve a remote connection problem with my sqlite DB.
I need help and I'm turning to all of you.
Is anyone using SQLitening with VB.Net 2019 or higher?
Thanks for your replies