skysight-inc/HackerNews huggingface dataset:
From my experience only if there are dedicated DBAs and you have too many systems running - then you forget one. If you only have server code and the stored procedures in the same repository, with migrations, this problem goes away.
Congrats!

I would be interested in the M&A idea. I'm managing director of a B2B SaaS company, which is owned by a European private-equity fund. So I would have access to capital to finance such a transaction (without taking a cut on it!).

My email address is in my profile, or feel free to send me yours.
On lower-DPI displays, which remain very widespread outside of mobile, vector graphics usually look worse than pixel graphics.
If you add up all the things that somebody could be resentful about I am sure that all of them would correlate to low sexual desire, and the more of them that are present the less the desire.

The flip side is that 20% or so of women were sexually abused as children and that creates a situation where no matter how many current time causes of resentment you remove and no matter how many positive things you try to add it is like trying to get a fish to fly. There is a reason why they don’t let victims of sexual abuse serve on the juries of people like Danny Masterson because one person’s indulgence can permanently deprive the victim and their partners of what is an important part of life for most people.
It uses Postgres wire protocol sure, and may even contain some Postgres code; otherwise this is like saying “a tank is just a heavily customised car”
A History of the Dollar (1957)
I'm sorry, but your wife should lose her license if she is truly that bad, and she should be required to take further training to get it back.
Pentagon gives Ukraine green light for drone strikes inside Russia
I do expect that it was different back then. The replication situation has improved somewhat lately but it's still not great.
It's often better to use the tool that is capable but isn't the absolute best possible option to solve multiple problems, rather than taking on the burden of running five different "best" tools for five different problems.
The problem you are running into is that you are overindexing on the fact that LLMs will sometimes be wrong and you are used to using technology that is basically always right. But we are in the early stages of LLM adoption - correctness will improve (see for example citation driven LLM-search) but more importantly, the set of LLM-driven applications that can be probabilistically correct and still wildly useful will grow.

LLMs like ChatGPT are just so damn cheap for the power they provide, it's inevitable
Thanks you to express in English my inconfort growing while reading this ( otherwise nice ) article.

Market fit is insight 20/20 IMO, but you phrased it better.

Overall, my discomfort is that it’s the type of reasoning that keep you with your two feets in the mud. Stuck.

I’m stealing “you don’t know it’s broken until your fix it”
If only there was a infrastructure in a box that gave you all the features he mentioned in a well maintained distribution.

Then rather than saying just use Postgres you say just use X.

I like postgres but I've only used it in production once. My experiences were fine. We used alembic for database migrations. It was a Python Flask app.

We also used it as a message queue and stored JSON form data.

There's still hand crafted code for using Postgres as a message queue.

A bit like Linux distributions which are aggregations of desktop or server software collections of well integrated software.

I tried to build a stack that could be spun up with all goodies included.

But I would not want to inherit something hand stuck together.

But at the same time, the thought of setting up Kubernetes for everything from scratch is also a lot of work.

If you need to use cloud, that's also a lot of work.

https://devops-pipeline.com
I believe that stems from people frequently not including them in version control, or not doing tests.
Not only these opcodes are already assigned, this would be a very much overkill implementation of this functionality by wasting opcode space, whereas a simple device port would do the trick. It's telling that everyone's first reaction to Uxn is to write a compiler for it, or adding extra memory - it's more about finding fun projects to do that fits within such a restricted space.
Jack Selby of Thiel Capital is using a new VC fund to invest in Arizona startups
How the inventor of Tickle Me Elmo became a unabomber suspect
The answer is yes. When you get to my age, two years is truly an
inconsequential amount of time. And AI/ML is a deep enough subject that
a proper grounding requires a full-time MS.
It is not very useful to add full text search to an email field used for login. A regular unique index, perhaps case insensitive, is what you should be using.
The argument was about whether there should be 14 VPs: “why have one vice-president when you can have 14 at fourteen times the price?” If they weren’t VPs, they would still be regular MPs, so only a 800 € difference.
You joke, but I have literally never had as great of a success at work as that one time my team didn't end up building the software.

