170 karma · joined February 29, 2024
Seems enough for browsing the internet, online banking, emails, some social media, and watching videos in standard definition.
That sounds like enough for the average person. :)
I maintain a web application with a few hundred daily users and with the following table I have never had any problems:
CREATE TABLE `jobs` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `queue` VARCHAR NOT NULL, `payload` JSON NOT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY `id`, INDEX `queue` );
Using MySQL's LOCK and UNLOCK I can ensure the same job doesn't get picked up twice.
All in all, it's a very simple solution. And simple is better!
Another team got given the rewrite and build it in six months using MySQL.
I've never seen SQLite used in a setup which multiple machines connect to the same database over a network.
For example: A web application with a web server, a worker/job server, and a database server.
In these instances MySQL or PostgreSQL seem to be much better choices.
So will SQLite ever be able to "take over" in these scenarios?
How did you find the development experience? Anything that you would change or do differently?
Also, how does Kaboom/Kaplay hold up under load with lots of sprites? I've hit a few performance problems with my game when rending lots of sprites...
I just don't get the value of it for always online servers.
What benefit does encryption at rest solve for something which is never intended to actually rest?
For example, a MySQL database powering a web application is expected to be alive and responding to requests 24/7. It's never really intended to be at rest.
So what benefit does encryption at rest bring? Won't a hacker be attempting to take data when it's online (and therefore not resting)?
You are not alone. It is very complicated, but a lot of people seem to get off on the complexity (for some unknown reason).
> Is it not possible to just like include react through CDN with `link` or `script` tags and still make good use of it?
Not with React (as far as I know). But with Vue you can use it straight off a CDN.
Follow this guide through. It take about 15 minutes but it is entirely worth it!
https://v2.vuejs.org/v2/guide/#Getting-Started
> More specifically, I want to know what can I hope to achieve if I migrate from jquery to react?
You can build SPAs (which although not impossible to do in jQuery, is a lot harder). You can also be part of "The React Gang" and get more jobs.
> And to begin with, is this a good idea even?
Not if jQuery is still working for you. If it ain't broke, don't fix it! :)
Stick with the LAMP/LEMP stack. It's not perfect, but if you're moving from WordPress (which uses the LAMP/LEMP stack) then sticking with it will make the move less painful.
In terms of a framework. Laravel is a good idea for RAD, although Symfony is a fine choice too!
---
Frontend:
Assuming is has to be a SPA: Use whatever you know best. React, Vue, or Angular are fine. Laravel seems to prefer Vue slighty?
If you can get away with SSR: Use a templating system. Assuming you're using PHP, you could use Blade (for Laravel) or Twig (for Symfony).
---
In terms of hosting and deploying, use one big VM for as long as possible. It's not better, but it's simpler... and I'd say you've got a lot on your plate!
---
But to answer your original question:
If you stick with LAMP/LEMP and a framework, there is so much documentation (and so many guides) that you will be able to figure out what to do. :)
Take a Raspberry Pi Zero and connect it to these:
https://www.amazon.co.uk/Battery-Holder-150mm-Wires-Leads/dp...
https://www.amazon.co.uk/voltage-converter-Raspberry-batteri...
Allows you to run a Raspberry Pi Zero from 8 AA batteries!
I can't remember where I'm getting this figure from, but I think it accommodates for about 3 days of runtime (obviously dependant on what you're doing with your Pi!).
Then drag and drop one of these into it:
https://www.macintoshrepository.org/5953-star-wars-pit-droid...
https://www.macintoshrepository.org/4962-star-wars-droidwork...
You might need to use StuffIt to uncompress the SIT files. But when booting Infinite Mac there's an option to include common applications, of which StuffIt is one.
There were many jQuery plugins that did most of what HTMX did. But maybe it has risen in popularity recently because of JavaScript fatigue?
Unrelated, but my preference when working with JavaScript:
1. None
2. jQuery
3. Alpine
4. Vue
As you can see, I have JavaScript fatigue, and prefer the lighter touch frameworks.
https://metro.co.uk/2024/05/14/big-cat-hunters-have-proof-ru...
https://www.theguardian.com/world/2024/feb/22/it-was-a-big-c...
My apologies for the abysmal UK news websites!
A lot of sightings started at the end of the 70s, which would align with the introduction of this law:
https://en.wikipedia.org/wiki/Dangerous_Wild_Animals_Act_197...
Rumour has it that lots of wealthy people simply released their "pets" into the wild rather than confirming with the laws!
Fairly certain there were documented cases of servants confirming this too.
https://en.wikipedia.org/wiki/British_big_cats#Proven_captur...
I should add, the "Alien" in ABC denotes alien to the country they were found in. Not alien to planet Earth! :)
You probably want to use a framework of sorts. Laravel or Symfony are good. Not mandatory though.
Server side rendering to start off with. Bulma for CSS. Alpine for JS.
Throw in some cronjobs for scheduled stuff.
Maybe a bit of Redis for sessions and caching.
1. With regards to the CTO, treat them like an employee. Prove that their performance as an employee is not good enough, and fire them. They now have no reason to interact with the company on a day to day basis.
2. As a 5% owner, treat them like a shareholder. Put together a reasonable offer to buy them out, and do so. If they don't want to sell then that's fine, you'll only have to interact with them during shareholders meetings.
The first action will solve a lot of your problems. The second action can happen later on when you've got the money to do so.
Throw in a PHP framework (probably Laravel for rapid development) and use server side rendering.
Maybe add in Redis for caching too.
All hosted on a single Digital Ocean droplet.
None of it matters really. Would you rather be 25 and unhappy or 35 and happy?
Your answer may shock you! ;)
It's got enums, typed properties, named arguments, union types, and the splat operator to name but a few.
Plus between Laravel and Symfony, you've got some good frameworks too!
Yes, I'm a PHP fanboy. :)