SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  


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

Pages: [1] 2 3 ... 14
You've got Questions? We've got Answers! / Re: Encryption
« on: December 19, 2018, 01:35:29 PM »
That was going to be my next question. Do I write/query the database just like normal ? What about blob fields that contain images ?

You've got Questions? We've got Answers! / Encryption
« on: December 18, 2018, 06:34:52 PM »
What are the steps to provide encryption to an sqlite database ??

If I encrypt a database using SQLitening can I open it and decrypt it using third party tools (ie a SQLite Database Viewers)

Any help would be appreciated.

You've got Questions? We've got Answers! / Re: replication
« on: April 23, 2018, 10:46:44 PM »
Currently I am using a log file and posting to the remote server then the local server. It works great and I have a log of all the activity of database transactions.

I am always open to alternative methods.

You've got Questions? We've got Answers! / Re: replication
« on: April 19, 2018, 05:10:07 PM »
Ideally real time. Currently I have a log file that I process.

look at litesync.io  it looks like it would fit the bill however the way it connects to the database doesn't look like it would work.

You've got Questions? We've got Answers! / replication
« on: April 19, 2018, 04:00:38 PM »
I would like to replication a sqlite database at multiple locations.
I have looked online and there are several solutions. However they want all traffic routed through their server.
I like Litesync.io it is bidirectional and offers an 'Airplane' mode.

I want to keep the functionally of the sqlitening server.

Any insights would be greatly appreciated.

You've got Questions? We've got Answers! / Re: Group by Questions
« on: February 12, 2018, 12:37:52 AM »
CJ Thanks for the help. Over the next couple of days I will try and get it tested and i will post my results.

The key that I was missing was the ability to divide by 1000 then do the grouping.

Once againg - Thank you.

You've got Questions? We've got Answers! / Group by Questions
« on: February 11, 2018, 06:13:11 PM »
I am stuck on another SQL Query. It is something that I know should be able to be done. I just can't figure out how to do it. I want to a group by and sum of a field. The 'grouping' field is numeric and 5 digits.

FYI -- The grouping field is a Sales Category. The first 2 digits represent the major catagory; and the remaining digits allow us to refine our inventory by sub categories.

Raw data:

                 51000              $10.00
                 51100              $5.00
                 62500              $5.00
                 70000              $10.00
                 70500              $10.00

'Desired Results'

                 51000       51             $15.00
                 62000       62             $5.00
                 70000       70             $20.00

Basically I am subtotaling by the first two digits of the numeric value.

I am trying to create an SQL Query to get the report data. Any ideas or suggestions would be greatly appreciated.

Thank you for your assistance.

You've got Questions? We've got Answers! / Re: SQL Update Question
« on: December 16, 2017, 02:10:10 PM »
Add the ifnull to sqlstatement worked like a charm.

I want to thank those who jumped in and helped solve this. I spent hours trying to 'find' then answer on my own.

You've got Questions? We've got Answers! / Re: SQL Update Question
« on: December 15, 2017, 04:26:41 PM »
I did a work around and added and additional sqlstatement checking for isnull. But if there is an easier way I would appreciate any insights.

You've got Questions? We've got Answers! / SQL Update Question
« on: December 15, 2017, 03:42:26 PM »
I know sqlite is typeless in column types. I am stumped. I would like to update the value of a field however. If the field is null it will not update the field. For Example:
                               Update INVENTORY set qty_on_hand = qty_on_hand + 5 Where Itemcode ='Item Code'

                         If the original value is 10. The server would update it to 15.
                         If the original value is null (no value in the field). The server does not apply the change.

Any help and insights would be greatly appreciated.

I have been using SQLitening for several years now with great success. I would like to 'hear' what other peoples stories have been. What has been the largest install in the way of users/database sizes. Has you encountered any issues that would worth sharing ??

You've got Questions? We've got Answers! / pictures
« on: August 13, 2016, 12:57: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
« on: February 08, 2016, 04:35: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.

You've got Questions? We've got Answers! / Re: SQLitening in real life
« on: February 06, 2016, 05:41:45 PM »
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
« on: February 06, 2016, 05:38: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.

Pages: [1] 2 3 ... 14