We had great ideas about scheduling and caching and task priorities...

...and then we asked the customer what they wanted, and they wanted none of it.

So we built none of it, and produced a solution that just did the stupidest thing, and did it without any edge cases, without ever crashing, reliably, as a cronjob, once on Sunday night.

Some people would be disappointed that they couldn't put this on their CV because it didn't involve FancyTech #413, but damn it, I am still proud of that stupid thing.
It's possible to have Postgres serve HTTP, actually. I've seen many experiments like this. I don't remember the name, but... actually... Yeah, thanks ChatGPT - It's called PostgREST: https://postgrest.org/en/stable/

I've obviously not used it and to be honest, I probably wouldn't. But IMO Postgres is a radically different type of framework. People just think of it as a SQL database, it can be much more though. Tooling is just a bit lacking.

Edit: Heh, Retool is sponsoring them. "PostgREST for the backend, Retool for the frontend". Cool idea. I might reconsider...
You can so use pgnotify for a simple pub/sub.
NOTIFY / LISTEN is handy too. (pubsub)
If we are talking about really small business, yeah fine but I really don’t see the point of such articles without any numbers. Do some benchmarks and compare postgres with kafka, postgres with elasticsearch, etc. Define the use cases or minimum number of table rows or number of requests that performance deteriorates.
Advertising and selling a feature that you don't have sure seems like fraud to me.

If it's "the feature is nearly ready but just needs some polish" there's an argument to be made that maybe you were just being a bit too hopeful. But "years and lots of fundamental research away, and we're not even sure what sensor systems were going to rely on", that's just fraud. You're looking for early stage investors, not customer preorders, at that point.
I think stored procedures can be perfectly safe provides you follow these rules:

- they live in source control

- they are covered by automated tests

- they are applied using some form of automatic database migration system (not by someone manually executing SQL against a database somewhere)

If you don't have the discipline to do these things then they are likely best avoided.
> Surely they're not meaning let front-end code hit the database directly?

In this case they mean "let Postgres generate the JSON for API responses" instead of having the API interface do it. The "Generating JSON in Postgres" section in the linked article shows how this is done.
They sold 500 albums ?

Crazy to think they are an absolute must listen to high school kids ( at least in rural France of the 90s… )
Should You Be Eating Less Salt?
You're in a good position to try to answer the question yourself since you're actually working in ML now. Would a master's help you at your current company? Why or why not?
I would agree, I'm currently also playing with Postgres that triggers some data to sqllite data wrapper to be distributed by Litestream to servers so they can locally read data.
>The fact that your comment is flagged and dead should give you pause. The fact that it doesn't give you pause should give you pause.

There is no pause. I KNOW the COST of my beliefs. It is a high cost and your reaction and the flag is a small PART of that cost.

I live a life of lies. Externally I believe none of these things and I pretend to be normal just like you. But internally I see darkness everywhere.

Keep in mind, I don't care if my beliefs are implemented to make a better world. I could care less. In fact most of the beliefs I hold, I feel if the world knew the truth it would be worse off for everybody. I'm not really an opponent against any group here.

>"Yet, it seems that self-regards of epistemic superiority is the only unstable fuel you need to travel down a lonely road."

We both know that epistemic superiority is not worth it for any human. You underestimate the sacrifices involved with believing in these things. Nobody makes that choice. I get what your saying but you are disregarding the cost way too much here. A sense of superiority is not reward enough for the price one must pay to believe in these things.

I am what I am because I cannot un-believe what I think is true. I have no choice. Can you not believe 1 + 1 = 2? To me the conclusions are inescapable. But of course it could be that I am biased. Biased people do not know they are biased. Whether or not I am biased, I can assure you that I am not where I am by choice. I am where I am because I have no choice.

