SQLighting

[Joe Byrne]

For anyone who has missed this, Paul Squires and Fred Meier have put a lot of time into an SQLite database system dubbed SQLighting. This is an open source project for PB that is nothing short of amazing. The database can run locally (single user) or remotely (multi-user), and the speed is incredible!

Fred has put a lot of work into the source and just posted (8/5/08) an example using most of the common SQL statements you'd have in a real world app.

It takes some extra thinking to switch gears from BTree/Tsunami/Etc to SQL, but its real easy to see the advantages.

My heartfelt thanks to Fred and Paul, and I encourage everyone to have a look.

[Petr Schreiber jr]

Thanks a lot,

I am sure the product is very nice, but it seems the links to ZIP files are not valid, I get:

Ouch!

Looks like the requested web page could not be found.

You will now be redirected to the main PlanetSquires Software web page. If you are not redirected there within 5 seconds then you will need to head on over to http://www.planetsquires.com using your own powers

Thanks,
Petr

EDIT: Links on website do not work for me, but forum attachement yes.

[Paul Squires]

Thanks Joe!

The code base is Fred's. He has put a huge amount of work into this. I am blown away about how easy SQLitening is to use. I have dropped my SQLite client/server code in favor of SQLitening. It is the only database product that I now use for my products. It is already pretty robust for such a young product. Best of all it is FREE and OPEN SOURCE!!!! I can't imagine there being an easier to use, powerful, SQL based, free solution for PowerBASIC.

I have fixed the broken links on the PlanetSquires site (sorry about that).

Database use has never been easier for both local and client/server modes.

[Joe Byrne]

The code base is Fred's. He has put a huge amount of work into this. I am blown away about how easy SQLitening is to use. I have dropped my SQLite client/server code in favor of SQLitening.

Oops, my mistake. I thought Fred just updated your SQLite C/S.

Kudos to Fred!

And thanks to Paul for hosting the forum.

[Paul Squires]

I like to think that Fred borrowed some my ideas from my implementation! ha ha ha ha

[Chris Holbrook]

Is there a fuller description of SQLitening somewhere? I like to be well informed on these matters!

[Chris Holbrook]

I meant Litening

Is there a fuller description of SQLitening somewhere? I like to be well informed on these matters!

... I'm asking 'cos the Product Page (link from PlanetSquires main) just gives the download page, no further descriptive information.

[Petr Schreiber jr]

Chris,

download is about 800K and contains CHM help file with some useful information. You can locate it in "Doc" subdirectory.

It is evident that Paul Squires and Fred Meier put lot of effort in SQLightning, I agree it deserves its own mini website describing features.


Petr

[Chris Holbrook]

I agree it deserves its own mini website describing features.

As you say, they seem to have expended some effort on it, and to be pleased with the results. Never mind the website, I would settle for a short paragraph! Time is on my side, I think.

[Martin Francom]

SQLitening is great!!!. Fred and Paul thanks for the good work.

[Paul Squires]

Hi Chris,

There is no real description there yet because the library is still pretty young. To be honest, I haven't put a lot of effort into promoting the library yet because we wanted the code base to mature a little bit and give us an opportunity to get some good documentation together.

SQLitening is a PowerBASIC wrapper that interfaces to the SQLite (version 3) database (www.sqlite.org). SQLite is used by millions of programers and applications world wide. It is SQL based, extremely fast, small, and robust. SQLitening allows you to use the SQLite database in either local or client/server modes. Local mode is essentially using SQLite directly. Using SQLite in local mode is extremely easy and wicked fast. The code base is such that when you outgrow the need for local (standalone) mode, you only have to add an additional statement to your program to enable client/server mode.

In client/server mode, SQLitening runs as a Windows Service. C/S mode makes multiuser access amongst multiple users of your application very easy. The server synchronizes access to the database eliminating the locking issues that sometimes plague mulituser applications. SQLitening allows for specifying file access permissions as well as encryption of data.

The command set in SQLitening is very complete and allows interaction with the SQLite SQL engine very easy. It can easily replace traditional flat file databases such as Cheetah - it only entails a little change in mindset when thinking in SQL terms.

If there is anything in specific that you would like to know then don't hestiate to ask.

[Chris Holbrook]

Thanks Paul!

So essentially it is a stage in the development of your SQLite Client/Server.

[Paul Squires]

Not really. I had written SQLite Client/Server but a couple of months ago Fred Meier approached me with a similar code base and we decided to take the best of both and build upon one common base. After looking at Fred's code base it was a no brainer for me to discontinue developing my code and switch to Fred's. Fred's code was much further along than mine and a little easier to use as well. It made sense for us to team up and work on one set of code rather than each of us struggle maintaining two separate, but similar, products.

[Nick Luick]

Paul you happen to know why www.sqlite.org is no more. For last few days even whois does not list it.

-----------
Well whois does list it but my routine don't work well with .org

[jcfuller]

Paul you happen to know why www.sqlite.org is no more. For last few days even whois does not list it.

It's fine for me.
Here's a link that will tell you if it's just you.

http://downforeveryoneorjustme.com/#

James

[Nick Luick]

Appears Sqlite.org is hosted by linode.com and has become less responsive. Alternate site is

http://www.hwaci.com/sw/sqlite/

source of info:

http://osdir.com/ml/db.sqlite.general/2004-03/msg00370.html

[Nick Luick]

I was playing around again trying to access sqlite.org, as I thought it was a temporary issue. I'm not crazy (yet).

The message below is returned from IE5.5 one computer on cable and the same message for IE6 on dsl when trying to access sqlite.org. Now when I bring up foxfire 2.0 browser on the dsl it accesses the sight just fine.

The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

If you typed the page address in the Address bar, make sure that it is spelled correctly.

To check your connection settings, click the Tools menu, and then click Internet Options. On the Connections tab, click Settings. The settings should match those provided by your local area network (LAN) administrator or Internet service provider (ISP).
If your Network Administrator has enabled it, Microsoft Windows can examine your network and automatically discover network connection settings.
If you would like Windows to try and discover them,
click Detect Network Settings
Some sites require 128-bit connection security. Click the Help menu and then click About Internet Explorer to determine what strength security you have installed.
If you are trying to reach a secure site, make sure your Security settings can support it. Click the Tools menu, and then click Internet Options. On the Advanced tab, scroll to the Security section and check settings for SSL 2.0, SSL 3.0, TLS 1.0, PCT 1.0.
Click the Back button to try another link.



Cannot find server or DNS Error
Internet Explorer

[Chris Holbrook]

no problem for me using IE7.

[Scott Slater]

...It can easily replace traditional flat file databases such as Cheetah - it only entails a little change in mindset when thinking in SQL terms.

Hi Paul, do you know of any tutorials or good places to start getting a basic understanding of SQL and how it would apply to SQLitening? I have never worked directly with SQL, but am familiar with other B+Tree and flat database formats.

[Chris Holbrook]

...do you know of any tutorials or good places to start getting a basic understanding of SQL ...

http://www.w3schools.com/sql/default.asp