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.
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!!
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
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
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.
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.
It would not work in its current state but we have plans for a Lambda compatable offering. We are also looking at fly.io and other "serverless" function providers.
In a self hosted model developers would host SFSQL on their own infrastructure, which could be AWS, Google, Azure, DO, etc.. There is no reliance on us. Yes we are maintaining the API and underlying implementation. Software is a Service thus the subscription model.
We have shut down our consulting business and are all in on SFSQL. We will not be offering a FOSS solution. Our plans are to provide SFSQL via a subscription based self hosted model. Delivered initially as a docker container.
SAAS offerings would be provided through infrastructure provider partners. We would prefer not to be the SAAS provider of SFSQL. We have other business models that we plan to deploy but we don't want to get ahead of ourselves.
We tried to remove friction by allowing beta account creation without a password and one click demo account creation.
You can start using the beta service without creating a password, maybe that was not clear? We have "beta" there just so you know it's not production ready. We can put the beta verbiage in the account creation page description but not in the Create Account Button call to action.
A more detailed response will be provided shortly but I do encourage you to launch a demo, https://schemafreesql.com/demo.html. You will be provided with an endpoint and access key to your own dedicated SFSQL service. No login required. You can start trying it out from within your own environment.
I would hope that the “what” SFSQL is doing for you is answered on our home page, if not our apologies. We are constantly working on describing the benefits of using SFSQL. “How” we do it is a bit of a moving target for now. The purpose of the beta is to access our implementation and make any needed tweaks. With that said we will provide a better answer to the "How", stay tuned. As previously stated upon the release of our self hosted offering all will be revealed.