Share My Creation [Web] [Project Template] Pakai Server v5.50

Update​
Pakai Server v6 is available​

Pakai Server​

Version 5.50

GitHub: https://github.com/pyhoon/pakai-server-b4j

Template (B4J)​

• Pakai Server (5.50) b4xtemplate (B4J)

Depends on​

• EndsMeet (v1.50) b4xlib (B4J)
• WebApiUtils (v5.50) b4xlib (B4J)
• MiniORMUtils (v3.80) b4xlib (B4X)
• sqlite-jdbc-3.7.2.jar
• mysql-connector-j-9.3.0.jar
• mariadb-java-client-3.5.6.jar

Tutorial​

• https://www.b4x.com/android/forum/threads/pakai-framework-v5.167796/

Reminder: Please do not post issue or question on this thread.
Always remember to start a new thread for any question and prefix with [Pakai].

 

[aeric]

Updated link to tutorial in post #1.

 

[JohnJ]

Pakai Server​

Version 5.00

GitHub: https://github.com/pyhoon/pakai-server-b4j

View attachment 165396

Template:

• Pakai Server (5.00).b4xtemplate

Depends on:

• EndsMeet.b4xlib (v1.10)
• WebApiUtils.b4xlib (v4.70)
• MiniORMUtils.b4xlib (v3.30)
• sqlite-jdbc-3.7.2.jar
• mysql-connector-java-8.0.30.jar

Tutorial:

• https://www.b4x.com/android/forum/threads/pakai-framework-v5.167796/

Reminder: Please do not post issue or question on this thread.
Always remember to start a new thread for any question and prefix with [Pakai].

Hi
I downloaded all of the files that you posted and copied them into the appropriate directories. However, when starting B4J and selecting File/New, the Pakai template does not show up. Other templates do show up though.
I'm looking forward to testing this out.
Nice work, I look at your posts quite often.
Keep up the good work.

Thanks
John

 

[aeric]

Hi
I downloaded all of the files that you posted and copied them into the appropriate directories. However, when starting B4J and selecting File/New, the Pakai template does not show up. Other templates do show up though.
I'm looking forward to testing this out.
Nice work, I look at your posts quite often.
Keep up the good work.

Thanks
John

Do you reopen the IDE after copy the template to additional library folder?
Maybe show your screenshot.

 

[JohnJ]

Do you reopen the IDE after copy the template to additional library folder?
Maybe show your screenshot.

Yes, I did reopen the IDE after copying the files into the Template folder.

 

[aeric]

I think you wrongly set the path.
Don't put the files inside a subfolder of Additional Libraries folder.
My setup is Additional Libraries and Project Templates share the same folder.

 

[JohnJ]

I think you wrongly set the path.
Don't put the files inside a subfolder of Additional Libraries folder.
My setup is Additional Libraries and Project Templates share the same folder.

That was the problem, thanks so much.

 

[aeric]

15/09/2025

• Template:
  • Pakai Server (5.10beta2).b4xtemplate
• Depends on:
  • EndsMeet.b4xlib (v1.10)
  • WebApiUtils.b4xlib (v5.10)
  • MiniORMUtils.b4xlib (v3.40)
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar (new)
  • mariadb-java-client-3.5.6.jar (new)

What's New:

• Support MariaDB
• WebApiUtils v5.10 provides Snippets for this version
• Added Database class (moved from Main module)
• Added JavaScript class (moved from Utility module)
• Separate config file for different database e.g. mariadb.ini
• Updated code for database operation
• Updated HelpHandler
• Updated libs.json

 

[aeric]

15/09/2025

• Template:
  • Pakai Server (5.10).b4xtemplate
• Depends on:
  • EndsMeet.b4xlib (v1.10)
  • WebApiUtils.b4xlib (v5.10)
  • MiniORMUtils.b4xlib (v3.50)
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar (new)
  • mariadb-java-client-3.5.6.jar (new)

What's New:

• Support MariaDB
• WebApiUtils v5.10 provides Snippets for this version
• Added Database class (moved from Main module)
• Added JavaScript class (moved from Utility module)
• Removed Utility class
• Separate config file for different database e.g. mariadb.ini
• Updated HelpHandler
• Updated libs.json
• Set DB.SQL = Main.DBOpen
• Set HRM.OrderedKeys = True
• Set HRM.ResponseObject = DB.First2
• Set HRM.ResponseData = DB.Results2
• Updated #AdditionalJars tags
• Added #Macro tags

 

[aeric]

17/09/2025

• Template:
  • Pakai Server (5.20).b4xtemplate
• Depends on:
  • EndsMeet.b4xlib (v1.20) - updated
  • WebApiUtils.b4xlib (v5.20) - updated
  • MiniORMUtils.b4xlib (v3.60) - updated
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar
  • mariadb-java-client-3.5.6.jar

What's New:

