Http server in your mysql server
-
Query your database over HTTP and JSON! That's just what we need!
We can finally do native SQL clients in javascript! What could possibly go wrong.
-
<hidden text so this will post>
-
So it turns MySQL into CouchDB.
-
We can finally do native SQL clients in javascript! What could possibly go wrong.
I'm going to name my next born: { drop: { tables: null }}, or whatever the crippled syntax will be.
-
Now this is efficiency. Why bother making people figure out where they can inject SQL when you can just let them talk directly to the DB?
-
Hmmm, I wonder if the best use-case is an interface that needs to be read-only, so have a read-only user.
-
You still need per-table read permissions and even the use case is a table where you don't have applicaiton auth requirements. i.e. you have multiple users in your app, you surely don't want people being able to freely query any row in your users table or private messages table.That of course won't stop Dicsource,
-
Well yeah, the user would obviously be limited to what you're comfortable having everyone see.
-
Fortunately, we'll just end up getting more TDWTF articles when only 1% of people will use it properly.
-
Well, if we're going down the "web pages are apps" path, we might as well put everything in the client side. After all, the only thing clients can't do is store persistent data, so let's just have a bare database with proper permissions.
Hmm, maybe we could build a distributed client-side database, with WebRTC and enough redundancy? No servers necessary!
-
Sure they can, just there's no guarantee of retaining it... localStorage is a thing.
-
the only thing clients can't do is store persistent data
Sure they can, just there's no guarantee of retaining it
ISTM that if there's no guarantee of retaining it, it's not really persistent, is it?
-
Servers on the cloud have no guarantee of retaining it but we call those persistent, right?
-
I'm with @Arantor on this one.
If you're worried about losing your data, you aren't being enough like blaster worm.