Announcement

Collapse
No announcement yet.

SQLite Postings

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

  • SQLite Postings

    I see many postings about SQLite in the Programming section or elsewhere. I believe that since SQLite is a third-party software, and postings about it should be posted to the Third-Party Addons section.
    What do you think?
    It's impossible to make anything foolproof because fools are so ingenious.

  • #2
    My interpretation was 3rd party was for sales and support of 3rd party libraries created by others, (which SQLite does fall into on the later). But no one "vendor" is supporting SQLite in our midst.

    In a way I can agree that having all SQLite stuff in the one spot might be easy to find all related stuff about it but SQLite is a simple enough search word to globally look against all.

    Also, being it is a much more pervasive type of item it could in theory be best sorted into the area the application falls under, not the library itself.

    It's one of those "let sleeping dogs lie" type of items in my min OR... I would even like to see a Database programming section added.
    Last edited by George Bleck; 24 Aug 2015, 12:57 PM.
    <b>George W. Bleck</b>
    <img src='http://www.blecktech.com/myemail.gif'>

    Comment


    • #3
      George,
      Read the first eight words under "Third-Party Addons".
      It's impossible to make anything foolproof because fools are so ingenious.

      Comment


      • #4
        I have numerous times. So what you are saying is that anything we talk about except the WinAPI and the PB primitives must go into 3rd Party? I disagree. I think the context has everything to do with where it goes.

        If you are talking about programming concepts and some of them involve using the SQLite library... NO I do not think it belongs in 3rd party. If you are talking about the library itself and where to get it, how to use it's inclde files, etc. Then YES I could see it in 3rd party.

        Either way, I think a database sub-forum would be better as you can talk about SQLite, MySQL, Oracle, DBASE, XBASE, DB2, PostgreSQL. or any other type of database type or interface you can think of and the commonality of it being interacting with databases would tie them together conceptually.
        <b>George W. Bleck</b>
        <img src='http://www.blecktech.com/myemail.gif'>

        Comment


        • #5
          I personally like "database programming", which would include "SQL" and "table design", which are brand-agnostic but postings are often made in the context of one DBMS brand or another.

          Of course, many of the postings we see in all fora are eventually proven to be issues about using something other than what the OP thought he/she thought it was about. (See also: "code not shown").

          In DBMS programming, for example, what is presented as "help wanted with {SQLTools|MySql|SqlLite|MS-Access|Generic OBC} often resolve to the user's code ..
          Code:
              SqlStatement =  ????
          .. which of course has nothing to do with the brand-name DBMS or interface being used.

          There is no One Correct Way, but "database programming" would seem to be most inclusive.

          MCM
          Michael Mattias
          Tal Systems Inc. (retired)
          Racine WI USA
          [email protected]
          http://www.talsystems.com

          Comment


          • #6
            Good point made by OP, but there is rather a lot of SQlite code already in the forums, would you want it all moved?

            A SQLite forum would be a Good Thing IMO. Mixing SQLite with other SQL RDBMSs will only attract off-topic comments from people who have no intention of ever learning:

            a) Sqlite's flavour of SQL
            b) the difference between a personal database and a client/server database

            A Database forum with sub-forums for SQlite, Oracle, SQL Server, etc etc would be just the ticket.

            Comment


            • #7
              Sorry, but I somehow missed what the content of this thread was about until just now.

              A Database Forum can easily be done, but I'd have to go through the 962 threads that contain "sql" and judge which ones should be moved, and which ones just have "sql" in them just as some passing comment.

              If we could get a reasonable number of folks to weigh in with a positive response on the idea, I'll be happy to make the new forum, go through the threads and make the appropriate moves.

              I'd generally rather not do subforums, but I've no strong feelings on it either way.
              Last edited by Gary Beene; 7 Sep 2015, 02:57 PM.

              Comment


              • #8
                I think a "SQLite forum" is too niche.

                A generic "Database Programming" forum would be much more beneficial as it encompasses the subject as a whole and not just one particular flavor. I know in my day to day work I relate to MySQL, MSSQL, Oracle, in addition to SQLite.

                I can understand Gary not wanting to do sub-fora but if it was JUST a single forum it has to be more generic. If sub-fora are an option then I would go with that as well to help split the flavors. Perhaps one master one on techniques in general, and then others on the flavors.
                Last edited by George Bleck; 7 Sep 2015, 04:10 PM.
                <b>George W. Bleck</b>
                <img src='http://www.blecktech.com/myemail.gif'>

                Comment


                • #9
                  There have been requests for a GRAPHIC forum, and I would rather that than a database forum, considering that the GRAPHIC statements and functions are many and much used in both compilers.
                  Rod
                  I want not 'not', not Knot, not Knott, not Nott, not knot, not naught, not nought, but aught.

                  Comment


                  • #10
                    Hi Rodney,
                    Yes, I also have wished we'd created a Graphics forum way back when. Right now, with about 3962 posts containing the word Graphic, that's a ton of filtering I'd have to do. Not that we couldn't decide to leave everything as is, but with a forum in place, the temptation would be there!

                    And, there's nothing to keep us from having both.

                    I've gotten feedback both ways - too many forums now vs still needing a few more.

                    Comment


                    • #11
                      I think only the GRAPHIC threads from the release of PBWin10 and PBCC6 would be sufficient, still lots though.

                      There are getting to be a lot of different fora, perhaps we could each have one of our own instead?!
                      Rod
                      I want not 'not', not Knot, not Knott, not Nott, not knot, not naught, not nought, but aught.

                      Comment


                      • #12
                        Originally posted by Gary Beene View Post
                        I've gotten feedback both ways - too many forums now vs still needing a few more.
                        For casual users of the forums - I'm one of them - better indexing saves time, providing that stuff gets posted where it oughta. For the dwindling band of PB forum loyalists who read every post, more forums means more clicks with those durn new pointy clicky mouse things, so fewer forums is the way forward!

                        Like Rodney, I like the idea of a GRAPHIC forum, and have called for one to be provided. Unlike Rodney, but like many thousands of coders worldwide, I spend a fair amount of time working with SQLite on various platforms. Having a SQlite-only sub-forum would be of value, and might also bring in a bit of footfall from people searching for SQLite answers who are not yet acquainted with PowerBASIC.

                        Either way it is more work for Gary, but I suspect that he loves the stuff.

                        Comment


                        • #13
                          Something everyone is enable to do... add keywords to any thread.

                          Maybe "SQLite" and "Database Programming" ... as any thread may have multiple keywords.

                          Users would have to train themselves to use the keyword search more, but
                          A) allows for "multiple areas of interest" per thread
                          B) requires zero "forum administration" - no subforum creation, no thread-finding and no thread-moving.
                          C) Everyone could 'do something' to help.

                          I think we'd have to agree on exactly which keywords would be the "magic" keywords (eg you don't want both "DBMS" and "database" , you'd want to agree on one) but using keywords might be a relatively quick and low cost solution.

                          MCM
                          Michael Mattias
                          Tal Systems Inc. (retired)
                          Racine WI USA
                          [email protected]
                          http://www.talsystems.com

                          Comment


                          • #14
                            Originally posted by Gary Beene View Post
                            ...
                            I've gotten feedback both ways - too many forums now vs still needing a few more.
                            I'm currently developing an app using SQLite/SQlitening. I've often had questions about the SQL itself and didn't feel like there was any appropriate venue to ask about them here in the PB forums.

                            I would find a Database programming forum very helpful - especially if you add some optional thread prefixes for the forum for different db platforms (SQLite / Oracle / etc.).
                            Bernard Ertl
                            InterPlan Systems

                            Comment


                            • #15
                              Originally posted by Michael Mattias View Post
                              ... using keywords might be a relatively quick and low cost solution.
                              ...yes, quick, low cost and second rate. We deserve better.

                              Comment


                              • #16
                                I like the idea of a single database forum, but not a sub forum for all possible kinds of databases. If we had very large numbers of posters, it might make more sense. But with as few posts as we have these days, I'd think a single database forum would suffice.

                                In lieu of the multiple sub forums, I like this suggestion ...
                                ...thread prefixes for the forum for different db platforms (SQLite / Oracle / etc.
                                ... but I've just been looking and don't see how to add thread Prefix options as is now done in the Source Code forum.

                                As soon as I can find how to add the prefixes, I'll add a new Database forum.

                                If anyone would like to volunteer some information for a sticky thread introduction to the new forum, please just post it online and I'll extract content from the submittals to create the sticky/intro thread. I don't use databases that much, so I could use the suggestions. If you'd rather, you can send it to me at [email protected].

                                A summary/overview of the primary database technologies suitable for use with PowerBASIC would be good to include in the forum introduction, as would a very simple compilable example using each technology.

                                Comment


                                • #17
                                  Originally posted by Gary Beene View Post
                                  As soon as I can find how to add the prefixes, I'll add a new Database forum.
                                  Gary for Governor!

                                  Comment


                                  • #18
                                    Originally posted by Gary Beene View Post
                                    If anyone would like to volunteer some information for a sticky thread introduction to the new forum, please just post it online and I'll extract content from the submittals to create the sticky/intro thread.
                                    On the subject of SQLite, you can't beat the authors comments:

                                    SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed database engine in the world. The source code for SQLite is in the public domain.
                                    To these I would add my own:
                                    SQLite is a brilliant PERSONAL database. It is not good at multiple users. You can deploy it in native mode just by copying a DLL to the same place as your EXE, and a tiny #INCLUDE file or a few inline declarations will give you access to its essential functions. There are MANY PowerBASIC examples to refer to.

                                    Comment


                                    • #19
                                      Originally posted by Gary Beene View Post
                                      ...
                                      As soon as I can find how to add the prefixes, I'll add a new Database forum.
                                      ...
                                      In the Admin Control Panel's left hand menu there is a "Thread Prefixes" option (a little above the Users option). You can create a prefix set and assign it to a forum (or forums). You can then create the individual prefixes for the set.

                                      Edit: Chris - SQLite works just fine for multiple users if you use the open source PowerBASIC based SQLitening client/server wrapper.
                                      Last edited by Bern Ertl; 28 Sep 2015, 08:05 AM.
                                      Bernard Ertl
                                      InterPlan Systems

                                      Comment


                                      • #20
                                        Originally posted by Bern Ertl View Post
                                        SQLite works just fine for multiple users if you use the open source PowerBASIC based SQLitening client/server wrapper.
                                        That is part of the SQLitening story, not the SQlite story.

                                        Comment

                                        Working...
                                        X