2025 Year of Code: February

Hi everyone and welcome to month #2 of the 2025 Year of Code! As mentioned in the February blog post, this is the topic to share your February project, which has the theme of databases.

I’ll start things off with my project which is an updated version of Storm, an object-relational mapping library for using SQLite with Xojo.

I’ve posted it to GitHub where you can review the readme, wiki docs and download it.

I can’t wait to see your creations this month!

6 Likes

Some might remember my Xojo Guest Blog Post: Docker, Database Servers and Xojo. It shows how to easily set up cubeSQL Server along with an open sourced, web based Administration Tool cubeSQL Web Admin, which is written with Xojo Web.

The February Theme is “Databases”, so cubeSQL Web Admin fits into that category.

Coincidence or not - in the last days of January (I know, that doesn’t quite count) I’ve added a new feature to that project.
For the interested ones: here is the Pull Request #27: Server Preferences

In the early days of February (before the Theme has been announced) I’ve prepared the project to benefit of newer Xojo Web Features (e.g. assign CSSClasses in the Xojo IDE instead of some Javascript Magic) and started to test it with the most current Xojo Release 2024r4.2. So the next official Release of cubeSQL Web Admin will be built with it.


If you want to try the Xojo Web Application cubeSQL Web Admin yourself, but you don’t have access to a cubeSQL Server I encourage you to look at the Xojo Guest Blog Post: Docker, Database Servers and Xojo. Using Docker Compose you can easily set up many Database Servers without hassle and messy (de)installation.


cubeSQL is a fully-featured and high-performance relational database management system built on top of the SQLite database engine. It is the ideal database server for both developers who want to convert a single user database solution to a multi-user project and for companies looking for an affordable, easy to use and easy to maintain database management system.

5 Likes

As soon as I’ve seen this month’s theme, your project instantly came to my mind :sweat_smile:

1 Like

Hi.
Around 20 years ago, at the time Xojo was still RealBasic, I build a (Windows only) tool to help business colleagues run simple queries against a db. Found the old source tree in old archives. Thought it would be a good candidate to illustrate this month theme and thought it would take 3 days to bring it back to life, finally took nearly three weeks (ok, not full time and I’m not the only one who thought something was so easy that 3 days would be enough) The tool was querying MsAccess database via ADODB. Converted to use SQLite. There are still lots of rough edges.

By the way, looking at that old source tree gives a sense of the progress made by the Xojo language over time.

Example flow:

Made the repo public at: https://github.com/slo1958/sl-xj-dataquery.git

Enjoy and feedback welcome. And save frequently … :wink:

Note: when running in debug mode, from the cloned repo, there is a demo mode using a small db included in the repo. You cannot save a flow created against the demo db.

5 Likes

Let’s talk about another OpenSource Project that I’ve been working on in February which relates to both Xojo and Databases.
The topic might not be expected - it’s about the OpenSource CubeSQLPlugin.

As it’s OpenSource I’ve been contributing a couple of Bug Fixes in 2024. However, the biggest contribution has been the Build Automation using GitHub Actions Workflows.

This February I’ve been updating the Workflows to use the newly available GitHub Runners that run on ARM hardware. Previously we’ve had to use QEMU for ARM emulation. Now the Build of the Plugin is being done in just about 2.5 minutes - for all the supported platforms (Windows, macOS, Linux) and all their architectures (Intel/ARM, 32/64Bit). Without any user interaction required, without any own hardware required.

Additionally I’ve written a Xojo Guest Blog Post: Build a Xojo Plugin with GitHub Actions which shares more insights into automating the build process of CubeSQLPlugin using GitHub Actions Workflows.


CubeSQLPlugin is an extension for the Xojo programming environment that allows developers to use CubeSQL, a fully featured and high performance relational database management system built on top of the SQLite database engine.

6 Likes

Hello, It is the last day, it is just json but i want to play so…

Here is a little adaptation to the to do list xojo tutorial : now it is a Json post-it notes.
Link to GitHub

In French, sorry.
Tray item
Json saving, with size, color and placement
Works on MacOs and Windows

I need some help to next steps
Export & Import Notes
Auto Start on Windows and MacOs
Auto Show a Note when at day X (todo)
Auto Show a Note when at time (reminder)

Thanks a lot for this Year of code 2025

2 Likes

Thank you to everyone who participated and commented on February’s Year of Code projects! All the participants were entered into a drawing and the winner is @Jürg_Otter! Coincidentally, Jürg also wrote a blog post about his project. I’ll reach out about your prize today and you will be entered to win the grand prize at the end of this Year of Code! We’ll be announcing the March project soon; stay tuned to the Forum, the Blog and our social media accounts for announcements.

6 Likes