Announcement

Collapse
No announcement yet.

SQLitening PBforum.db

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

  • SQLitening PBforum.db

    I’ve used SQLite many times over the years wherever/whenever it has made sense. On my todo list for those same “many” years...has been to checkout SQLitening. I’ve finally done that.

    Mike Doty Special thanks for getting me started with how to “serve” the database and also several code examples of using SQLitening posted here on the forum.
    Gary Beene for posting gbBuilder which is the example code I used for collecting database contents.

    Database connection information is in the examples below...

    Database Info:
    Click image for larger version  Name:	7EFE635C-41AA-4DEA-9F4A-2AF2CF2903F0.png Views:	0 Size:	202.1 KB ID:	797299
    Example:
    Code:
    #BREAK         ON
    #COMPILE       EXE
    #COMPILER      PBCC 6
    #CONSOLE       ON
    #DEBUG DISPLAY ON
    #DEBUG ERROR   ON
    #DIM           ALL
    #OPTIMIZE      SPEED
    #OPTION        VERSION5
    #REGISTER      NONE
    #TOOLS         ON
    
    #INCLUDE ONCE "C:\SQLitening\inc\SQLitening.inc"
    
    FUNCTION PBMAIN() AS LONG
    
       LOCAL sSQL AS STRING
       LOCAL sForumName AS STRING
       LOCAL dwRowCount AS DWORD
       LOCAL dwForumThreadCount AS DWORD
       LOCAL dwForumPostCount AS DWORD
       LOCAL dwGT_ForumThreadCount AS DWORD
       LOCAL dwGT_ForumPostCount AS DWORD
    
       sSQL = "SELECT T1.Name, "                                                 + _
              "       COUNT(DISTINCT T3.Thread_Link), "                          + _
              "       COUNT(T3.PostNumber) "                                     + _
              "  FROM Forums T1 "                                                + _
              "       LEFT OUTER JOIN Threads T2 "                               + _
              "                    ON T2.ThreadNumber = T3.Thread_Link "         + _
              "       LEFT OUTER JOIN ThreadContent T3 "                         + _
              "                    ON T2.ThreadNumber = T3.Thread_Link "         + _
              "                   AND T2.Forum_Link = T1.RowID "                 + _
              " GROUP BY T1.Name "                                               + _
              " ORDER BY T1.Name ASC;"
    
       slConnect "38.17.54.213",51234
       slOpen "PBforum\PBforum.db" + $BS + "Read%Only", "R"  '1 open with read-only password
       slSel sSQL
    
       DO WHILE slGetRow
    
          sForumName         = slF(1)
          dwForumThreadCount = VAL(slF(2))
          dwForumPostCount   = VAL(slF(3))
    
          INCR dwRowCount
          dwGT_ForumThreadCount += dwForumThreadCount
          dwGT_ForumPostCount   += dwForumPostCount
    
          CON.STDOUT LSET$(sForumName,40) + "   " + FORMAT$(dwForumThreadCount,"#,") + "/" + FORMAT$(dwForumPostCount,"#,")
    
       LOOP
    
       CON.STDOUT "Forums: " + FORMAT$(dwRowCount,"#,") + "   Total Threads: " + FORMAT$(dwGT_ForumThreadCount,"#,") + "   Total Posts: " + FORMAT$(dwGT_ForumPostCount,"#,")
    
       slDisconnect
       slClose
    
    END FUNCTION
    Result:
    Code:
    2016 Web Site and Forum Upgrades           99/687
    About the Community Forums                 39/397
    COM Programming                            54/394
    CW - 3D Printing                           8/19
    CW - Discussion Corner                     13/67
    CW - Online Video Resources                4/5
    CW - Project Centennial                    1/12
    CW - The Internet of Things                2/32
    CW - Windows 10 and Beyond                 9/33
    CW - Windows Tablets & Devices             1/5
    DDT Programming                            348/4,202
    Frequently Asked Questions                 3/3
    Graphics Tools by Perfect Sync             2/42
    Hardware Available/Wanted                  4/14
    Hardware, Software, OS, Networking...      133/1,186
    José's Corner - Discussion                 142/1,201
    José's Corner - Downloads                  24/145
    José's Corner - Source Code                63/1,188
    My Favorite API                            48/159
    Online Help and Commentary                 1/8
    PB Inline Assembler                        277/2,333
    PB/CC Online Help & Commentary             1,082/1,304
    PB/CC Sample Programs                      33/42
    PB/Win Online Help & Commentary            1,204/1,956
    PB/Win Sample Programs                     73/92
    PluriBASIC                                 29/145
    PowerBase                                  19/35
    PowerBASIC Console Compiler                4,343/37,875
    PowerBASIC for DOS                         1,681/11,075
    PowerBASIC for Windows                     19,682/179,675
    Product Announcements                      0/0
    Programmers & Consultants Available        2/11
    Programming                                8,800/82,042
    Programming MS Office                      159/1,242
    Programming OpenGL                         120/994
    Programming the Internet                   1,590/11,372
    Sample Code (included w/ compilers)        2/2
    SDK Programming                            146/1,837
    Social Forums                              39/536
    Source Code Library                        4,599/11,249
    SQL Tools by Perfect Sync                  53/588
    Test Forums                                43/184
    Third-Party Forums                         4,778/37,806
    Using the Forums                           80/518
    VB Conversion                              17/252
    VB Converter                               52/910
    Working with Objects                       556/4,950
    Forums: 47   Total Threads: 50,457   Total Posts: 398,824
    Example:
    Code:
    #BREAK         ON
    #COMPILE       EXE
    #COMPILER      PBCC 6
    #CONSOLE       ON
    #DEBUG DISPLAY ON
    #DEBUG ERROR   ON
    #DIM           ALL
    #OPTIMIZE      SPEED
    #OPTION        VERSION5
    #REGISTER      NONE
    #TOOLS         ON
    
    #INCLUDE ONCE "C:\SQLitening\inc\SQLitening.inc"
    
    FUNCTION PBMAIN() AS LONG
    
       LOCAL sSQL AS STRING
       LOCAL sForumName AS STRING
       LOCAL sTitle AS STRING
       LOCAL sAuthor AS STRING
       LOCAL dwRowCount AS DWORD
       LOCAL dwThread_Link AS DWORD
       LOCAL dwPostNumber  AS DWORD
    
       IF COMMAND$ = "" THEN
          CON.STDERR "Please enter search text following program name"
          EXIT FUNCTION
       END IF
    
       sSQL = "SELECT T1.Thread_Link, "                                          + _
              "       T1.PostNumber, "                                           + _
              "       T3.Name, "                                                 + _
              "       T3.ForumURL, "                                             + _
              "       T2.ThreadURL, "                                            + _
              "       T2.ThreadTitle, "                                          + _
              "       T4.Author, "                                               + _
              "       T1.PostDate, "                                             + _
              "       T1.PostContent "                                           + _
              "  FROM ThreadContent T1 "                                         + _
              "       LEFT OUTER JOIN Threads T2 "                               + _
              "                    ON T2.ThreadNumber = T1.Thread_Link "         + _
              "       LEFT OUTER JOIN Forums T3 "                                + _
              "                    ON T2.ThreadNumber = T1.Thread_Link "         + _
              "                   AND T2.Forum_Link = T3.RowID "                 + _
              "       LEFT OUTER JOIN ForumAuthors T4 "                          + _
              "                    ON T1.Author_Link = T4.RowID "                + _
              "WHERE T2.ThreadTitle LIKE '%" + COMMAND$ + "%' "                  + _
              "   OR T1.PostContent LIKE '%" + COMMAND$ + "%' "                  + _
              "ORDER BY T1.Thread_Link ASC, T1.PostNumber ASC;"
    
       slConnect "38.17.54.213",51234
       slOpen "PBforum\PBforum.db" + $BS + "Read%Only", "R"  '1 open with read-only password
       slSel sSQL
    
       DO WHILE slGetRow
    
          INCR dwRowCount
          dwThread_Link = VAL(slF(1))
          dwPostNumber  = VAL(slF(2))
          sForumName    = slF(3)
          sTitle        = slF(6)
          sAuthor       = slF(7)
    
          CON.STDOUT RSET$(FORMAT$(dwThread_Link),10) + " " + RSET$(FORMAT$(dwPostNumber),10) + " " + _
                     LSET$(sForumName,25) + " " + LSET$(sTitle,45) + " " + sAuthor
    
       LOOP
    
       CON.STDOUT "Rows returned: " + FORMAT$(dwRowCount)
    
       slDisconnect
       slClose
    
    END FUNCTION
    "SQLitening" as search string
    Result:
    Code:
         12119     526680 PowerBASIC for Windows    Display records in a listbox                  Fredrick Ughimi
         21754     472419 Programming               Work with TAB delimited instead of CSV delimi Mike Doty
         22525     495925 Programming               Day of week for Jan 1st?                      David L Morris
         22525     495930 Programming               Day of week for Jan 1st?                      Michael Mattias
         23567     756624 Source Code Library       String compressor/decompressor                Mike Doty
         26365     476000 Third-Party Forums        Btrieve problem fixed in 6.15.451.79          Mike Doty
         37090     460515 Third-Party Forums        SQLite3 Client/Server                         Paul Squires
         39110     455287 Third-Party Forums        SQLighting                                    Paul Squires
         39110     455298 Third-Party Forums        SQLighting                                    Joe Byrne
         39110     455318 Third-Party Forums        SQLighting                                    Chris Holbrook
         39110     455351 Third-Party Forums        SQLighting                                    Chris Holbrook
         39110     455359 Third-Party Forums        SQLighting                                    Martin Francom
         39110     455360 Third-Party Forums        SQLighting                                    Paul Squires
         39338      39338 Third-Party Forums        SQLitening Database (local and client/server) Paul Squires
         39338     459876 Third-Party Forums        SQLitening Database (local and client/server) Joe Byrne
         39338     459895 Third-Party Forums        SQLitening Database (local and client/server) Elias Montoya
         39338     460034 Third-Party Forums        SQLitening Database (local and client/server) Paul Squires
         39521     461241 PowerBASIC for Windows    need advice on CGI for PBwin                  Mike Doty
         39543      39543 Third-Party Forums        New Freeware App for PB Developers            Joe Byrne
         39543     461248 Third-Party Forums        New Freeware App for PB Developers            Eddy Van Esch
         39543     461249 Third-Party Forums        New Freeware App for PB Developers            Eddy Van Esch
         39543     461250 Third-Party Forums        New Freeware App for PB Developers            Joe Byrne
         39543     461252 Third-Party Forums        New Freeware App for PB Developers            Joe Byrne
         39543     462880 Third-Party Forums        New Freeware App for PB Developers            Joe Byrne
         39543     462892 Third-Party Forums        New Freeware App for PB Developers            Paul Squires
         39543     462930 Third-Party Forums        New Freeware App for PB Developers            Joe Byrne
         39754     463083 Programming               Is SQL Lite robust enough?                    Paul Squires
         39824     463743 PowerBASIC for Windows    Control gets old clicks when enabled -flush b Mike Doty
         39835     463932 PowerBASIC for Windows    "1/10 second" rule                            Mike Doty
         39857      39857 Third-Party Forums        Kudos to MLG                                  Joe Byrne
         39889     464476 PowerBASIC for Windows    PB DLL wants dynamic string BYVAL             Mike Doty
         39889     464499 PowerBASIC for Windows    PB DLL wants dynamic string BYVAL             Paul Squires
         39889     464554 PowerBASIC for Windows    PB DLL wants dynamic string BYVAL             Mike Doty
         39889     467625 PowerBASIC for Windows    PB DLL wants dynamic string BYVAL             John Petty
         39889     467677 PowerBASIC for Windows    PB DLL wants dynamic string BYVAL             Mike Doty
         39889     467690 PowerBASIC for Windows    PB DLL wants dynamic string BYVAL             John Petty
         39993     468096 Third-Party Forums        Timm Motl / Tsunami....where are you??        Joe Byrne
         39993     468109 Third-Party Forums        Timm Motl / Tsunami....where are you??        Gary Stout
         39993     468116 Third-Party Forums        Timm Motl / Tsunami....where are you??        Joe Byrne
         40052     468775 Programming the Internet  1 connection per client                       Mike Doty
         40630      40630 Third-Party Forums        SQLitening Database System 1.11 (January 18,  Paul Squires
         40630     477208 Third-Party Forums        SQLitening Database System 1.11 (January 18,  Volker Butzlaff
         40630     477705 Third-Party Forums        SQLitening Database System 1.11 (January 18,  Scott Slater
         40630     477731 Third-Party Forums        SQLitening Database System 1.11 (January 18,  Fred H Meier
         40630     477762 Third-Party Forums        SQLitening Database System 1.11 (January 18,  Scott Slater
         40641     477036 PowerBASIC for Windows    Shared File Access                            Heinz Salomon
         40768     477998 Programming the Internet  New to Web Development                        Mike Doty
         41031     480024 Third-Party Forums        Possible new open-source pb library           Bern Ertl
         41391     486287 Programming               SQL challenge/problem                         Bern Ertl
         41391     486390 Programming               SQL challenge/problem                         Bern Ertl
         41552     486663 Programming               Programmer Tools - what do you really use?    Paul Squires
         41552     486672 Programming               Programmer Tools - what do you really use?    Joe Byrne
         41636     487403 Programming               Web based application???                      Joe Byrne
         41698     487745 Third-Party Forums        Any thoughts on Tsunami?                      Joe Byrne
         41698     487761 Third-Party Forums        Any thoughts on Tsunami?                      Bern Ertl
         41698     487770 Third-Party Forums        Any thoughts on Tsunami?                      Mike Doty
         41698     487773 Third-Party Forums        Any thoughts on Tsunami?                      Paul Squires
         41698     487792 Third-Party Forums        Any thoughts on Tsunami?                      Paul Squires
         41838     488991 Programming               help creating sql statement                   Paul Squires
         42264     494732 Programming the Internet  Home brewed tcp server supporting soap?       Mike Doty
         42536     496808 PowerBASIC for Windows    Database access                               Volker Butzlaff
         42573     500526 PowerBASIC for Windows    Fast and very robust database server          Paul Squires
         42665     500853 Third-Party Forums        SQLite Forums suggestions                     Gary Stout
         42665     500856 Third-Party Forums        SQLite Forums suggestions                     Douglas C. Horner
         42680     501022 Third-Party Forums        Open Database discussion/suggestion           Douglas C. Horner
         42680     501032 Third-Party Forums        Open Database discussion/suggestion           Paul Squires
         42680     501044 Third-Party Forums        Open Database discussion/suggestion           Christopher Carroll
         42680     501086 Third-Party Forums        Open Database discussion/suggestion           Douglas C. Horner
         43034      43034 Source Code Library       Sample SQLite/SQLitening Address Book project Martin Francom
         43036      43036 Programming               SQLite/SQLitening Programming                 Martin Francom
         43036     586998 Programming               SQLite/SQLitening Programming                 Hubert Brandel
         43036     587001 Programming               SQLite/SQLitening Programming                 Mike Doty
         43036     587003 Programming               SQLite/SQLitening Programming                 Volker Butzlaff
         43036     587012 Programming               SQLite/SQLitening Programming                 Chris Holbrook
         43036     587360 Programming               SQLite/SQLitening Programming                 Steve Pardoe
         43036     587366 Programming               SQLite/SQLitening Programming                 Bob Houle
         43036     587397 Programming               SQLite/SQLitening Programming                 Steve Pardoe
         44122     518937 PowerBASIC for Windows    Memory/Listbox ?                              Jaime de los Hoyos
         44122     518938 PowerBASIC for Windows    Memory/Listbox ?                              Bern Ertl
         44122     518943 PowerBASIC for Windows    Memory/Listbox ?                              Chris Holbrook
         44122     518960 PowerBASIC for Windows    Memory/Listbox ?                              Jaime de los Hoyos
         44122     518982 PowerBASIC for Windows    Memory/Listbox ?                              Bern Ertl
         44122     518983 PowerBASIC for Windows    Memory/Listbox ?                              Jaime de los Hoyos
         44122     518984 PowerBASIC for Windows    Memory/Listbox ?                              Chris Holbrook
         44327      44327 Source Code Library       SQLite3                                       Rick Kelly
         45253     534363 PowerBASIC Console Compil sqlite eof, bof, auto increment               Gary Stout
         46696      46696 Third-Party Forums        Using MLG_GetEx & SQLitening                  Fredrick Ughimi
         46948     566519 PowerBASIC for Windows    compiling sqlite3 dll with r*tree extenstion  Dean Gwilliam
         47110     551325 Programming               Maybe dumb SQLite question                    George Deluca
         47200     552156 Programming               Organizing Product Data                       Scott Slater
         47867     561564 PowerBASIC for Windows    Client-Server with EClient.bas and EchoServ.b Scott Slater
         48702     574164 Programming               ...but I only want the last record inserted   Dean Gwilliam
         48702     574218 Programming               ...but I only want the last record inserted   Dean Gwilliam
         48702     574295 Programming               ...but I only want the last record inserted   Chris Holbrook
         48702     574296 Programming               ...but I only want the last record inserted   Dean Gwilliam
         48738     574434 Third-Party Forums        MLG 1.18 is ready for download                Volker Butzlaff
         48774     574728 Programming               database table locked error                   Dean Gwilliam
         48774     574733 Programming               database table locked error                   Stuart McLachlan
         48774     574738 Programming               database table locked error                   Dean Gwilliam
         49504     591779 Third-Party Forums        EZGUI 5.0 - a tool for professionals - meets  Mike Doty
         49554     584231 Programming               Web vs Standalone apps                        Mike Doty
         50548     595498 PowerBASIC for Windows    Network experts needed                        Scott Slater
         50565     595773 Third-Party Forums        Code Generator                                Mike Doty
         50669     780022 Programming               SQLite Query Object and PB Win 8 example      Mike Doty
         50669     780045 Programming               SQLite Query Object and PB Win 8 example      John Montenigro
         50669     780076 Programming               SQLite Query Object and PB Win 8 example      Chris Holbrook
         50669     780090 Programming               SQLite Query Object and PB Win 8 example      Mike Doty
         50671     599844 Third-Party Forums        Hobby Programmer Week at Computer Workshop !  Martin Francom
         50690     599965 Programming the Internet  Moving my application to the web              Stuart McLachlan
         50700     610304 Third-Party Forums        Sqlite Object - object approach for accessing Martin Francom
         51615     761073 Programming               Comments re TLC for your passwords            Mike Doty
         51888     688723 Third-Party Forums        PTree still around ?                          Gary Stout
         52748     748156 PowerBASIC for Windows    SQLite COM Wrapper dhSQLite                   Mike Doty
         52748     790039 PowerBASIC for Windows    SQLite COM Wrapper dhSQLite                   Mike Doty
         52750     625521 Third-Party Forums        Cheetah Database & MoveFirst                  Paul Squires
         52750     626529 Third-Party Forums        Cheetah Database & MoveFirst                  Andrea Mariani
         52792      52792 PowerBASIC for Windows    PowerBasic and Cloud Computing                Fredrick Ughimi
         52874     626528 Programming               App-Access/SQLTools - or whats better?        Andrea Mariani
         52874     626560 Programming               App-Access/SQLTools - or whats better?        Jerry Novak
         53140     631840 PowerBASIC for Windows    gbTextDB - Database Engine (Discussion)       Mike Doty
         53140     631841 PowerBASIC for Windows    gbTextDB - Database Engine (Discussion)       Gary Beene
         53140     631842 PowerBASIC for Windows    gbTextDB - Database Engine (Discussion)       Mike Doty
         53862     641553 PowerBASIC for Windows    Array processing                              Mike Doty
         54048     643268 Working with Objects      using a collection like a database table      Mike Doty
         54092     643661 Third-Party Forums        Transiton from Random Access Files to a Datab Mike Doty
         54092     643663 Third-Party Forums        Transiton from Random Access Files to a Datab Chris Holbrook
         54092     643665 Third-Party Forums        Transiton from Random Access Files to a Datab Mike Doty
         54257     644791 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Dan Campbell
         54257     644811 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Mike Doty
         54257     644813 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Dan Campbell
         54257     644815 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Chris Holbrook
         54257     644835 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Mike Doty
         54257     644983 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Edwin Knoppert
         54257     644985 PowerBASIC Console Compil PBCC Console Editor alternatives, and sqlite  Chris Holbrook
         54263      54263 Programming               Threaded function sleeping?                   Bern Ertl
         54263     644845 Programming               Threaded function sleeping?                   Bern Ertl
         54873      54873 Source Code Library       Save/display files into SQLitening database   Mike Doty
         54873     653013 Source Code Library       Save/display files into SQLitening database   Mike Doty
         54874      54874 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653011 PowerBASIC for Windows    Save/display files into SQLitening database d Gary Beene
         54874     653012 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653016 PowerBASIC for Windows    Save/display files into SQLitening database d Michael Mattias
         54874     653019 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653020 PowerBASIC for Windows    Save/display files into SQLitening database d Michael Mattias
         54874     653029 PowerBASIC for Windows    Save/display files into SQLitening database d Gary Beene
         54874     653030 PowerBASIC for Windows    Save/display files into SQLitening database d Paul Squires
         54874     653033 PowerBASIC for Windows    Save/display files into SQLitening database d Gary Beene
         54874     653034 PowerBASIC for Windows    Save/display files into SQLitening database d Chris Holbrook
         54874     653046 PowerBASIC for Windows    Save/display files into SQLitening database d Michael Mattias
         54874     653055 PowerBASIC for Windows    Save/display files into SQLitening database d Paul Squires
         54874     653114 PowerBASIC for Windows    Save/display files into SQLitening database d Chris Holbrook
         54874     653119 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653121 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653150 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653154 PowerBASIC for Windows    Save/display files into SQLitening database d Chris Holbrook
         54874     653155 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653162 PowerBASIC for Windows    Save/display files into SQLitening database d Mike Doty
         54874     653167 PowerBASIC for Windows    Save/display files into SQLitening database d Chris Holbrook
         54912     656239 Programming               Call a PB function in a DLL from C (load-time Mike Doty
         54912     656265 Programming               Call a PB function in a DLL from C (load-time jcfuller
         55685      55685 Third-Party Forums        PlanetSquires terminating PowerBASIC 3rd Part Paul Squires
         55685     667383 Third-Party Forums        PlanetSquires terminating PowerBASIC 3rd Part Dean Gwilliam
         55878     669379 Programming the Internet  Need some direction...                        Mike Doty
         55878     669383 Programming the Internet  Need some direction...                        Gary Stout
         55878     669389 Programming the Internet  Need some direction...                        Mike Doty
         56090     674568 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Mike Doty
         56090     675083 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Bern Ertl
         56090     675095 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Andrea Mariani
         56090     675143 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Bern Ertl
         56090     675156 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Chris Holbrook
         56090     675180 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Bern Ertl
         56090     675186 PowerBASIC for Windows    SQLite wrapper by Edwin Knoppert              Edwin Knoppert
         56128      56128 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675097 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Chris Holbrook
         56128     675100 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Andrea Mariani
         56128     675102 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675104 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675106 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Andrea Mariani
         56128     675107 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675108 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Andrea Mariani
         56128     675112 Third-Party Forums        SQLitening hangs after 53 connect/disconnects james klutho
         56128     675113 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675119 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Chris Holbrook
         56128     675139 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     675140 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     675145 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Paul Squires
         56128     675151 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Chris Holbrook
         56128     675195 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Jean-Pierre LEROY
         56128     675197 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Chris Holbrook
         56128     675198 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675204 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Andrea Mariani
         56128     675205 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675207 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     675208 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675209 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Chris Holbrook
         56128     675212 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675213 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Paul Purvis
         56128     675214 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675215 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Paul Purvis
         56128     675239 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     675257 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     675261 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     675262 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     717853 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     717857 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     717944 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     717990 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Bern Ertl
         56128     718054 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     718058 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Bern Ertl
         56128     718063 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     718162 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Mike Doty
         56128     718342 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56128     718346 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Bern Ertl
         56128     718368 Third-Party Forums        SQLitening hangs after 53 connect/disconnects Michael Mattias
         56312     676874 Programming               Is there such a thing?                        Mike Doty
         56373      56373 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677402 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677404 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677405 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677407 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677414 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677415 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Edwin Knoppert
         56373     677434 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677436 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Mike Doty
         56373     677440 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Chris Holbrook
         56373     677442 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Mike Doty
         56373     677464 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677473 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Larry Charlton
         56373     677474 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677480 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677481 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677482 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Edwin Knoppert
         56373     677487 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Mike Doty
         56373     677489 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Larry Charlton
         56373     677491 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677498 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677534 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56373     677535 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Edwin Knoppert
         56373     677555 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Mike Doty
         56373     677558 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Edwin Knoppert
         56373     677569 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Michael Mattias
         56373     677570 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Chris Holbrook
         56373     677630 Third-Party Forums        SQLite/SQLitening Question: The Like Operator Fredrick Ughimi
         56392     680584 Third-Party Forums        Convert Access to SQLite                      Chris Holbrook
         56392     680586 Third-Party Forums        Convert Access to SQLite                      Mike Doty
         56392     680673 Third-Party Forums        Convert Access to SQLite                      Mike Doty
         56392     680684 Third-Party Forums        Convert Access to SQLite                      Mike Doty
         56395     680647 PowerBASIC for Windows    Application Level Blocking                    Rolf Brandt
         56395     680669 PowerBASIC for Windows    Application Level Blocking                    Michael Mattias
         56395     680674 PowerBASIC for Windows    Application Level Blocking                    Mike Doty
         56395     680695 PowerBASIC for Windows    Application Level Blocking                    Mike Doty
         56412     680932 PowerBASIC for Windows    gbAnnotate - Add Text to Images               Mike Doty
         56471      56471 Programming               SQLite Question                               Gary Stout
         56471     681590 Programming               SQLite Question                               Chris Holbrook
         56471     681793 Programming               SQLite Question                               Michael Mattias
         56482     681675 Third-Party Forums        Make SQL Query Run Faster                     Edwin Knoppert
         56482     681710 Third-Party Forums        Make SQL Query Run Faster                     Chris Holbrook
         56482     681776 Third-Party Forums        Make SQL Query Run Faster                     Chris Holbrook
         60119     695655 Programming               SQLite3 Discussion                            Rick Kelly
         60221     696406 Third-Party Forums        Yet Another Payslip Report                    Mike Doty
         60221     696487 Third-Party Forums        Yet Another Payslip Report                    Mike Doty
         60250      60250 Third-Party Forums        SQLitening array processing                   Mike Doty
         60250     696488 Third-Party Forums        SQLitening array processing                   Mike Doty
         60250     696507 Third-Party Forums        SQLitening array processing                   Fredrick Ughimi
         60490      60490 Programming               Why no DIM ?                                  Dieter Mayr
         60490     701196 Programming               Why no DIM ?                                  Mike Doty
         60686      60686 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     703125 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     703133 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     703156 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     703161 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Chris Holbrook
         60686     703177 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     703196 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     703198 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     703199 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     703200 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     703211 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     709953 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     709956 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     709957 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     709958 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     709959 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     709962 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     709964 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     709966 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     709971 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Fredrick Ughimi
         60686     710037 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Mike Doty
         60686     710147 Third-Party Forums        SQLite/SQLitening Query - Three Tables        Michael Mattias
         60760      60760 Programming               Rijndael output                               Bern Ertl
         60760     703751 Programming               Rijndael output                               John Gleason
         60760     703791 Programming               Rijndael output                               Bern Ertl
         60760     703977 Programming               Rijndael output                               Bern Ertl
         60765      60765 Source Code Library       SQLitening quick starter                      Mike Doty
         60765     703868 Source Code Library       SQLitening quick starter                      Mike Doty
         60765     704901 Source Code Library       SQLitening quick starter                      Mike Doty
         60765     709751 Source Code Library       SQLitening quick starter                      Mike Doty
         60766      60766 Programming               SQLitening quick starter comments             Mike Doty
         60766     703800 Programming               SQLitening quick starter comments             Gary Beene
         60766     703867 Programming               SQLitening quick starter comments             Mike Doty
         60766     791943 Programming               SQLitening quick starter comments             Mike Doty
         60766     792382 Programming               SQLitening quick starter comments             Dave Biggs
         60766     792395 Programming               SQLitening quick starter comments             Mike Doty
         60766     792411 Programming               SQLitening quick starter comments             Dave Biggs
         60967     705574 Programming               Sqlite3 - How to use "Select Count" ?         Mike Doty
         60967     705576 Programming               Sqlite3 - How to use "Select Count" ?         Mike Doty
         60969     705789 Programming               Array Sort - 2M String Elements               Mike Doty
         61021     706275 Programming               SQLite: Select Max () returns wrong value     Mike Doty
         61066      61066 Programming the Internet  Computer name was resolving to 127.0.0.1 (loc Mike Doty
         61163     765580 Programming the Internet  TCP/IP communications with threads.           Mike Doty
         61218     712561 Using the Forums          SQLite Postings                               Bern Ertl
         61218     712564 Using the Forums          SQLite Postings                               Chris Holbrook
         61231     713222 PowerBASIC for Windows    Creating an encrypted Zip file                Mike Doty
         61266     711630 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     711636 Third-Party Forums        MLG Questions                                 Fredrick Ughimi
         61266     711641 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     713403 Third-Party Forums        MLG Questions                                 Fredrick Ughimi
         61266     713418 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     713425 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     713788 Third-Party Forums        MLG Questions                                 Fredrick Ughimi
         61266     713801 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     713812 Third-Party Forums        MLG Questions                                 Fredrick Ughimi
         61266     713829 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     714278 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     714484 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     775512 Third-Party Forums        MLG Questions                                 Fredrick Ughimi
         61266     775539 Third-Party Forums        MLG Questions                                 Mike Doty
         61266     775544 Third-Party Forums        MLG Questions                                 Fredrick Ughimi
         61309     712092 Programming               How to protect a PowerTree database with a Lo Fim Wästberg
         61315     712149 Third-Party Forums        Forming an SQL Statement with PB              Mike Doty
         61445     713191 Programming               How to use AES 254 with power basic ?         Mike Doty
         61445     713254 Programming               How to use AES 254 with power basic ?         David Roberts
         61445     713255 Programming               How to use AES 254 with power basic ?         Mike Doty
         61445     713260 Programming               How to use AES 254 with power basic ?         Mike Doty
         61445     713397 Programming               How to use AES 254 with power basic ?         Mike Doty
         61624      61624 José's Corner - Source Co SQLitening bug fixed in SQLiteningClient (sou Mike Doty
         61624     718163 José's Corner - Source Co SQLitening bug fixed in SQLiteningClient (sou Mike Doty
         61625      61625 Programming               SQLitening bug fixed (Discussion)             Mike Doty
         61625     718167 Programming               SQLitening bug fixed (Discussion)             Mike Doty
         62095     721603 PowerBASIC for Windows    Looking for a PB compression or Zip program   Mike Doty
        745085     748609 Programming               Help searching the forum...  And making a win Bern Ertl
        748924     749069 Hardware, Software, OS, N Win 10 Home  vs Win 10 Pro                    Mike Doty
        749970     749977 Programming               Programming Style Opinion Question - User-Def Chris Holbrook
        750574     750610 Programming               Random Strings and Numbers Discussion CSPRNG  Mike Doty
        752011     752190 Programming               VB.NET return string function                 Mike Doty
        752011     752260 Programming               VB.NET return string function                 Knuth Konrad
        755399     755406 Programming               Argon2 hash                                   Mike Doty
        756121     756137 SQL Tools by Perfect Sync ACCESS 2013 - Anybody got ODBC working?  OR F David Clarke
        756121     756168 SQL Tools by Perfect Sync ACCESS 2013 - Anybody got ODBC working?  OR F Michael Mattias
        757324     757540 Programming               Do loop in a thread + tcp receive + best way? Bern Ertl
        761091     761093 PowerBASIC for Windows    Question on concurrent accesses to files      Fim Wästberg
        761769     761769 Third-Party Forums        Embed Image in DDOC from SQLitening           Fredrick Ughimi
        761769     762675 Third-Party Forums        Embed Image in DDOC from SQLitening           Michael Mattias
        763302     763302 Programming               Securely run a remote program                 Mike Doty
        763302     763335 Programming               Securely run a remote program                 Mike Doty
        763302     763336 Programming               Securely run a remote program                 Mike Doty
        767197     767200 Programming               What has become of POWER TREE?                Fim Wästberg
        767197     767217 Programming               What has become of POWER TREE?                David Clarke
        767197     767277 Programming               What has become of POWER TREE?                Paul Squires
        768330     768330 PowerBASIC for Windows    PowerBasic to Android ?                       Fim Wästberg
        770964     771033 Programming               Two programs, one file                        Michael Mattias
        770964     771046 Programming               Two programs, one file                        Stuart McLachlan
        771303     771331 Programming               SQL and $SQ in text                           Mike Doty
        772215     772215 Programming the Internet  Server not accepting connections              Mike Doty
        772215     772287 Programming the Internet  Server not accepting connections              Knuth Konrad
        772306     772347 Programming the Internet  Web Server                                    Mike Doty
        772787     772792 Programming the Internet  In-memory html server                         Mike Doty
        774110     774110 Third-Party Forums        Sqlitening Local vs Remote connection         Ross Boyd
        774110     774114 Third-Party Forums        Sqlitening Local vs Remote connection         Ross Boyd
        777723     777723 PowerBASIC for Windows    sqlitening trigger                            david thain
        777723     777730 PowerBASIC for Windows    sqlitening trigger                            Ian Vincent
        777723     777747 PowerBASIC for Windows    sqlitening trigger                            Mike Doty
        777723     777748 PowerBASIC for Windows    sqlitening trigger                            Mike Doty
        777723     777749 PowerBASIC for Windows    sqlitening trigger                            Mike Doty
        777881     777890 PowerBASIC for Windows    Finding a specific record in Random Access Fi Mike Doty
        780226     780231 Programming               SQLite with $ColumnNames that do not exist    Mike Doty
        782089     782097 Programming               PBKeys files for the PB IDE                   John Montenigro
        782590     782632 About the Community Forum PB for Azure ??                               Mike Doty
        782667     782674 Programming               TCP NOTIFY returns a file handle BUT TCP READ Mike Doty
        782718     782743 PowerBASIC for Windows    Other user has progarm already open?          Mike Doty
        782893     782914 PowerBASIC for Windows    PB on Microsoft Azure Windows 10 Virtual mach Mike Doty
        782981     785133 PowerBASIC for Windows    Forum Traffic Levels                          Mike Doty
        783557     783782 PowerBASIC for Windows    SQLite Journey                                Mike Doty
        786664     786689 SQL Tools by Perfect Sync ODBC TEXT driver - syntax for SELECT using in John Montenigro
        786664     786705 SQL Tools by Perfect Sync ODBC TEXT driver - syntax for SELECT using in Stuart McLachlan
        789024     789042 Programming               Guidance needed for RDBMS setup               Mike Doty
        789024     789043 Programming               Guidance needed for RDBMS setup               Tim Lakinir
        789024     789046 Programming               Guidance needed for RDBMS setup               Mike Doty
        791523     791672 PowerBASIC for Windows    gbThreads v9 Release                          Mike Doty
        791523     791673 PowerBASIC for Windows    gbThreads v9 Release                          Mike Doty
        792127     792265 PowerBASIC for Windows    Help via a list box ?                         Fim Wästberg
        792127     792286 PowerBASIC for Windows    Help via a list box ?                         Mike Doty
        792270     792270 Source Code Library       RichEdit Help or other in a SQLite table      Mike Doty
        792374     792374 Source Code Library       SQLitening Virtual ListView                   Mike Doty
        792374     792844 Source Code Library       SQLitening Virtual ListView                   Mike Doty
        792375     792375 PowerBASIC for Windows    SQLitening Virtual ListView Comments and Sugg Mike Doty
        792375     792846 PowerBASIC for Windows    SQLitening Virtual ListView Comments and Sugg Mike Doty
        792375     792885 PowerBASIC for Windows    SQLitening Virtual ListView Comments and Sugg Dave Biggs
        792375     792887 PowerBASIC for Windows    SQLitening Virtual ListView Comments and Sugg Mike Doty
        792375     792888 PowerBASIC for Windows    SQLitening Virtual ListView Comments and Sugg Mike Doty
        792375     792892 PowerBASIC for Windows    SQLitening Virtual ListView Comments and Sugg Dave Biggs
        794415     794462 PowerBASIC for Windows    MLG License                                   Fim Wästberg
        794415     794467 PowerBASIC for Windows    MLG License                                   Stuart McLachlan
        795046     795046 PB/Win Online Help & Comm sqlitening                                    david thain
        795046     795067 PB/Win Online Help & Comm sqlitening                                    Mike Doty
        795046     795108 PB/Win Online Help & Comm sqlitening                                    Mike Doty
        795046     795922 PB/Win Online Help & Comm sqlitening                                    Michael Rice
        795046     796295 PB/Win Online Help & Comm sqlitening                                    david thain
        795046     796299 PB/Win Online Help & Comm sqlitening                                    Mike Doty
        795046     796533 PB/Win Online Help & Comm sqlitening                                    david thain
        795046     796542 PB/Win Online Help & Comm sqlitening                                    Mike Doty
        795109     795200 Programming               Funny Question - How would you CAUSE a memory Mike Doty
        795520     795520 Test Forums               never mind                                    Mike Doty
        796441     796634 Third-Party Forums        Can we install PB into a Windows server 2019? Albert Richheimer
        796441     796649 Third-Party Forums        Can we install PB into a Windows server 2019? Stuart McLachlan
        797298     797298 Programming               SQLitening PBforum.db                         Michael Rice
    Rows returned: 415

  • #2
    Click image for larger version  Name:	test.png Views:	0 Size:	21.6 KB ID:	797306

    Online working example using SQLitening over the internet (see post #1.)
    Very nice, Michael Rice!

    Code:
    #INCLUDE "SQLITENING.INC" 'https://forum.powerbasic.com/forum/USER-TO-USER-discussions/programming/797298-sqlitening-pbforum-DB
    
    FUNCTION PBMAIN() AS LONG
     LOCAL sb AS ISTRINGBUILDERA
     sb = CLASS "StringBuilderA"
     slConnect "38.17.54.213"
     slOpen "PBforum\PBforum.db" + $BS + "Read%Only", "R"  '1 open with read-only password
     sb.add "select 'Forums  '|| count(*)        From Forums         Union "
     sb.add "select 'Authors '|| count(*)        From ForumAuthors   Union "
     sb.add "select 'Threads '|| count(*)        From Threads        Union "
     sb.add "select 'ThreadContent '|| count(*)  From ThreadContent"
     ? GetRs(sb.string),,"Records in Tables"
    END FUNCTION
    
    FUNCTION GetRs(sSQL AS STRING) AS STRING
     LOCAL sArray() AS STRING
     slSelAry sSQL,sArray(),"Q9c"
     FUNCTION = JOIN$(sArray(),$CR)
    END FUNCTION
    How long is an idea? Write it down.

    Comment


    • #3
      Some forum Top 10 lists

      Top 10 topic activity:
      Code:
      #BREAK         ON
      #COMPILE       EXE
      #COMPILER      PBCC 6
      #CONSOLE       ON
      #DEBUG DISPLAY ON
      #DEBUG ERROR   ON
      #DIM           ALL
      #OPTIMIZE      SPEED
      #OPTION        VERSION5
      #REGISTER      NONE
      #TOOLS         ON
      
      #INCLUDE ONCE "C:\SQLitening\inc\SQLitening.inc"
      
      FUNCTION PBMAIN() AS LONG
      
         LOCAL sSQL AS STRING
         LOCAL sAuthor AS STRING
         LOCAL sForum AS STRING
         LOCAL sTitle AS STRING
         LOCAL dwPostCount AS DWORD
      
         sSQL = "SELECT T3.Name, "                                                 + _
                "       T2.ThreadTitle, "                                          + _
                "       COUNT(T1.PostNumber) "                                     + _
                "  FROM ThreadContent T1 "                                         + _
                "       LEFT OUTER JOIN Threads T2 "                               + _
                "                    ON T2.ThreadNumber = T1.Thread_Link "         + _
                "       LEFT OUTER JOIN Forums T3 "                                + _
                "                    ON T2.ThreadNumber = T1.Thread_Link "         + _
                "                   AND T2.Forum_Link = T3.RowID "                 + _
                " GROUP BY T1.Thread_Link "                                        + _
                " ORDER BY COUNT(T1.PostNumber) DESC "                             + _
                " LIMIT 10;"
      
         slConnect "38.17.54.213",51234
         slOpen "PBforum\PBforum.db" + $BS + "Read%Only", "R"  '1 open with read-only password
         slSel sSQL
      
         DO WHILE slGetRow
      
            sForum      = slF(1)
            sTitle      = slF(2)
            dwPostCount = VAL(slF(3))
      
            CON.STDOUT LSET$(sForum,30) + LSET$(sTitle,55) + RSET$(FORMAT$(dwPostCount,"#,"),6)
      
         LOOP
      
         slDisconnect
         slClose
      
      END FUNCTION
      Result:
      Code:
      PowerBASIC for Windows        PowerBASIC - You Speak...   PowerBASIC Listens!           975
      PowerBASIC for Windows        New Splash Screen for PB Site                             684
      PowerBASIC for Windows        Algorithms for combinations of 5 numbers in 50            589
      Third-Party Forums            A new IDE for PowerBASIC with enhanced project and debu   497
      PowerBASIC for Windows        PB/Win 10 & PB/CC 6 -- Questions? Comments?               473
      PowerBASIC Console Compiler   VAL rounds a variable                                     417
      Programming                   Rnd2 disscussion                                          345
      Third-Party Forums            JK-IDE Version 2.0 including Visual Designer V 1.0        283
      PowerBASIC for Windows        gbPrintPreview - Print Preview Include (Discussion)       279
      PowerBASIC for Windows        PowerBASIC - Breaking News from Venice Beach...           267

      Top 10 topic authors:
      Code:
      #BREAK         ON
      #COMPILE       EXE
      #COMPILER      PBCC 6
      #CONSOLE       ON
      #DEBUG DISPLAY ON
      #DEBUG ERROR   ON
      #DIM           ALL
      #OPTIMIZE      SPEED
      #OPTION        VERSION5
      #REGISTER      NONE
      #TOOLS         ON
      
      #INCLUDE ONCE "C:\SQLitening\inc\SQLitening.inc"
      
      FUNCTION PBMAIN() AS LONG
      
         LOCAL sSQL AS STRING
         LOCAL sAuthor AS STRING
         LOCAL dwPostCount AS DWORD
      
         sSQL = "SELECT T2.Author, "                                               + _
                "       COUNT(T1.Thread_Link) "                                    + _
                "  FROM ThreadContent T1 "                                         + _
                "       LEFT OUTER JOIN ForumAuthors T2 "                          + _
                "                    ON T1.Author_Link = T2.RowID "                + _
                " WHERE T1.Thread_Link = T1.PostNumber "                           + _
                " GROUP BY T1.Author_Link "                                        + _
                " ORDER BY COUNT(T1.Thread_Link) DESC "                            + _
                " LIMIT 10;"
      
         slConnect "38.17.54.213",51234
         slOpen "PBforum\PBforum.db" + $BS + "Read%Only", "R"  '1 open with read-only password
         slSel sSQL
      
         DO WHILE slGetRow
      
            sAuthor     = slF(1)
            dwPostCount = VAL(slF(2))
      
            CON.STDOUT LSET$(sAuthor,40) + RSET$(FORMAT$(dwPostCount,"#,"),8)
      
         LOOP
      
         slDisconnect
         slClose
      
      END FUNCTION
      Results:
      Code:
      Gary Beene                                 4,179
      Edwin Knoppert                             1,016
      Stephane Fonteyne                            851
      Mike Doty                                    839
      Cliff Nichols                                656
      Scott Turchin                                607
      Patrice Terrier                              603
      Chris Holbrook                               582
      David Clarke                                 566
      Wayne Diamond                                549
      Top 10 posters:
      Code:
      #BREAK         ON
      #COMPILE       EXE
      #COMPILER      PBCC 6
      #CONSOLE       ON
      #DEBUG DISPLAY ON
      #DEBUG ERROR   ON
      #DIM           ALL
      #OPTIMIZE      SPEED
      #OPTION        VERSION5
      #REGISTER      NONE
      #TOOLS         ON
      
      #INCLUDE ONCE "C:\SQLitening\inc\SQLitening.inc"
      
      FUNCTION PBMAIN() AS LONG
      
         LOCAL sSQL AS STRING
         LOCAL sAuthor AS STRING
         LOCAL dwPostCount AS DWORD
      
         sSQL = "SELECT T2.Author, "                                               + _
                "       COUNT(T1.PostNumber) "                                     + _
                "  FROM ThreadContent T1 "                                         + _
                "       LEFT OUTER JOIN ForumAuthors T2 "                          + _
                "                    ON T1.Author_Link = T2.RowID "                + _
                " GROUP BY T1.Author_Link "                                        + _
                " ORDER BY COUNT(T1.PostNumber) DESC "                             + _
                " LIMIT 10;"
      
         slConnect "38.17.54.213",51234
         slOpen "PBforum\PBforum.db" + $BS + "Read%Only", "R"  '1 open with read-only password
         slSel sSQL
      
         DO WHILE slGetRow
      
            sAuthor     = slF(1)
            dwPostCount = VAL(slF(2))
      
            CON.STDOUT LSET$(sAuthor,40) + RSET$(FORMAT$(dwPostCount,"#,"),8)
      
         LOOP
      
         slDisconnect
         slClose
      
      END FUNCTION
      Results:
      Code:
      Michael Mattias                           38,964
      Gary Beene                                16,820
      Lance Edmonds                             10,681
      Edwin Knoppert                             8,121
      Mike Doty                                  7,235
      Eric Pearson                               6,650
      Chris Holbrook                             6,628
      Borje Hagsten                              6,182
      José Roca                                  5,891
      Chris Boss                                 5,810

      Comment


      • #4
        PBforum.db Updated

        I've updated for the new "Databases/Database Programming" sub-forum that has recently been added.

        Another factoid that might be useful about that database is that all of the date/time fields are stored UTC

        Thank you Mike Doty for showing me my security issue with my initial setup...

        Comment


        • #5
          Welcome

          slDisconnect
          slClose

          Should be:
          slClose
          slDisconnect
          Last edited by Mike Doty; 7 Aug 2020, 04:39 AM.
          How long is an idea? Write it down.

          Comment


          • #6
            Another FYI: Currently the database stores a post as it is the first time it finds the post. If the post is later changed, those changes don't ever get reflected in the database. That is something that I will be changing and will post information here on the forum when that change has been implemented.

            Comment


            • #7
              Originally posted by Mike Doty View Post
              Welcome

              slDisconnect
              slClose

              Should be:
              slClose
              slDisconnect
              Good catch, thank you Mike for pointing that out. I updated all my example code on my dev machine, so hopefully my next posts will have those in the proper sequence.

              On a side note: I found my SQLiteing service non-responsive this morning. I tried to use the admin program to stop the service and that didn’t work. Used task manager to stop/start the service and all seems well at the moment. I’ll continue to keep an eye on the service.

              Comment


              • #8
                If I run from here get transmit error (18.)
                I am looking at server configuration for large recordsets.
                Sent you a private message.

                If I can download the database files I would also try finding the error here (without taking down the server.)
                This definitely needs to be fixed.
                How long is an idea? Write it down.

                Comment


                • #9
                  PBforum.db
                  Keywords?

                  Just a thought if someone is thinking about enhancements (and I know there are some).
                  Michael Mattias
                  Tal Systems Inc. (retired)
                  Racine WI USA
                  [email protected]
                  http://www.talsystems.com

                  Comment


                  • #10
                    Michael M.
                    Do other SQL's return recordsets to disk if they return a huge recordset?
                    Most PowerBASIC programs use a TCP receive loop, but I have never see a TCP send loop.
                    I have never processed a recordset over 120MB with SQLitening.

                    The records can easily be written to disk as received, but I got the transmiit error before reading the first record.
                    Not sure if a recordset could be sent to disk by the server and then read by the client using another method.

                    Michael R.
                    Very unlikely the problem, but please run slExe "Vacuum" on all databases.
                    How long is an idea? Write it down.

                    Comment


                    • #11
                      FYI. The database is approx 683MB

                      Comment


                      • #12
                        Originally posted by Michael Mattias View Post

                        Keywords?

                        Just a thought if someone is thinking about enhancements (and I know there are some).
                        HI Michael, meaning something that locates provided Keywords within forum tiles and post contents? I'm trying to wrap my head around your suggestion here. At this point we basically have this forum that can now be SQL queried and pulled into PB strings at will. Searching for keywords is only limited by our own abilities. So get your paintbrush out!! LOL
                        Did you see the one example I posted that will allow you to search for anything within the posting title or content? You key in search term from command line. That one is kinda fun to play with... Like what holiday is mentioned most?, what month of the year? For example searching: "Michael Mattias" appears in the title and/or body of 6,771 posts

                        Currently I'm having an issue with the service staying stable...but we are early on in the process. So I'll keep plugging away.

                        Comment


                        • #13
                          Michael R,
                          Everything is working fine, now.
                          Thanks for correcting the errors of my ways.

                          Don't like the idea that I could knock out the server.
                          I'll work on fixing that on the server. Feel free to beat me to it!
                          The missing slSel fixed it.
                          The added timeout was not needed.
                          The shell to $OutFile was also in error. Needed a space after "notepad.exe " and everything displays in notepad.
                          How long is an idea? Write it down.

                          Comment


                          • #14
                            MIke D, glad that fixed the issue. I have had that one query timeout on me, so you may find you need to bump the timeout value sometimes. My experience was that with default values it would (sometimes) fail. Changing the timeout value solved that. At some point if the database becomes/remains useful...it will need some well thought out indexes added...that may in turn fix some of the timeout issues.

                            "Don't like the idea that I could knock out the server." ... yeah that's not ideal on my end either. Let's keep working with it and see if we can find a way to eliminate that. It's all just hobby stuff...so no real worries. Everything else on server remained fine...just SQLitening went night night

                            Comment


                            • #15
                              Sounds good. If you don't mind, I'll send you a private message if it happens again.
                              How long is an idea? Write it down.

                              Comment


                              • #16
                                Originally posted by Mike Doty View Post
                                Sounds good. If you don't mind, I'll send you a private message if it happens again.
                                YES ... Please and Thanks!!

                                Comment


                                • #17
                                  The good news is that this went though the 399,165 records, 6,831,332 lines, just fine.
                                  No bad news.

                                  I couldn't open with notepad or wordpad, but my old basic file viewer worked great.

                                  Need to add some more error checking to SQLiteningServer.
                                  It is toward the top of my list of things to do. I will also reach out to Bern E.
                                  I don't see much activity on the SQLiteing site, too bad.

                                  I have eveything as text files. I guess you could call them dumps.

                                  Code:
                                  DO WHILE slGetRow
                                   INCR Counter
                                   FOR c = 1 TO cols  
                                     sColArray(c) = slf(c) + "!"
                                   NEXT
                                   PRINT #1, JOIN$(sColArray(),$CR)
                                   PRINT #1, USING$("-------------------- THIS IS THE END OF RECORD # --------------------",counter)
                                  LOOP
                                  How long is an idea? Write it down.

                                  Comment


                                  • #18
                                    Deleted (misread an earlier post)

                                    Comment


                                    • #19
                                      Do other SQL's return recordsets to disk if they return a huge recordset?
                                      The "recordset" is LOGICAL, not physical. How any DBMS and.or library handle it is proprietary.

                                      I am not an SqlIte user; but the only "recordset" with which I am familiar is that returned by MIcrosoft's ADO programming library. . If you want that logical object stored to disk you need to code it yourself.

                                      All that said, using disk as a place to store logical objects which might consume large amounts of RAM... well, that's pretty much the definition of "virtual memory! "

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

                                      Comment

                                      Working...
                                      X