>The fact that you think I am objecting to your specific assertions rather than the mode of assertions should give you pause.

This DOES give me pause. Please describe to me in detail what you mean by "Mode."
Sure, when the topic matters or I need to study it in depth, I can still go to Wikipedia or PubMed or Arxiv.

But there are plenty of searches one does that are trivial, or serve to illuminate the problem space, and cover topics that in which I can rely on common sense to correct wrong advice. And the issue with non-technical topics, the kind applicable to mass audience - like e.g. cooking or parenting or hygiene - are very hard to search about online, because all results are bullshit pseudo articles written to drive traffic and deliver ads. So it's not that ChatGPT is so good, but more that Internet for normal people is complete trash, and ChatGPT nicely cuts straight through it.
I've only given up trying to understand a system once. It was when I was handed over an application that used stored procedures for everything. Including recursive stored procedures... The rest could be figured out, but they were just too much.
https://archive.ph/vhpOO
Research team launches largest global human rights dataset
Disneyland does this when they close a section of a park to rebuild it into something else, removing most of that sections staff from their company in the process, so... yeah, kind of?
I have done this, and the one thing I would note is that if you are requesting a maximum number of rows per call, and if something in the queue breaks for all returned rows (like because it crashed with an exception or something and its status field isnt updated), then you can run a situation where every call to get more rows goes to the same broken rows and the queue becomes blocked. I hadn't figured out a great solution for this but otherwise my SKIP LOCKED queue worked great!
To me, good modularity at the data layer doesn't mean abstracting away Postgres or even SQL. To me, it means having a separation of concerns between loading data, writing data, and _processing data as domain objects_. Don't have your core business logic operate over database rows, but in-memory objects. You can test the loaders/writers separately to your actual logic at that point.
Using estimates has not and never will be a useful idea. You are in one of two worlds, either your work is predictable and easy to estimate, in which case you could just count the number of tasks/stories and get a sufficient estimate anyway, or your work is very unpredictable in which case your estimates are a lie.
I used to do the nohello thing but since seeing this popup a few years ago I switched back to hello to be annoying. I've got an instinctive reaction whenever I'm told what to do to try doing the opposite.
If FSD had been described as "a long-term, aspirational goal" I never would have purchased it, and I think many others would feel the same way.
is case insensitive fulltext faster or slower than case insensitive index search on a varchar
Yeah, but on business trips this is usually the reality in big corporations. Quite often even the company credit card is deducted from the employees bank account. And you need to get the money reimbursed with the receipts. If you do it fast enough you may get reimbursed before your credit card invoice is deducted from the account.
They’re not working on anything, this just means the WebKit previews or the odd product which embeds WebKit rather than use webviews can run regardless of OS support.

Apple ain’t going to enable features they don’t support on safari.
Just so we're clear, I didn't say that you're doing a terrible job fixing the issues (I know the comment you're responding to said that, I'm just being careful not to cosign that.)
this question is either naive or not sincere. Instead of empty symbolic theory, look at the real history of real people in place and time. All food and territory systems involve "trade" -- a specialists' word on a display shelf adds nothing to real inquiry IMO
The research burden might lie with the customer for "don't take your hands off the wheel just because if you ignore the instructions it sounds like something an 'autopilot' would let you do"

But I don't think it's true for believing the car company CEO when he repeatedly said that the car came equipped with all the necessary hardware for full self driving, and if you purchased the $15000 package the full self driving software would be with you by the end of the year, with most of the remaining obstacles being regulatory...

It's a bit like consumers have a responsibility to read the label on medical devices to use them properly, but they don't have a responsibility to advance their medical understanding to the point they can tell if Elizabeth Holmes is telling the truth about her product actually doing what she said it was doing.
If you are ordered to do something there is very little, if any, wiggle room to say no. It is an order not a request.

