I have heard this expression a lot in my life and it always makes me smile. SQL queries are typically executed by a series of steps that will execute once, and then the next statement will execute once more. It is called a “step” because it usually takes place one step at a time. The first step is the statement that is executed. The next step is the one that follows the first one. The next one is the one that follows the last one.
I know that sounds a bit complicated, but when it comes to SQL statements, it’s really easy. A lot of times it can be as simple as “SELECT * FROM table”.
I remember a conversation we had awhile back where I introduced myself as “the guy who does SQL.” This was a bit of a joke because I had no idea what a SQL statement actually did. I was more or less just saying “I’m the guy who did SQL” and hoping that someone would ask what it did.
One of the most important things for building websites is for them to have a lot of features and are always looking for ways to improve their features, and that means they need to have some sort of “customer-facing” section in their database.
The idea that a database must have a customer facing section is a good one. When people look at a website, they want to know that they can access that section of the database to make edits or queries. And the best way to keep that section of the database open and accessible is to make it easy for people to get to it.
A customer-facing section isn’t like a directory path, in that it doesn’t exist on the server itself. SQL get has been in development for some time, and to start it up, the SQL team needed a way to talk to a database on the web. The design team came up with a way to do this.
In essence, SQL get gets called from a web service, so to speak. A database on the web connects to a database on the website. The web service can give the database a URL, and the database can give the web service a URL. The web service then queries the database and returns the results of the query. The web service is then able to do whatever it needs to do, from loading the results of the query to updating the database.
SQL get also uses a web service to do the actual database work. So there is a web service that is queried by the database, the database is queried by the web service, and then the web service writes the results of the query onto the database.
This is not to say that web services are useless. If you have a web service that does something useful, it could be handy.
But unless you are on some sort of web service that is being called by the database, then you are doing something wrong. That is why you should always design your queries with SQL.