mark
New Member
Posts: 24
|
Post by mark on Jun 11, 2020 19:40:53 GMT -5
I have a hosting account that I use a mySQL database. Is there anyway I can use this online database to work with my Liberty BASIC program on my desktop?
I see a lot of references to the SQLite on this message board. I have never heard of it. Is this a database that can be used on your computer with the LB program?
I don't know what a SQLite is and after visiting their website I am still confused about what it is and how it works or installed. Can anyone give me a brief overview and/or example of use? Thanks
PS I am looking for a database that can be used offline on a computer with a LB program and especially if I can distribute it in a finished product maybe. I have used a database created with files that I read and write to which works fine for me but I was just wondering what is available for similar purposes.
|
|
|
Post by metro on Jun 11, 2020 20:24:24 GMT -5
I have a hosting account that I use a mySQL database. Is there anyway I can use this online database to work with my Liberty BASIC program on my desktop? I see a lot of references to the SQLite on this message board. I have never heard of it. Is this a database that can be used on your computer with the LB program? I don't know what a SQLite is and after visiting their website I am still confused about what it is and how it works or installed. Can anyone give me a brief overview and/or example of use? Thanks PS I am looking for a database that can be used offline on a computer with a LB program and especially if I can distribute it in a finished product maybe. I have used a database created with files that I read and write to which works fine for me but I was just wondering what is available for similar purposes. I'm fairly sure a mySQL connection is doable but is beyond my ability, I do have code somewhere that does achieve exactly that. There are many small examples of Sqlite databases on this forum however our database guru has a lot of information on his site
|
|
mark
New Member
Posts: 24
|
Post by mark on Jun 11, 2020 21:07:16 GMT -5
Thanks metro.
|
|
|
Post by metro on Jun 11, 2020 23:28:58 GMT -5
mark,
I have an example that is currently work in progress using the latest SQlite3 tools (Dlls) Chris has gifted us
It needs a GUI (when I find the time) and code to search/extract info. It hunts in the location you set for the file types you set (thanks to the original unknown coder for that snippet) I search "C:" for all *.bas files, drop the list of paths into a file then, at this point in time I only insert 50 of the 3264 *.bas programs I have on this install. need to clear out duplicates first.
The plan is to create another table and insert only FUNCTIONS so I can search easily for Brandon's fantastic contributions. I find this tool very useful sqlitebrowser.org/I can instantly view Db's to check results just by double clicking on the Db and I find it easy to picture the structure of the whole Db with it.
Remember it's a project I've just started so plenty of cleaning up required and I am still very much an amateur
uses the old Sqlite3 wrapper
good luck
|
|
|
Post by Chris Iverson on Jun 12, 2020 0:26:57 GMT -5
You have pretty much described SQLite accurately. It's a database engine that gets distributed with your application, to enable you to work with lightweight local databases.
"I am looking for a database that can be used offline on a computer with a LB program and especially if I can distribute it in a finished product maybe."
Yes, you can distribute it with your program, the database too.
The primary difference between MySQL and SQLite is that MySQL is more suited to run as a central server; multiple applications/users would connect to a single backend database, and all share the same data directly. If one user modifies the data, all users of the same database will see that change.
SQLite is NOT intended to run as a central server, and in fact, it can't. Your application uses the SQLite library to work directly with a local database file stored on the local computer. That file is NOT synced to a central server, or synced to other clients automatically. If one user updates the database, they are only updating their copy of it, and no one else will see the changes.
SQLite is intended to bring some of the more useful data processing features of relational databases to general-use desktop clients, without needing to connect to a central backend server(which requires a lot of investment in setting up and maintaining the central server, not to mention making sure it stays secure).
|
|
|
Post by pierre on Jun 12, 2020 3:32:58 GMT -5
Hello metro,
You mentioned the 'sqlitening' client/server.
This program was written for Power BASIC. The package contains also a dll supposedly suited for other BASIC languages, but I never got it working with Liberty BASIC.
Did you try it ?
pierre
|
|
|
Post by metro on Jun 12, 2020 3:39:31 GMT -5
Hello metro,
You mentioned the 'sqlitening' client/server.
This program was written for Power BASIC. The package contains also a dll supposedly suited for other BASIC languages, but I never got it working with Liberty BASIC.
Did you try it ?
pierre
Hi pierre,
Sadly no, I have been using Linux for seven or eight years . Wine gives me some grief running windows apps from time to time so I never attempted using it because of that. Plus I have not needed to have a server. all of the code I create is for my convenience. I mentioned it because it maybe of interest to mark as he has a hosting account and could potentially be either on the road with his work or need to access a Db from different locations.
EDIT : seems some folks have had success using wine, I'll take a look when I get a chance
|
|
|
Post by pierre on Jun 12, 2020 10:51:46 GMT -5
Thanks, metro. Never mind.
Don't waste your time. Just curious to know if somebody else might have had the opportunity to take a look at sqlitening..
pierre
|
|