Announcement

Collapse
No announcement yet.

SQLighting

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLighting

    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.
    Software makes Hardware Happen

  • #2
    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.
    Last edited by Petr Schreiber jr; 5 Aug 2008, 05:59 PM.
    [email protected]

    Comment


    • #3
      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.
      Paul Squires
      FireFly Visual Designer (for PowerBASIC Windows 10+)
      Version 3 now available.
      http://www.planetsquires.com

      Comment


      • #4
        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.
        Software makes Hardware Happen

        Comment


        • #5
          I like to think that Fred borrowed some my ideas from my implementation! ha ha ha ha
          Paul Squires
          FireFly Visual Designer (for PowerBASIC Windows 10+)
          Version 3 now available.
          http://www.planetsquires.com

          Comment


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

            Comment


            • #7
              I meant Litening

              Originally posted by Chris Holbrook View Post
              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.

              Comment


              • #8
                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
                [email protected]

                Comment


                • #9
                  Originally posted by Petr Schreiber jr View Post
                  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.

                  Comment


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

                    Comment


                    • #11
                      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.
                      Paul Squires
                      FireFly Visual Designer (for PowerBASIC Windows 10+)
                      Version 3 now available.
                      http://www.planetsquires.com

                      Comment


                      • #12
                        Thanks Paul!

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

                        Comment


                        • #13
                          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.
                          Paul Squires
                          FireFly Visual Designer (for PowerBASIC Windows 10+)
                          Version 3 now available.
                          http://www.planetsquires.com

                          Comment


                          • #14
                            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
                            Last edited by Nick Luick; 9 Aug 2008, 02:32 PM. Reason: to little research

                            Comment


                            • #15
                              Originally posted by Nick Luick View Post
                              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

                              Comment


                              • #16
                                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.genera.../msg00370.html

                                Comment


                                • #17
                                  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
                                  Last edited by Nick Luick; 27 Sep 2008, 02:20 AM.

                                  Comment


                                  • #18
                                    no problem for me using IE7.

                                    Comment


                                    • #19
                                      Originally posted by Paul Squires View Post
                                      ...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.
                                      Scott Slater
                                      Summit Computer Networks, Inc.
                                      www.summitcn.com

                                      Comment


                                      • #20
                                        Originally posted by Scott Slater View Post
                                        ...do you know of any tutorials or good places to start getting a basic understanding of SQL ...
                                        http://www.w3schools.com/sql/default.asp

                                        Comment

                                        Working...
                                        X