I noticed the astro docs has lot of mention of Cloudflare worker as well, is there any reason why you didnt go with Cloudflare pages instead? I’d have guessed pages would be the perfect fit for hosting a rendered astro website
D1 is fine when it fits the use case, but most of the time I just want Postgres that I will use for absolutely everything. It has happened often enough that I have tried to make systems work with other storage systems, and eventually just give up and revert to Postgres. Every time I just start with Postgres I don't have issues until it turns out my laziness has caused a performance problem, and those I can fix.
When I recently switched jobs, one of my requirements was I had to remain remote, for at least the next few years, so I could remain at home and help with my children's education. I don't think there is enough money in the world to convince me to change back to public education. Aside from the benefits everyone mentions like a much better education, having so much extra time with my children is a priceless gift that I wish we as a society could give everyone.
Also its given me the chance to learn things that I missed during my primary and secondary educations. Going through each proof in Euclid's Elements again has been a lot of fun, and its been long enough that I have forgotten most of them, so the thrill of discovery is real for me too.
If you can make it work, you should make it work, even if that means moving to a lower CoL area, there are a lot of small towns in the US that have excellent amenities, and are great places to raise a family.
How do you make up for the resulting drop in interaction with other kids? I had a boss who did this with his children as well - it seemed as though his solution was to use PE credits to have his kids attend sports with other kids.
My kids are part of a co-op where they meet once a week and in this co-op they share some elements of their curriculum with everyone else, they spend one day going over the weeks assignments along with 8-10 classmates, and then during the week they are at home doing their work. As they have aged their school work now has a lot of collaborative elements, so my oldest is actually meeting with kids from his co-op almost daily to go over group projects and assignments.
Additionally they have a lot of extra curricular activities they participate in ( sports, music, church youth group), that also gives them a lot of socialization time with others.
Sounds like a wonderful setup. Have the kids ever shown a desire for public school? My brother is homeschooling his kids to start, but the oldest just asked to start going to public, so he sent her.
No, my wife and I discussed putting them into traditional school as they got older, but now that they are older, they have all strongly requested to remain in their homeschool co-op. I think the biggest reason is they have a good group of friends that they connect with, and have been their class mates for multiple years. So there is a strong desire to continue in the program with people they know.
Depending on where you live there are many options. In my school district home school kids can join any club or team offered by the public school system where you reside. Additionally there are numerous non-school related clubs and activities all over the place. My kids could play music with the local school district, with a musical education non-profit that is prolific in our area, or ( where they do play music ) with private lessons that have group classes, bands, and performance opportunities.
This is long term the right choice. Tesla has the best software competency of any manufacture and if you want to compete with them you can't offload major bits of functionality to a third party. At this point in our software journey in cars, user experience is everything. If I can't have a car that I walk up to with my phone in my pocket and get in and drive, with automatic doors unlocking, and all my settings automatically set to me, then its a net loss.
I can barely get my phone to reliably pair with my Ford, but my Tesla always picks up me as the driver and just does everything correctly. Rivian needs to offer me that same level of polish to be competitive.
I tried to go the litestream route on Fly.io, but there is too much that needs to be done to get it working. Specifically I was hoping scaling would be a lot easier, but master election kept breaking for me causing the whole app to not be able to come online. I just moved to Fly's managed postgres and called it a day.
Their managed postgres has gotten better, but its still a little sparse, so after about 6 months using it I am going to just take my DB to either Supabase or Planetscale.
Yeah, something that’s messed up that they don’t think is messed up is running `fly console` fires up another instance, which isn’t attached to the same volume, so you have to run `fly ssh console —pty`
It’s certainly not intuitive. It would be awesome if they sweat these details, but their deal is “here’s a bag of sharp knives”, which is good for some use cases.
I would just point out that its Hosted Postgres. If your looking for a how I think you have the wrong mental model. Its hosted Postgres, there are some nuance there as to why it would perform differently from RDS on Amazon, or CloudSQL on GCP, but its not some novel new technology that needs a long description.
If you are interested in their new technology that extends on hosted postgres check out Neki https://www.neki.dev/
You're being entirely unfair to Supabase here. Research is important, but there is a reason why the USPTO has developed substantial case law around Reduction to Practice, everything is built on prior work, so to say there is nothing novel about actually building displayed working system from parts is factually inaccurate.
Yeah, huge props here. There's a contingent on HN that seems to assume that almost any action by a company is done in bad faith. I dislike all of the shady stuff that happens, but that's why we should celebrate when companies are doing awesome things.
This is all positive. Super appreciate what you folks have done. It's clearly hard, well intentioned, and thoughtfully executed.
People might say that the company is doing it for good will, but that is the point, it is better to get the good will of the users by actually helping them instead of being like thousands of other companies which don't even do that.
It is a nuanced topic but I feel like we should encourage companies which do good period. (like silksong / team cherry in gaming) etc.
I am super bullish on OrioleDB. It really seems like the next logical progression for scaling Postgres for 99% of all databases out there. I have been following their development for a while and running benchmarks to see if their performance claims are legitimate, and so far it has been amazing
The actual storage engine is written as an extension - these patches are mostly to improve the TAM API. If these are accepted by the community then it should be simpler for anyone to write their own Storage extensions.
I think (correctly) it will take a lot longer to upstream the extension - the PG community should take a “default no” attitude with big changes like this. Over time we will prove its worthiness (hopefully beyond just supabase - it would be good to collaborate with other Postgres providers)
Based on the README [0] and discussion [1] it seems like it might especially shine on high-write-volume workflows, with the implementation of anti-bloat measures. Do you have a sense for whether it would shine even further where those rows have large text/JSONB fields that might be TOASTed?
And more generally, curious if you have any sense for what might make up the "1%" of workflows this wouldn't be advisable for? Any downsides to be aware of?
I haven't explicitly tested how it handles TOASTed column's, but since there is an upcoming RC I will try it out next time. I don't generally like using JSONB/text columns for very large rows as they have other performance problems on the DB like causing lots of WAL write overhead.
In term of other workloads it might not be great for, all my testing has shown a great improvement in every workload I have thrown at it.
OrioleDB looks interesting but the with the storage changes, the issue will be the compatability with other extensions. pg_search (paradedb), timescale come to mind.
We have seen this issue with YugabyteDB, and their integration off RocksDB as the storage engine for postgresql.
As far as I know, you can run heap and orioledb tables side by side in the same system, so I don’t see a problem using heap-based extensions like timescale together with orioledb.
( of course timescale doesn’t support OrioleDB storage yet, but they can run in parallel. )
and many extensions (e.g. postgis) already work fine with OrioleDB storage.
OrioleDB isn't a separation of storage and compute, its a more efficient storage engine for Postgres to replace the existing HEAP engine. This is like how in MySQL we could swap MyISAM for InnoDB and eventually RocksDB.
I did some benchmarks on it previously to show how much of an improvement it gives over the stock HEAP engine
EDIT: correct link to the public dashboard below, thanks for the heads up @kiwicopple
Not really. OrioleDB solve the vacuum problem with the introduction of the undo log. Neon gives you scale out storage which is in a way orthogonal to OrielDB. With some work you can run OrioleDB AND neon storage and get benefits of both.
Now we just need Cloudflare to buy one of the DBaaS companies so they have a solid relational offering.
reply