The mismatch of code fluidity and the rigidity of the RDBMS is why we created https://schemafreesql.com . We ofcourse looked at NOSQL but our fondness of SQL kept us from considering.
We accomplish similar with SchemafreeSQL. Currently MySQL 8 back-end but working on other SQL back-ends. This demo uses PlanetScale as the DB back-end, Fly.io handles the SFSQL endpoint, Netlify function handles the query, and cytoscape.js graph network library for the UI
Thanks !! We had hoped to use PS for our serverless backend and also offer a dedicated PS option. But we ran into some issues with Vitess. I was just thinking today I wanted to get back into it and see if we can resolve these issues. We had to go with Aurora.
The issues were on deletes. This demo is read only so it works well with a PS backend. My experience with your CS has been amazing despite these issues!!
Eric and I have been together since 1997 solving problems with this thing called the Internet. Dynamics yes you can call it that. The comment was tongue and cheek about the code. Eric was unavailable to respond to comments in a timely manner so I let be known. Read into it as you want.
You are correct there is a "schema" behind behind the scenes. Managing complex relationships between data and evolving those relationships can be a daunting task. SFSQL was created for that purpose.
I believe you clicked on "A Document Store like Mongo" and saw "Create a 'brand' table" which then goes on to explain why a document store does not adequately solve the problem
The hope is that we are conveying a good enough reason to give us money. Thanks for you feedback
The focus is on value prop. and yes the docs are lacking.
Your feedback to include a comparison of our language to SQL is good. I was hoping the breakdown of the "shop admin" demo detailed the semantics of the language but looks like that it did not work for you.
The thought was that by going through the examples with the free trial one could get up top speed with SFSQL, but maybe a more formal introduction to the language is needed.
For reasons beyond our control Eric is not available for commenting at this time. He not wanting to take credit for the demos was more of a joke. Non trivial client work we have produced with SFSQL is not available for public review. I wanted public demos so I made them also to show how a novice can hook up a back-end with SFSQL sorry it came off as weird.
Also sorry we could not peak your curiosity a bit more, we will do better.
Compare your approach to EdgeDB - https://www.edgedb.com/. They have a similar product - SQL alternative but not NoSQL. Their homepage is also a little long, but has clear examples.
Yes I see what you mean by "infomercial" when comparing SFSQL to EdgeDb. Was not our intention, its a work in progress. Will make the needed changes, thanks again for feedback.
