5 ms·

Check out this simple, easy API replacement: just set up Docker, APISIX, Grafana, Prometheus, etc. Does anyone else miss the old days of just editing your site

by 55555 4y ago

Check out this simple, easy API replacement: just set up Docker, APISIX, Grafana, Prometheus, etc. Does anyone else miss the old days of just editing your site's code and adding new columns to your MYSQL database while people were surfing your website? That was fun. Tip: Another way to turn your DB into an API is to just connect to it and then write SQL queries.

tptacek 4y ago
Grafana and Prometheus aren't necessary, and Docker is at this point pretty close to a Linux platform feature. APISIX is a reasonable complaint --- the "poor man's API" is "using a big open source project that provides generic APIs", sure, that's not all that clever.
- jjallen 4y ago
  The goal was simplicity and cheapness, not being clever. Using a simple, existing tool is better than unnecessary complication, no?
  - morelisp 4y ago
    I've never looked an an Apache project, certainly not APISIX, and thought "wow, so simple".
ilrwbwrkhv 4y ago
Absolutely. It is shameful how much stuff needs to be run before you can even get started.
- tommek4077 4y ago
  You still can do it, the main feature is: it just works. You don't have to follow the hype. One problem could be that new devs never experience the simplicity of such a setup, but that is not your problem.
- dasloop 4y ago
  Like, for example an OS, hardware even electricity! But if you give things for granted, why not docker or APISIX?
- jspash 4y ago
  Just be thankful javascript isn't involved!
EdwardDiego 4y ago
I miss aspects of those days, because I made a good bit of money from people who used MyISAM because "it's more performant" (or just because it was the default, yes, I'm dating myself here), and then corrupted their data because MyISAM didn't enforce constraints. Other than the easy money, nah, don't miss the old days that much. Having to use Reflector to decompile a core .NET library to figure out wtf it was doing because MSDN was inadequate, and the source was very much not open. PHP 4 code bases that heavily leaned on dangerous globals. J2EE. Ah, the "good" ol days.
- dmitriid 4y ago
  > who used MyISAM I remember reading "High-Performance MySQL" in mid-200s. It was a real eye-opener: all the things you needed from a DB where somewhat randomly available across the different storage mechanisms, but not in any consistent form. Something like: Oh, you need query optimisation? Use one. You need constraints? Use the other. you need fast indexes? Use the first one again. And so on. > Ah, the "good" ol days. You'll pry my nostalgia from my cold dead hands!
  - jagged-chisel 4y ago
    > mid-200s I am astounded to learn MySQL predates so much technological advancement! >.<
    - sdiacom 4y ago
      The code base certainly looks the part.
    - bee_rider 4y ago
      Pretty sure they mean mid-2000’s. So actually MySQL won’t be invented for another 480 years or so.
- Aeolun 4y ago
  It was all more fun at the time because of those reasons. You didn't need anything more than 'barely adequate' to be at the top of your game.
quickthrower2 4y ago
hostgator.com still exists. install some wordpress, edit the PHP files, add some tables in MySQL, have fun!
CharlieDigital 4y ago
You might like Directus. It is nominally a "headless CMS", but it's so close to the SQL that I think of it more like API in a box.
ls15 4y ago
Or use https://github.com/mevdschee/php-crud-api https://github.com/mevdschee/php-crud-api and skip writing queries (for basic CRUD). > Howto: Upload "api.php" to your webserver, configure it to connect to your database, have an instant full-featured REST API.

by 55555 4y ago

tptacek 4y ago

Grafana and Prometheus aren't necessary, and Docker is at this point pretty close to a Linux platform feature. APISIX is a reasonable complaint --- the "poor man's API" is "using a big open source project that provides generic APIs", sure, that's not all that clever.

jjallen 4y ago
The goal was simplicity and cheapness, not being clever. Using a simple, existing tool is better than unnecessary complication, no?
- morelisp 4y ago
  I've never looked an an Apache project, certainly not APISIX, and thought "wow, so simple".

ilrwbwrkhv 4y ago

Absolutely. It is shameful how much stuff needs to be run before you can even get started.

tommek4077 4y ago
You still can do it, the main feature is: it just works. You don't have to follow the hype. One problem could be that new devs never experience the simplicity of such a setup, but that is not your problem.
dasloop 4y ago
Like, for example an OS, hardware even electricity! But if you give things for granted, why not docker or APISIX?
jspash 4y ago
Just be thankful javascript isn't involved!

EdwardDiego 4y ago

I miss aspects of those days, because I made a good bit of money from people who used MyISAM because "it's more performant" (or just because it was the default, yes, I'm dating myself here), and then corrupted their data because MyISAM didn't enforce constraints. Other than the easy money, nah, don't miss the old days that much. Having to use Reflector to decompile a core .NET library to figure out wtf it was doing because MSDN was inadequate, and the source was very much not open. PHP 4 code bases that heavily leaned on dangerous globals. J2EE. Ah, the "good" ol days.

dmitriid 4y ago
> who used MyISAM I remember reading "High-Performance MySQL" in mid-200s. It was a real eye-opener: all the things you needed from a DB where somewhat randomly available across the different storage mechanisms, but not in any consistent form. Something like: Oh, you need query optimisation? Use one. You need constraints? Use the other. you need fast indexes? Use the first one again. And so on. > Ah, the "good" ol days. You'll pry my nostalgia from my cold dead hands!
- jagged-chisel 4y ago
  > mid-200s I am astounded to learn MySQL predates so much technological advancement! >.<
  - sdiacom 4y ago
    The code base certainly looks the part.
  - bee_rider 4y ago
    Pretty sure they mean mid-2000’s. So actually MySQL won’t be invented for another 480 years or so.
Aeolun 4y ago
It was all more fun at the time because of those reasons. You didn't need anything more than 'barely adequate' to be at the top of your game.

quickthrower2 4y ago

hostgator.com still exists. install some wordpress, edit the PHP files, add some tables in MySQL, have fun!

CharlieDigital 4y ago

You might like Directus. It is nominally a "headless CMS", but it's so close to the SQL that I think of it more like API in a box.

ls15 4y ago

Or use https://github.com/mevdschee/php-crud-api https://github.com/mevdschee/php-crud-api and skip writing queries (for basic CRUD). > Howto: Upload "api.php" to your webserver, configure it to connect to your database, have an instant full-featured REST API.