I am very curious as to how databases are used in the real world, whether you’re using MySQL and what not, how does it all come together in a real world business? Banking and gaming I know, but is it something that gets stored on data centres and then put into a VM?...
The Lemmy app we are using on our phones needs to download content from Lemmy so it can be displayed to us. Lemmy might just have one big file full of links, but that’s annoying to have to write code to handle. Or it might have a folder full of files where each file is a post, but that’s also a bit annoying to write code to manage.
It (probably) uses a local SQLite database to store all of the cached posts.
Conceptually, a database is just a place to store things, just like a big text file. The database just handles a lot of the grunt work for you and makes it easier to search, organize, and filter the data.
So anywhere there is data, there could be a database.
I see you got your answer, but I’m adding on for anyone else that comes across this.
For me, I learned the most when I had a disposable and replaceable system. When I was dual booted I was too scared to touch anything in case it fucked everything up. Once I started poking round on a Pi, LiveUSB, etc it was a lot easier to learn because I could always restart.
Id start there with something like Mint or Ubuntu. Then set it up in a way where you can easily replace your OS so you can reset it often and fuck around. Then just learn as you go.
if you let complexities of a long term vision constantly be injected into the steps to take now, you end up putting the cart before the horse.
This exactly. Honestly at this moment I don’t really give a shit about long term stability as long as a genocide is happening, but we keep seeing that thrown out as a reason to ignore genocide.
(Not to mention the arguments of if it’s technically genocide or “just” ethnic cleansing. That’s a problem for the international courts, all that matters now is that whatever it is, it’s too damn close to genocide to be acceptable.)
I know it’s a rude question, but it’s been on my mind… I’m wondering roughly what I should be expecting to outlay when I finish my set-up? So I’m assuming it includes things like domain names, hosting for backups, email providers, VPN, etc. What’s a good budget to set?
It really isnt bad. I do most of my computer at home so I really only need a small cloud box to pipe things through when needed.
And I could reduce the B2 price a lot with some deduping of my data, but that’s an ongoing and painfully slow process since I was too reckless with my local backups in the past, so $7 to avoid that process is worth it.
And for electric I suspect it’s pretty low. I’m running 3 raspberry pi, a 4 bay NAS, and one micro PC and I live in an area with pretty cheap electric already. I think my gaming machine probably takes more power in a few hours than the rest of the system does in a day.
And each type of communication needs it’s own switch. Don’t let them pull some BS trying to make you enable all the hardcore tracking via a cell network just because you want to connect to Bluetooth.
It’s not even limited to smart cars though. Yes used does let you a oid it, but it’s not like this is just people buying the fancy trims either. Shit like this is working it’s way down to the run of the mill standard cars year after year.
Exactly. That shit has their personal photos, financial info, connections to everyone they know and all their private conversations, etc , etc, etc. Don’t fuck with it.
Anything that requires you to open an app, view any pictures, etc is a breach of privacy.
Hey guys, what are your thoughts on the existence of extraterrestrial life and the potential involvement of governments in concealing or studying such entities.
In general, yes. In the expanse of space there must be life somewhere.
For fun I let myself believe they’ve visited earth, and that at least some UFOs were alien, but that’s more of a fun “what if…” belief than anything and it doesn’t impact anything beyond my imagination.
I wonder if it has to do with the specific traits they are commenting on. Do you value being different? Maybe compliments make you feel like you’re fitting in and insults tell you that you’re your own person.
I love all the ritualized behaviour, secret meanings and unexpected taboos - standing up when someone of higher status stands, elaborate rules for serving and eating, tapping the table to thank the server, never refuse a toast from a superior, stuff like that....
The seats are assigned. People have been standing in line for 15 minutes now. Why on earth would anyone want to stand there, when they could just sit and wait until the line clears?...
It’s the one thing when I’m configuring things that makes me wince because I know it will give me the business, and I know it shouldn’t, but it does, every time. I have no real idea what I’m doing, what it is, how it works, so of course I’m blindly following instructions like a monkey at a typewriter....
To take this further, if the office mailroom is the router, opening a port is like telling them “we just hired Jeff, so accept mail with ATTN Jeff” and closing a port is like “we just fired Sam, burn all mail addressed to Sam”.
Easier said than done, but yes this is very true. It’s way too easy to fuck up and touch the wrong account, or sync the wrong data, or otherwise contaminate your personal projects with work.
Me and my friend were discussing this the other day about how he said RAID is no longer needed. He said it was due to how big SSDs have gotten and that apparently you can replace sectors within them if a problem occurs which is why having an array is not needed....
Maybe maybe MAYBE for a prosumer desktop situation it’s less necessary than it used to be. But it’s absolutely still needed, your friend is dumb and reckless with their data.
Two and a half monitors here. Two connected to my desktop (one normal one vertical) and my laptop below them.
My laptop is for Teams calls, and the occasional reference page or video, but is mostly ignored until I need it. The main large monitor for editors and email. The vertical one for references and notes.
I would love a third monitor for the desktop but my desk is too narrow for that to be realistic.
Like why do they care how many times I go to porn hub every day or that nothing gets me harder than a free use MILF? Why do they care that I don’t know how to spell consistency so I have to Google it every 3 months....
Cool. Now I can subtly influence you to pay for your free use MILF porn. Or use MILF models in your ads to make you more likely to buy shit.
Even if you don’t think you can be influenced by that stuff it still likely to change your behaviour just enough, even just 5% more spending which makes it worthwhile to them.
But honestly your data barely matters on its own. But once it’s merged with everyone else’s…that’s when it’s valuable.
genuine question, because I forgot a $20 with the laundry at work and I don’t know if the laundry is going to look green or if I’m going to get a white $20 back and clean clothes…
Trading at all by Congress. They should be required to lock their money in a blind trust with heavy oversight. If a CEO has to publish their stock sales months in advance, congresspeople should too.
Databases and their real world use examples
I am very curious as to how databases are used in the real world, whether you’re using MySQL and what not, how does it all come together in a real world business? Banking and gaming I know, but is it something that gets stored on data centres and then put into a VM?...
Need a good resource to learn linux
I just fucking can’t with windows anymore. I’d preach about it but I imagine you’ve heard it all. I have minimal computer expertise....
Very nuanced issue (lemmy.eco.br)
Google will use Gemini to detect scams during calls | TechCrunch (techcrunch.com)
What Are Your Recurring Costs?
I know it’s a rude question, but it’s been on my mind… I’m wondering roughly what I should be expecting to outlay when I finish my set-up? So I’m assuming it includes things like domain names, hosting for backups, email providers, VPN, etc. What’s a good budget to set?
How to opt out of the privacy nightmare that comes with new Hondas (sherwood.news)
You randomly get a hold of your colleague's phone. It's unlocked. You don't mind being fired. What sounds do you set as his notification and ring tones?
I was thinking of something like the Duff Man theme and slapping sounds and moans, but I feel that Lemmy knows better....
A3 receipts is wild AF (lazysoci.al)
Using gaming controllers for anything other than gaming ?
Wondering if anyone has experimented with using controllers (PS/xbox/other) to do anything other than gaming ?
Movie industry demands US law requiring ISPs to block piracy websites (arstechnica.com)
Do you believe in Aliens?
Hey guys, what are your thoughts on the existence of extraterrestrial life and the potential involvement of governments in concealing or studying such entities.
I don't enjoy it when people compliment me. Why could it be?
Not to brag but I’m a pretty confident person in my social circle. I’m funny, make people laugh etc. etc....
What's the most interesting traditional or formal politeness behaviour or table manners in your culture? Or for any service personnel, in your restaurant?
I love all the ritualized behaviour, secret meanings and unexpected taboos - standing up when someone of higher status stands, elaborate rules for serving and eating, tapping the table to thank the server, never refuse a toast from a superior, stuff like that....
Why stand in line to board an airplane?
The seats are assigned. People have been standing in line for 15 minutes now. Why on earth would anyone want to stand there, when they could just sit and wait until the line clears?...
Can someone demystify computer Ports for me? Please? Blocking, unblocking, opening, allowing, VPNs and their effect, what ports are and what they do, step by step, when you have to interact with them?
It’s the one thing when I’m configuring things that makes me wince because I know it will give me the business, and I know it shouldn’t, but it does, every time. I have no real idea what I’m doing, what it is, how it works, so of course I’m blindly following instructions like a monkey at a typewriter....
to those of you who get bored at work if there's lots of downtime, why?
cross-posted from: linux.community/post/767456...
Is RAID still needed?
Me and my friend were discussing this the other day about how he said RAID is no longer needed. He said it was due to how big SSDs have gotten and that apparently you can replace sectors within them if a problem occurs which is why having an array is not needed....
To those with 2+ monitors on your machine: What's your use case, and how much does it actually boost your productivity? (lemmy.world)
I’m mainly curious about software developers here, or anyone else whose computer is somewhat central to their life, be it professional or hobbyist....
Why are tech company's so interested in my boring ass data?
Like why do they care how many times I go to porn hub every day or that nothing gets me harder than a free use MILF? Why do they care that I don’t know how to spell consistency so I have to Google it every 3 months....
do you know how banknotes look after being washed with the laundry?
genuine question, because I forgot a $20 with the laundry at work and I don’t know if the laundry is going to look green or if I’m going to get a white $20 back and clean clothes…
What is something that is completely legal that should be illegal?