SQLite Windows Class

User projects written in or related to FreeBASIC.
rpkelly
Posts: 51
Joined: Sep 03, 2016 22:36

SQLite Windows Class

Postby rpkelly » May 14, 2017 2:53

Sharing the SQLite class I use for WIndows. Tested with 100 threads pulling 46K rows each on bit 32 and 64 bit compiles using the default 1MB stack.

https://github.com/breacsealgaire/FreeBasic-32-64-Windows-SQLite-Class

Added SQLite connection pool class and example. Useful for multi threaded access.
Last edited by rpkelly on May 14, 2017 16:38, edited 2 times in total.
Tourist Trap
Posts: 2381
Joined: Jun 02, 2015 16:24

Re: SQLite Windows Class

Postby Tourist Trap » May 14, 2017 9:17

Hi rpkelly, thanks for this. Have you a small example to get started with your lib?
rpkelly
Posts: 51
Joined: Sep 03, 2016 22:36

Re: SQLite Windows Class

Postby rpkelly » May 14, 2017 15:01

Tourist Trap wrote:Hi rpkelly, thanks for this. Have you a small example to get started with your lib?


There is a sample script cCTSSQLite_Script_txt on Git. One thing to be aware of is that the library was designed to support both a standalone client and a client server design. The spooler class when returning the results provides a file handle with the file pointer at the beginning and the file size so a server can begin to read and send via TCP. For a standalone client, one additional spooler call to function EndSpoolStreamFile that sets the file pointer to the first result block is needed and shown in the sample test script.
rpkelly
Posts: 51
Joined: Sep 03, 2016 22:36

Re: SQLite Windows Class

Postby rpkelly » May 14, 2017 17:17

Added Windows crypto class useful for SQLite client/server authentication with example of one way to design a handshake.
rpkelly
Posts: 51
Joined: Sep 03, 2016 22:36

Re: SQLite Windows Class

Postby rpkelly » May 14, 2017 17:27

This SQLite Windows collection is the beginning of a complete set of classes for a client/server group. Over the next several months, there are basically three additional classes. Socket (already in place with preliminary testing), Client, and, Server classes after which all the tools will be in place. The developer will build the GUI part of the server and use a message only window for communication with the server class which will provide the supporting functions for handshake, SQLite database and sending the results. The server class will be designed around one TCP listening port and one UDP listening port. The UDP port is used as a server discovery.
rpkelly
Posts: 51
Joined: Sep 03, 2016 22:36

Re: SQLite Windows Class

Postby rpkelly » May 27, 2017 0:14

Added a thread pool class that the server class will eventually use.

https://github.com/breacsealgaire/FreeBasic-32-64-Windows-SQLite-Class
OakLeaf
Posts: 5
Joined: Nov 30, 2012 19:30

Re: SQLite Windows Class

Postby OakLeaf » Apr 18, 2018 22:39

Wow, this is Great! One of the most useful projects to appear on FB. I'll definitely be using this. Thanks so much.

Return to “Projects”

Who is online

Users browsing this forum: No registered users and 1 guest