Share My Creation ChatAbox web creator and server

chatabox_front.jpg

Hi all,
Something I have been working on for ages.
This website chatabox.zapto.org is running from home.
The speed of my site is very slow. We are on satellite and can only get 25mB download and 5mB upload. Hopefully by the end of the year 'Starlink' will be available in our area.

It is running from an old laptop and a Raspberry Pi 400. (I mix and match)
The distro I use is Dietpi 64bit. I have haproxy (an overkill but handy for letsEncrypt) and NoIp to create my name.
The server is a b4j app. Events are all driven from mqtt events. e.g. temperature, images etc.
The admin page is running on a separate server area so you cannot login to this area from outside.
All page design is done in the admin area. Pages and design can be edited and previewed before committing to go live.
The database can either be mySql or Sqlite3.
The software will be free to anyone who wants it. I am still beta testing it so this will be soon.
If anyone wants a copy just go to the contact area and leave me a message.
Tom
 

TomDuncan

Active Member
Licensed User
Longtime User
Small update to the building of html pages if you have moved the www folder to a different location.
Change this. Note the location change in the writeString code.

B4X:
Sub UpdateAllHtmlFiles(locale As String)
    Dim query As String = "select id, page_name FROM pages GROUP BY page_name ORDER BY id"
    Dim divs As List = sql_routines.ExecuteMemoryTable(query)
    If divs.Size>0 Then
        For z = 0 To divs.Size-1
            Dim mu() As String
            mu = divs.Get(z)
            Dim pg As String = mu(1)
            Dim body As String = buildpage.Build_auto(pg)
            File.WriteString(Main.wwwFolder,  locale & pg, body)
        Next
    End If
End Sub

Tom
 
Top