We can discuss the ethical questions of plea deals, but I see that being different that a system that orders an admission of guilt. Such systems tend to be barbaric often extracting admissions of guilt via torture.
Engineering is trade-offs. Complexity is an enormous one best avoided unless you absolutely cannot work with the simpler system.
Just one thing:

1. Teach people transaction isolation levels.

2. Have some standard written down rules about what SQL type to use in which situation and what approaches to use for table structure.

3. don't overuse triggers or stored plSQL procedures or similar they are hard to test and debug

The two main problems I have seen with SQL databases is:

1. People not understanding transaction isolation, most inconsistency bugs or strange behaviour no seem to be able to explain I have seen where due to this. As far as I can tell this is a HUGE problem, even through SQL databases are used much less and at least theoretically it's normally through in any bachelor level course about SQL.

2. people wasting time on discussion about types and table structure. For example weather this or that int type should be used,for a lot of use-cases it's just fine to use bigint (64bit) initially for everything. With 32bit there is often some edge case in which it isn't enough. For example if you do 5_000_000 increments per second on a 31bit (i32>=0) counter it overflows in ~7 minutes but if you the same with a 63bit counter it takes ~58494 years. Sure you sometimes might have to go back and optimize storage and there are cases with clearly constrained numbers, but it's the best default for not clearly bound integer numbers. Similar "initial start with" default approaches can be written down for most situations in just a single DIN-A4 page of paper or so.
My current stack is PostgreSQL (on Supabase) + retool (or similar front end tools).

PostgreSQL Extensions: http, pg_cron, timescaledb

To help with development, I am using https://www.npmjs.com/package/sql-watch (written by myself) to do continuous development and testing (TDD/BDD).

The stack "doesn't scale" but the turn around time for development is crazy.
lol, and yet the page doesn’t load with JavaScript disabled
It's very different from the approach taken by Waymo and Cruise. Tesla's FSD uses vision only, and it's available everywhere in the US and Canada. The fact that it can complete most drives successfully (~90% of the time) without intervention in any city in the US or Canada is pretty impressive IMO.

The parent poster is right, I've been watching the progress and it's gotten probably 20 to 50 times more reliable in the last year.
PNG quality AND progressive decoding. AFAIK there is no other supported codec offering this.
I think we’re talking about the same thing. There is no gatekeeping of keys. There IS gatekeeping of the services that syncs keys across devices.

If one of these companies locks you out of your account for any reason, you don’t lose access to the keys. They are not removed from your devices. You do lose the service that moves them between devices.

Anyway, I appreciate you sharing your perspective and I admire your commitment to only use fully open services. Just saying the closed ones may not be as malicious or a usable as you think.
> I didn't choose to be born, did I?

According to the Bardo, Veda, Platonic Phaedo and Tibetan Book of the
Dead, yes you did. You just don't remember why your immortal soul
chose this adventure.

> Every evening I pray to deities I don't believe in: "Have mercy on
my suffering, do not make me wake up".

And every night s/he answers your prayer.

Try it with a different twist. "Have mercy on my suffering, help make
me wake up and remember"
How do you handle high availability? Ideally I would want to not lose many transactions and have automatic failover. SQL Server has that, but it not the default config, and it becomes expensive af.
> At this point I'd imagine Tesla is better off with Musk being distracted by his shiny new toy.

I think that's probably correct. One question I find interesting: What is Musk actually good at?

He's clearly good at hype-driven PR and painting himself as a Tony Stark character. That has been great for Tesla; he's been able to raise gobs of money cheaply. Money that apparently kept Telsa from going bankrupt. [1] But that genius for hype also makes it harder to figure out other skills.

Looking at his track record, he got fired from Zip2 and PayPal. The jury's still out on Telsa; it recently got into the black, but it has always had its troubles, and its first-mover advantage is eroding. As is its stock price, down by half recently, something surely not helped by Musk's delusional promises (e.g., 1 million Tesla robotaxis by the end of 2020). The Boring Company and Neuralink both look troubled. [2] [3] And of course Twitter is an extremely public clusterfuck.

