Some libraries and tools enable developers to write queries in a new syntax and translate them to SQL (e.g., PRQL, SaneQL, etc.). The existing SQL ecosystem provides solid database implementations and a rich set of data tools. People always tend to think you must speak SQL; otherwise, you lose the whole ecosystem.
But wait a minute, those libraries translate their new language to SQL because they don't implement the query engine (i.e., the database) themselves, so they have to talk to SQL databases in SQL. However, ScopeQL is the query language of ScopeDB, and ScopeDB is already a database built directly on top of S3.
Thus, what we can leverage from the SQL ecosystem are data tools, such as BI tools, that generate SQL queries to implement business logic. For this purpose, one should write a translator that converts SQL queries to ScopeQL queries. Since both ScopeQL and SQL are based on relational algebra, the translation must be doable.
Hey.. So happens that I’ve been doing a very similar work for the past few months.
I can take a look and help you define what “commercial-grade” design and code should look like.
Youtube has a bunch of simple and free UX and UI courses.
You might also want to search more specifically for information architecture, designing website navigation, picking a color scheme, basics of web fonts, designing forms, and UX user research.
I guess I could offer a few thoughts here, as I’ve been thinking about this for a while.
You say it’s for personal projects but if you care about marketing then I’m going to guess the projects are serious/ambitious enough.
In that case, as you build them, you’d probably first need to do some “marketing strategy” early on, then naming and branding, then some growth marketing/product design, then see how you would incorporate different types of analytics into the projects, then finally there would be a launch and running some campaigns and using the analytics methodically.
I’d say anything less than that would not really be any kind of methodical marketing. But people do get lucky with word of mouth sometimes.
So, basically, you could probably use a good amount of modern marketing skills.
The internet is, of course, full of options but it’s hard to filter through them.
Based on my watching this space for about 10 years, most of the one-person shops and small teams that do SEO and Wordpress websites will know very little about those things you’d need.
Maybe 1% of medium and large firms out there will work with that stuff in SaaS space but then they would likely be way too expensive for personal projects.
Which leaves you with two options IMHO, 1) to learn that stuff yourself (the path I took), or 2) to find a marketing/product/growth cofounder/advisor/consultant that has experiences in that niche, such as SaaS, for example.
