If you are searching by a primary key or other indexed id you should be fine. Here are a couple of articles to check out:
https://www.atlassian.com/data/databases/how-does-indexing-work
https://www.red-gate.com/simple-talk/featured/postgresql-indexes-what-they-are-and-how-they-help/
The TLDR is a where clause that hits an index doesn’t have to go through all the rows in the table.
It sounds like you need your own API with some sort of persistent store. You may be able to reuse what you’ve done as the view layer?
If this were something I was going to tackle, I’d start by identifying the types of users (authors, admins, users, etc.)
Then I’d think about the kinds of workflows those users are going to need to do. E.g. admins can edit or delete anything, authors can alter their own content, users can only view data, etc.
Now with some loose requirements in mind, start thinking about how to solve the problems for your users. This is when you start evaluating what technology might be a good fit for your problem domain.
You could probably throw together a trivial API that only you can publish to fairly quickly if that is sufficient for what you are trying to do. I dare say chatgpt can spit out a simple rest API in whatever language you like quickly and pretty accurately.
I wouldn’t chase making a static website tool dynamic. That will almost certainly end in heartbreak.
That’s kind of his thing.
“They simply go through the whole table”… that’s the problem. A full table scan should be avoided at all costs.
Learn: how to run and read an explain plan, indexes, keys, constraints, and query optimization (broadly you want to locate individual records as quickly as possible by using the most selective criteria).
You also need to learn basic schema design and to familiarize yourself with normalization.
Avoid processing huge result sets in your application. The database is good at answering questions about data it contains. It isn’t just a big bucket to throw data into to retrieve later.
Oh great, this shit again.
Get a burner. Browse some boring content with it: few business websites, maybe some sports scores, maybe snap some photos of landscapes and dogs on the camera roll.
Then you have a functional phone and piece of mind. Making the phone feel “lived in” probably isn’t all that important, but I think it’d be easier to explain than a factory stock pay as you go phone.
The cumulative price increases are noticeable. Grocery receipts feel like they are $25-50 more expensive for the same stuff.
We buy a dozen eggs every other week, so that specifically isn’t impacting us much, but in the store I usually take note, and say damn under my breath when I see the $7+ ones.
Let’s all head to the conference room, so we can discuss the definition of a story point for an hour. I’d also like to talk about why we are behind schedule and our velocity is dipping. Let’s make it two hours.
I had a kamala yard sign, she was the better candidate. It’s just a shame she didn’t have the time or the effective messaging to convince the masses.
If he would have gracefully stepped down before the election cycle began and they ran someone who spoke to the issues of the people, I think we would have had a drastically different result. The candidate swap was necessary after the disastrous debate performance – but if we started with a stronger, more coherent, candidate we wouldn’t be here. If the Dems focused on delivering for the American people instead of turning Palestine into a smoldering parking lot costing over 22 billion dollars, we wouldn’t be here. If they made any attempt to fix the concerns of the people over healthcare and the growing oligarchy running the show, we wouldn’t be here.
They are bad at politics, messaging, and engaging what used to be their base. They offer no hope, just more of the same.
I want to see intelligent candidates out there who know how to deliver results. There are people like that out there, the Dems need to find and promote them. Nancy Pelosi just propped up a 74 year old cancer patient over AOC, so they continue to not learn any lessons and follow their existing playbook.
They opened the door wide open for Trump.to walk through. I blame them.
Running an 82 year old man who has noticeable cognitive decline and swapping candidates without a primary were very avoidable icebergs the Dems steered into.
Edit: the downvotes are interesting. It’s not a popular message, but he very obviously wasn’t suitable to run. He wasted all of our collective time to make a convincing argument.
Let me check the answering machine.
I try not to waste the day, and actually leave the house to do fun stuff.
I also try to completely avoid work email, slack. Generally the less I consciously think about work the better.
There are no hard and fast rules, but my approach is to pretend like I’m retired and living my best life.
I imagine a dimly lit room with Steve Bannon and Roger Stone telling Trump with a grin “pick Gaetz, that will really piss off the libs”. Then he smiles, thinking he’s the big man making all this happen, as he takes another bite of his McDonald’s.
The other option is for all the mods to quit. AI can probably do a lot of basic tasks, but without mods they wouldn’t have a site pretty quickly.
Sorry i misunderstood, thanks for clarifying!
These tech workers are not Bezos. They are just developers and technical people that thought they had a good job with competitive salaries. It sucks they have to uproot their lives because management is being shitty.
They may work for a company without ethics, but that’s kind of the corporate landscape these days.
My Samsung I bought last year required an Internet connection during setup, but after it updated it “allowed” me to disconnect it. Just to be extra safe I connected it to a guest network that I changed the password on so it couldn’t remember the credentials. The menus have ads (that never change), but I set the TV to default to the last HDMI port when it turns on.
I wish they had an AOSP sort of approach to TV where I could install a new ROM and customize the TV OS with whatever changes I’d like, so I didn’t need extra devices to view Plex and my streaming channels. DRM shuts that dream down pretty quickly though.
I hope that some privacy forward brands will emerge, but there just doesn’t seem to be consumer demand or awareness.
Recently switched to a new contract, which resulted in me switching from IDEA Ultimate to vscode. This picture is terribly accurate.
In intellij I usually do code reviews by checking out the code and comparing the branch to origin/main to step through the changes. Just a right click menu option to compare branches.
I took for granted that this is just a thing IDEs should do, so I looked in vain for a while before googling it and finding out I need a plugin for that. (If I’m wrong please help me find the button, I still believe it must be in there somewhere. Surely the owners of GitHub can compare branches?)