That only leaves SpaceX as possible evidence that he's good at anything other than hype and raising money. But recently a former SpaceX intern posted about his experience there [4], saying "Elon was basically a child king. He was an important figurehead who provided the company with the money, power, and PR, but he didn’t have the knowledge or (frankly) maturity to handle day-to-day decision making and everyone knew that. He was surrounded by people whose job was, essentially, to manipulate him into making good decisions."

So I think what we're seeing with Twitter is the real Elon. And yeah, if I were at Telsa trying to pivot from hype-driven startup to solid company able to compete with everybody from GM to Toyota to BMW, I would much rather Musk stayed at Twitter.

[1] https://www.cnbc.com/2020/11/03/musk-tesla-was-about-a-month...

[2] https://jalopnik.com/elon-musks-boring-company-leaves-local-...

[3] https://www.washingtonpost.com/technology/2022/12/06/elon-mu...

[4] https://www.tumblr.com/numberonecatwinner/701567544684855296...
I do, works really well if you need json with nested objects, you can get an entire tree of objects with a single call and query to the database.
You know that all the money sent to the Greeks were only used to bail out European banks, right ? And that they framed it that way because they had already bailed out said banks ?

Anyway, of course I don't know exactly what's going on. I'm just a rando with no skin in the game
> Just use the right tool for the job at hand. Period.

That's Postgres.
PostgREST is an external web server; postgres isn’t serving HTTP, though its effectively doing everything else that the backend requires besides serving HTTP when you use PostgREST.
I was simply a bit pedantic.

And also, JavaScript should always be enabled. Very very few people disable it and they are used to have a broken web experience anyway so it’s not an issue to ignore them. Worst case they don’t see pictures until they eventually enable JavaScript.

Executing third party code in a sandbox is a security risk. You need to allow a level of risks when you use your computer on internet, and by disabling third party code you are safer but you also have a lot less useful computer.
Yet as an older study found, Men Who Do More Housework Have Less Sex[x]. The only way to have a healthy sex life then is for everyone to not do that much housework.

[x] https://www.scientificamerican.com/article/men-who-do-housew...
Sam Bankman-Fried beat you to it.
For the work and resources[1] of these mental projects, humanity could solve world hunger, probably several times over. Or build enough nuclear energy to power half of Europe. (Edit: These are examples of what this much time, resourcing and manpower can do, merely examples)

Oh well, I guess at least some of those hundreds of billions will end up winkled out of the Saudis by consultancies, at least. Presumably it can then trickle back up and be lent out for something more useful.

I'm more surprised the Saudis haven't already slapped down a few trillion dollars worth of solar on empty desert and future-proofed their energy exports. After all, just because they sell solar energy wouldn't mean they've have to stop the oil overnight[2]. Electricity supply isn't going to be sufficient any time soon and demand isn't going anywhere but up[3].

[1]: it's easy to say "the money" but actually the money can be recycled once it's spent by the KSA royals, so it's kind of immaterial. It's the opportunity costs and resource use.

[2]: energy aside, polymers and petrochemicals aren't going anywhere, even if a few supermarkets have changed to paper tomato trays

[3]: moving all of the world to electrical heating, even fully leveraging ground- and air-source, and traction is going to require mind-bending amounts of installed capacity.
Matthias' tutorials are brilliant! We used them as a reference for building the soft and rigid body sims in our breathing app: https://www.lungy.app
> I’m not sure how the phrase “full self-driving” could mean anything other than that.

There is some room to argue about the conditions under which the car can drive itself. If the car couldn't handle a high-grade, winding mountain road with an inch of snow on the ground and yet more coming down, I don't think too many people would be fussed is a "full self-driving" car said "uh, no" (especially as a good fraction of drivers couldn't handle that either).

To my end, if the car can't handle any condition that doesn't make me go "I think I should stay home," that should disqualify it.
Lessons from my dying therapist: care less, have fun – and accept the inevitable