• Welcome, Guest. Please login.
July 06, 2020, 02:21:13 pm


Welcome to the SQLitening support forums!

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - D. Wilson

You've got Questions? We've got Answers! / pictures
August 13, 2016, 03:27:37 pm
I am working on a project that deals with lots of pictures. I have no problem adding/saving them to a sqlite database through sqlitening. The question I have is this....

Is it possible to save the picture files in a directory where the sqlite database is saved  (under a different directory) and retreive the file when needed through the sqlitening server.

I am already keeping the pictures in a seperate database. But I am thinking about back ups that having the images seperate would allow easier backups. Since I only have to backup the changes.

Any thoughts or help would be greatly appreciated.
You've got Questions? We've got Answers! / Re: Security
February 08, 2016, 06:05:38 pm
That answers most of my questions/concerns. I wanted to know if there was measures to prevent unwanted users to send sql commands to the server.
I have utilized SQLiteng in several production systems and I have not had any issues. I enjoy the easy of deployment and the ability to backup the databases quickly and easily. This is why I opted to use SQLitening vs MYSQL.
You've got Questions? We've got Answers! / Security
February 06, 2016, 07:08:09 pm
One question I have and maybe those who have studied the code. Is security. How secure is SQLitening we are not utilizing a User Name/ Password.

Does the server just accept calls from the dll or can other query the port.

Any Insight or suggestions in securing the server would be appreciated.
Thanks for the insight I will look into it.
You've got Questions? We've got Answers! / Dual Servers
January 15, 2016, 05:10:14 pm
I have two servers in two locations. Currently I write to one server , Close the connection and connect to the other server. Is there a better way to update both servers ??
CJ Do I also need to include the changes to the sqlitengclient.dll when testing this or does this eliminate the need to update the sqliteningclient.dll.
General Board / Re: slDisconnect corrected
November 19, 2015, 12:56:19 am
Thanks CJ and Bern for looking into this issue. I will be torture testing this next week and let you know what I find.
General Board / Re: slDisconnect corrected
November 16, 2015, 12:58:33 am
CJ thanks for the fast response. I will check it out. Like I said I have not experienced any problems with this issue.
I got it downloaded. Maybe we should get Paul to recompile the complete install package.
General Board / Re: slDisconnect corrected
November 15, 2015, 05:11:29 pm
First off I want to thank those involved in this forum and those who support SQLitening. I have had great success with SQLitening.

I have a couple of programs written in VB6 that utilize SQLitening. I use the SQLitening.Dll and  SQLiteningS.Dll.
Does this issue effect these Dll's. I have never experienced any issues before. it seems to be related to threads and I don't know if the Dll's that I use are involved with this issue.

Any Advice would be greatly appreciated.

Also I have an older copy of Power Basic. And honestly have not done much with them. Is it possible to get the fixes compiled in updated versions of SQLitening  If required.

You've got Questions? We've got Answers! / Security
September 03, 2015, 09:36:05 pm
Using Sqlitening - What measures should be adopted to prevent SQL Injection attacks. Any thoughts would be appreciated.
I have never done this -- What is the procedure for updating the sqlite database engine using sqlitening ?? The version that is included in with the downloads is an older version. Just curious -- I don't like being on the 'bleeding edge' but it would be good to know for the future.
How to Register for this Forum / Re: Hello
April 24, 2014, 01:03:42 am
Welcome -- I hope you find SQLitening helpful.
I only use begin/end in transactions. This 'forces' then database engine to lock the database and perform all the writes/updates at one time without opening/closing the database for each write/update. I don't feel there is a need to use begin/end when reading data from the database.  The reads take fractions of a second where as if you are updating 25000 records it could take a second or two. I also feel that sqlitening helps manage multiple users who are trying to access the database at the same time. Personally I never leave an open connection to the server. I open/close the connection when I need to access the database. In my experience this has worked excellent for my needs.
Hats off to CJ for sticking it out and helping solve this issue.