Share My Creation [Project Template] Pakai Server v5.40

Pakai Server​

Version 5.40

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

Template:

• Pakai Server (5.40).b4xtemplate

Depends on:

• EndsMeet.b4xlib (v1.40)
• WebApiUtils.b4xlib (v5.40)
• MiniORMUtils.b4xlib (v3.70)
• 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