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.

Topics - D. Wilson

Pages: [1] 2 3 ... 5
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! / 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! / 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! / 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! / 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.

You've got Questions? We've got Answers! / Dual Servers
« on: January 15, 2016, 03:40: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 ??

You've got Questions? We've got Answers! / Security
« on: September 03, 2015, 07:06:05 PM »
Using Sqlitening - What measures should be adopted to prevent SQL Injection attacks. Any thoughts would be appreciated.

You've got Questions? We've got Answers! / Updating SQlite Engine
« on: August 20, 2015, 05:50:28 PM »
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.

General Board / Future
« on: February 03, 2014, 06:39:09 PM »
I have noticed a lot of activity on the Power Basic Forums regarding companies (including Paul's) severing ties with Power Basic. The question I have is where does that leave us ?? Who is hosting the forum ?? I know SQLitening is open source but we never know what the future holds.

You've got Questions? We've got Answers! / Windows 7
« on: October 01, 2013, 07:38:18 PM »
Ok I have to break some habits. I have always created my own directory (not under Program Files) and placed my program/data files  in those directories. I have found this to be very reliable in the past and has worked excellent for my needs.

But with Windows 7 -- Windows will not allow you to save to those directories without  setting the program to Administor level. However when I set a program for Adminstrator access - I get the pop up asking if I would like to allow the program to make changes to the computer.

It also does not like the app.path statement to get the path of the software. I used to create a file there where I kept all my settings.

What is the best approach to saving data and allowing user permissions on Windows 7 ??

Also does this effect SQLitening running in the client/server mode ??

Any thoughts or  advice would be greatly appreciated.

You've got Questions? We've got Answers! / extended characters
« on: September 16, 2013, 11:16:29 PM »
I am considering utilizing some characters in the extended character set. Ascii value greater than 127 and less than 255. I would like to use them as field delimiters in a field (I want to combine several fields into one before sending it the database).

Do you think this would raise any issues in using them in a sqlite database. I am going to do some testing. But I thought I would put it out and see what other think or what they have experienced.

General Board / Power Basic Down ??
« on: July 22, 2013, 10:54:17 PM »
For the past two days I have been trying to access the power basic website. I have not been able to. Is anyone else having the same issues

You've got Questions? We've got Answers! / numeric query issue
« on: July 16, 2013, 10:45:01 PM »
I created a database and have a set declared as numeric. I used an external program and the database structure says the field is numeric. I imported a bunch of data in the table. But I am having trouble retrieving data from the table.

I know there are 0 values (THE NUMBER ZERO)  in the table.
When I query                            SELECT * from Table WHERE fieldname =0        it returns nothing
When I query                            SELECT * from Table WHERE fieldname = '0'      it return the expected results ????
When I query                            SELECT * from Table WHERE fieldname > 0        it returns nothing
When I query                            SELECT * from Table WHERE fieldname =1.15    if returns the expected results.

All my other querys work great. It seem to be related to 0 (zero) queries.

I have used the is null syntax and sqlite does not return any value (as expected) I know the fields have a value.

I have spent over 4 hours trying to figure this out. I think I am having a 'senior' moment (But I am not that old). What am I missing. Any help/insights would be appreciated.

Pages: [1] 2 3 ... 5