• Changed in constants name (WebApiUtils)
• Updated code to use SetApiMessage method (WebApiUtils)
• Updated code to use ParseJSON method (WebApiUtils)
• Updated Database class
• Updated JavaScript class
• Updated libs.json
• Removed HRM.OrderedKeys = True (default in EndsMeet)
• Removed test code
• Commented Api settings in config.example
• Added #Macro tags
  • #Macro: Title, Release, ide://run?file=%WINDIR%\SysWOW64\explorer.exe&Args=%PROJECT%\..\release
  • #Macro: Title, Publish, ide://run?file=%JAVABIN%\jar.exe&WorkingDirectory=..\..\release&Args=-cMf&Args=%ADDITIONAL%\Pakai Server%20(5.20).b4xtemplate&Args=*

 

[aeric]

18/09/2025

• Template:
  • Pakai Server (5.30).b4xtemplate
• Depends on:
  • EndsMeet.b4xlib (v1.30) - updated
  • WebApiUtils.b4xlib (v5.30) - updated
  • MiniORMUtils.b4xlib (v3.70) - updated
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar
  • mariadb-java-client-3.5.6.jar

What's New:

1. FIXED bug in APIs flow in search.js using modified JavaScript class
2. Updated JavaScript class
3. Updated .gitignore
4. Updated libs.json
5. Updated code calling SetApiMessage sub from EndsMeet library
6. Added "Update" macro tag to copy updated files to release folder

 

[aeric]

25/09/2025

• Template:
  • Pakai Server (5.40).b4xtemplate
• Depends on:
  • EndsMeet.b4xlib (v1.40) - updated
  • WebApiUtils.b4xlib (v5.40) - updated
  • MiniORMUtils.b4xlib (v3.70)
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar
  • mariadb-java-client-3.5.6.jar

What's New:​

1. Add SetApiMessage sub (moved from EndsMeet library)
2. Updated code
   
   HRM = App.SetApiMessage(HRM, App.api) ' deleted
   Main.SetApiMessage(HRM) ' added
3. Updated libs.json
4. Dependencies updated
   Note: OrderedKeys property in ApiSettings is now set as True by default in EndsMeet library

 

[aeric]

20/10/2025

• Template:
  • Pakai Server (5.50).b4xtemplate
• Depends on:
  • EndsMeet.b4xlib (v1.50) - updated
  • WebApiUtils.b4xlib (v5.50) - updated
  • MiniORMUtils.b4xlib (v3.80) - updated
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar
  • mariadb-java-client-3.5.6.jar

What's Updated​

1. Database class
   • Initialize sub
   • ConnectDatabase sub
2. HelpHandler class
   • GenerateJSFileForHelp sub
   • GenerateJSFileForCategory sub
   • GenerateJSFileForSearch sub
   • Rename variables name to avoid conflict with MiniHtml library
3. config.example
   • remove API related keys
   • add REDIRECT_TO_HTTPS key

 

[aeric]

Pakai Server v6.00 development has started.
This version aims to include MiniHtml library to generate the html files and attempt to remove jQuery to build the frontend.

Pakai Server v6.00alpha is available for testing.
required prerelease version of MiniHtml library

 

[aeric]

03/11/2025

Pakai Server v6.00 alpha​

GitHub: https://github.com/pyhoon/pakai-server-b4j/tree/v6.00

• Template:
  • Pakai Server (6.00alpha).b4xtemplate (size 29KB!)
• Depends on:
  • EndsMeet.b4xlib (v1.60) - updated
  • MiniORMUtils.b4xlib (v3.90) - updated
  • MiniHtml.b4xlib (v0.30) - updated
  • MiniJs.b4xlib (v0.10) - new
  • sqlite-jdbc-3.7.2.jar
  • mysql-connector-j-9.3.0.jar
  • mariadb-java-client-3.5.6.jar

WebApiUtils is optional.
You can use libget.jar to download the additional libraries.

This template focuses on creating web app using HTMX.
It contains minimal JavaScript, based on latest HTMX v2.0.8, Bootstrap v5.3.8 and Bootstrap icons.
HTML and JS are generated using MiniHtml and MiniJs libraries.
No JSON/XML API is generated or the "API" is returned as HTML and JS script to the browser using HTMX.

Note: This template is still under development and is not suitable for daily use. GitHub contribution is welcome as always.

 

[aeric]

Pakai Server v6.00beta uploaded in new thread.

[Web] [Project Template] Pakai Server v6.00

Pakai Server Version 6.00 GitHub: https://github.com/pyhoon/pakai-server-b4j Templates (B4J) Pakai Server (6.00) bundleb4xtemplate (413KB) Pakai Server (6.00) starterb4xtemplate (28KB) recommended Pakai Server (6.00) minb4xtemplate (18KB) Depends on EndsMeet (v1.70) b4xlib (B4J) MiniHtml...

www.b4x.com