Common DB schema change mistakes in Postgres
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 31,674 posts.
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
Mitchell Hashimoto takes on a new individual contributor role at HashiCorp.
Postgres stores a lot of statistics about your data in order to effectively retrieve results when you query your database. Here we deep dive into some of the statistics PostgreSQL stores and how you can leverage a new feature in Postgres 10 to improve performance when different columns are related.
The most powerful and advanced iPad Pro ever pushes the limits of what’s possible on iPad with the addition of the Apple-designed M1 chip.
This is the first of four parts of the Indeed Tech Skills Explorer — an interactive look at which tech skills are in demand and for which tech jobs. For these reports, we searched for more than 500 tech skills in US postings for tech jobs on Indeed.com.
Yesterday, the Internet Archive filed our response to the lawsuit brought by four commercial publishers to end the practice of Controlled Digital Lending (CDL), the digital equivalent of traditional library lending. CDL is a respectful and secure way to bring the breadth of our library collections to digital learners…
Claude Code joins the AI pricing bait-and-switch
Humans are hard-wired to dream, to create, to innovate. Each of us seeks to do work that gives us purpose — to write a great novel, to make a discovery, to build strong communities, to care for the sick. The urge to connect to the core of our work lives in all of us. But...
What hardware we're considering purchasing now that we have to move GitLab.com to metal.
Privacy experts say Gmail confidential mode is neither secure nor private because it does not use end-to-end encryption.
Learn how to master cold email outreach from 0 to $1M ARR. A comprehensive playbook on infrastructure, copywriting, and AI-powered personalization at scale.
By default almost all WiFi access points transmit at full power (100mW on 2.4GHz). This gives maximum coverage and users see a good signal ("full bars"). However, there are good reasons to turn down the transmit power to a fraction of the maximum.
Introducing native support for the popular display server protocol on Linux.
Phoenix 1.7.0 is here! This releases includes major new features, component-based generators, updated conventions, LiveView Streams, and more!
AI has changed vulnerability discovery, but closing source code does not remove the attack surface. Continuous AI defense is the better response.
Announcing the general availability of Realtime's Broadcast and Presence.
It is more important than ever that the social web is not controlled by corporations. Today, Mastodon is taking another step towards its founding ideals: independence and non-profit ownership. We're transferring ownership of key assets to a new European not-for-profit entity, ensuring our mission remains true to a…
The Eye Security Research team has uncovered a new critical misconfiguration that exposed sensitive data at internal Microsoft applications.
Good things happen when everybody’s invited. A few years ago, we had the thought that phones (and stuff that hadn’t even been invented yet like tablets and smart watches…
Last week, an online community for sex workers disappeared from the Internet. Visit SFRedbook.com, MyPinkBook.com, or MyRedBook.com right now, and you’ll only find the seals of the law enforcement agencies—the FBI, the DOJ, and the IRS—that seized the sites as part of a prostitution and money...
We’re excited to announce the release of Zulip Server 5.0, containing hundreds of new features and bug fixes! Zulip is an open-source team collaboration tool with unique topic-based threading that is ideal for both live and asynchronous conversations. Fortune 500 companies, leading open-source projects, …
Call congress now! Back in 2014 over 3 million Internet users told the U.S. government loudly and clearly: we value our online security, we value our online privacy, and we value net neutrality. Our voices helped convince the FCC to enact smart net neutrality regulations—including long-needed...
We can't always be at the mercy of our motivation. I've some tricks how to fool myself into work, every single day. I'm quite productive thanks to these tricks. They will work for you too. So here they are...
Want to rekindle your passion for coding? Learn how to create video games from scratch using Go and Ebitengine. We break down core concepts like game loops, sprites, and collisions that we've applied in multiple projects. In just one evening, you'll build a simple Asteroids clone and reignite your love for programming.