Just use Postgres for everything?

Also explore JS regex updates, side project realities, and refactoring best practices. Plus, a chance to win $20k in a dev hackathon! ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ [SitePoint logo](~/AAAHUQA~/RgRorxOgP0UgOGViMjMzNjIyNWFkZWIwN2YwZTA0NDIxYWUxNDNlY2VEFGh0dHBzOi8vc2l0ZXBvbnQuY29tVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) August 26th, 2024 | [Read Online](~/AAAHUQA~/RgRorxOgP0TbaHR0cHM6Ly9iZXJyaW1hLmVvY2FtcGFpZ24xLmNvbS93ZWItdmVyc2lvbj9lcD0yJmxjPTg3MDdlZTg2LTUyZjAtMTFlZS1hZjUyLTRiNTM4MmJhM2I5NCZwPWZmMTU4M2E2LTU4OWEtMTFlZi1hZTAzLTk3NDNkZDQ3NDdmMyZwdD1jYW1wYWlnbiZ0PTE3MjQ2ODE4ODgmcz1kZDE4MjI3MDBiMGJlMGIyYzY1MjQxNzQzYTU2ZTIwNDcxMmEyM2M2ZTU4MmJiNWZkMTY5ZDA1YjU1NWY0YTQ2VwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) SitePoint Source Welcome, Developers! 👋 This week features several opinionated pieces, one of which argues that Postgres should be your go-to database solution while addressing objections to alternatives. It's an interesting statement when there's a variety of database solutions out there. We also explore the evolution of JavaScript regex capabilities, the bittersweet journey of a successful side project, and the nuances of good vs. bad refactoring practices. Plus, there's a dev hackathon where you can win $20k! Let's begin. From our Sponsor: monday dev ~/AAAHUQA~/RgRorxOgP0UgNjZkNjQ1M2VhZGRhMTAzOTdlZjZlNDgwYWVmYTFlYWREgmh0dHBzOi8vc3J2LmJ1eXNlbGxhZHMuY29tL2Fkcy9sb25nL3gvVDZBS0daRENUVFRUVFQzUFpDTENLVFRUVFRUWllIUkNLWVRUVFRUVEtUNEJZN0VUVFRUVFQyTFZDSkNDS1JKWTUzVjZFTlBFMks3NllBTEVaSFk2QzJESlZKQ1RXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~ 🚀 Get products over the finish line (much) faster Taking a product over the finish line sometimes feels like pulling teeth—ouch! monday dev empowers teams to move from ideation to product delivery faster and on a single platform. [Try for free](~/AAAHUQA~/RgRorxOgP0UgNjZkNjQ1M2VhZGRhMTAzOTdlZjZlNDgwYWVmYTFlYWREgmh0dHBzOi8vc3J2LmJ1eXNlbGxhZHMuY29tL2Fkcy9sb25nL3gvVDZBS0daRENUVFRUVFQzUFpDTENLVFRUVFRUWllIUkNLWVRUVFRUVEtUNEJZN0VUVFRUVFQyTFZDSkNDS1JKWTUzVjZFTlBFMks3NllBTEVaSFk2QzJESlZKQ1RXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~) [🐘 Just use Postgres](~/AAAHUQA~/RgRorxOgP0UgYjRhYzhjYzNlZjFmNTVlZGM5NmY5MDQyYWExOTBhZTNEMWh0dHBzOi8vbWNjdWUuZGV2L3BhZ2VzLzgtMTYtMjQtanVzdC11c2UtcG9zdGdyZXNXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~) Ethan advocates for why Postgres is the safest bet when choosing a database as it's versatile, and works well in most scenarios. He also answers common objections for different alternatives like "Why not SQLite, NoSQL, Redis, MySQL etc. [By Ethan McCue →](~/AAAHUQA~/RgRorxOgP0UgYjRhYzhjYzNlZjFmNTVlZGM5NmY5MDQyYWExOTBhZTNEMWh0dHBzOi8vbWNjdWUuZGV2L3BhZ2VzLzgtMTYtMjQtanVzdC11c2UtcG9zdGdyZXNXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~) --------------------------------------------------------------- [🔍 Regexes Got Good: The History and Future of Regular Expressions in JavaScript](~/AAAHUQA~/RgRorxOgP0UgOTU5MjNiNDM0ZGEzMzc2NWIwMWJlY2RkN2QwMzQ4N2REV2h0dHBzOi8vd3d3LnNtYXNoaW5nbWFnYXppbmUuY29tLzIwMjQvMDgvaGlzdG9yeS1mdXR1cmUtcmVndWxhci1leHByZXNzaW9ucy1qYXZhc2NyaXB0L1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) JavaScript regex capabilities have expanded significantly in recent years, now rivalling regex implementations in languages like Perl or Python. In this comprehensive overview, learn all about how to write more powerful, readable, and maintainable regular expressions in JavaScript. [By Steven Levithan →](~/AAAHUQA~/RgRorxOgP0UgOTU5MjNiNDM0ZGEzMzc2NWIwMWJlY2RkN2QwMzQ4N2REV2h0dHBzOi8vd3d3LnNtYXNoaW5nbWFnYXppbmUuY29tLzIwMjQvMDgvaGlzdG9yeS1mdXR1cmUtcmVndWxhci1leHByZXNzaW9ucy1qYXZhc2NyaXB0L1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) --------------------------------------------------------------- [💸 I've Built My First Successful Side Project, and I Hate It](~/AAAHUQA~/RgRorxOgP0UgMGU5MjBmZDVmNGQ1ZjgxMGRlM2E4ZDNmMmVmZjFlMDVEV2h0dHBzOi8vc3dpdG93c2tpLmNvbS9ibG9nL2ktaGF2ZS1idWlsdC1teS1maXJzdC1zdWNjZXNzZnVsLXNpZGUtcHJvamVjdC1hbmQtaS1oYXRlLWl0L1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) What started out as an exciting side project in 2020 turned into a source of frustration over the years, despite earning over $15k. Check out Sebastian's journey from excitement to burnout as he navigates customer support, feature requests, and work-life balance. [By Sebastian Witowski →](~/AAAHUQA~/RgRorxOgP0UgMGU5MjBmZDVmNGQ1ZjgxMGRlM2E4ZDNmMmVmZjFlMDVEV2h0dHBzOi8vc3dpdG93c2tpLmNvbS9ibG9nL2ktaGF2ZS1idWlsdC1teS1maXJzdC1zdWNjZXNzZnVsLXNpZGUtcHJvamVjdC1hbmQtaS1oYXRlLWl0L1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) --------------------------------------------------------------- [🧹 Good Refactoring vs Bad Refactoring](~/AAAHUQA~/RgRorxOgP0UgZDVjYTI5ZTE2ZWYyNDUzYjZjMzI4ODMxZjc0Yzg0YmNEM2h0dHBzOi8vd3d3LmJ1aWxkZXIuaW8vYmxvZy9nb29kLXZzLWJhZC1yZWZhY3RvcmluZ1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) Refactoring should make life easier for developers, not harder. This piece explores the dangers of unnecessary abstractions, inconsistent styles, and refactoring without understanding. Learn best practices for improving codebases without introducing new problems. [By Steve Sewell →](~/AAAHUQA~/RgRorxOgP0UgZDVjYTI5ZTE2ZWYyNDUzYjZjMzI4ODMxZjc0Yzg0YmNEM2h0dHBzOi8vd3d3LmJ1aWxkZXIuaW8vYmxvZy9nb29kLXZzLWJhZC1yZWZhY3RvcmluZ1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) --------------------------------------------------------------- [🏆 Dev Hackathon: $20k Up for Grabs](~/AAAHUQA~/RgRorxOgP0UgZTdiODgyMTUyMjcyM2FhNDcwYjY4MzJjYTM3M2FkMmZESmh0dHBzOi8vd3d3LnNpdGVwb2ludC5jb20vZGV2LWhhY2thdGhvbi1yZXVzYWJsZS1jcmVhdGl2aXR5LW9uLXdpeC1zdHVkaW8vVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) Wix Studio and Merge are inviting developers to push boundaries in their latest hackathon. Craft reusable Wix blocks or templates that'll make other devs go "whoa" and win $20k. The clock's ticking 'til September 9th! [By SitePoint Sponsors →](~/AAAHUQA~/RgRorxOgP0UgZTdiODgyMTUyMjcyM2FhNDcwYjY4MzJjYTM3M2FkMmZESmh0dHBzOi8vd3d3LnNpdGVwb2ludC5jb20vZGV2LWhhY2thdGhvbi1yZXVzYWJsZS1jcmVhdGl2aXR5LW9uLXdpeC1zdHVkaW8vVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) 🧰 The Toolbox Tools and products we're excited about today: [Screen Ruler](~/AAAHUQA~/RgRorxOgP0UgODJkNWM1OTZmMmJjODkyZTE5OTc1NjJkNTcwMDcyYWJELmh0dHBzOi8vd3d3LnByb2R1Y3RodW50LmNvbS9wb3N0cy9zY3JlZW4tcnVsZXJXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~) Screen Ruler is the perfect companion for web developers and designers. See sizes, distances, margins and paddings of any element on any web page. [Learn more →](~/AAAHUQA~/RgRorxOgP0UgODJkNWM1OTZmMmJjODkyZTE5OTc1NjJkNTcwMDcyYWJELmh0dHBzOi8vd3d3LnByb2R1Y3RodW50LmNvbS9wb3N0cy9zY3JlZW4tcnVsZXJXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~) --------------------------------------------------------------- [AgentQL](~/AAAHUQA~/RgRorxOgP0UgOThiNTJiODFhNDU4MWI2ZmYwMWU3Yzc1MmI3ZThmOWZEKWh0dHBzOi8vd3d3LnByb2R1Y3RodW50LmNvbS9wb3N0cy9hZ2VudHFsVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) Painless data extraction and web automation. Forget fragile XPath or DOM selectors. Just specify what data you are scraping from the web with natural language-like queries, and AgentQL will handle the rest. [Learn more →](~/AAAHUQA~/RgRorxOgP0UgOThiNTJiODFhNDU4MWI2ZmYwMWU3Yzc1MmI3ZThmOWZEKWh0dHBzOi8vd3d3LnByb2R1Y3RodW50LmNvbS9wb3N0cy9hZ2VudHFsVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) --------------------------------------------------------------- [Phase](~/AAAHUQA~/RgRorxOgP0UgMWE1NDM4NTlhYjVhOGEyNjg1ZThmZjQzYmI3OWI2ZjREKWh0dHBzOi8vd3d3LnByb2R1Y3RodW50LmNvbS9wb3N0cy9waGFzZS04VwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) Open source application secrets manager. Instead of hard-coding secrets into your code or using .env files and sharing them over Slack, try Phase, an easy-to-use application secrets manager for developers. [Learn more →](~/AAAHUQA~/RgRorxOgP0UgMWE1NDM4NTlhYjVhOGEyNjg1ZThmZjQzYmI3OWI2ZjREKWh0dHBzOi8vd3d3LnByb2R1Y3RodW50LmNvbS9wb3N0cy9waGFzZS04VwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) --------------------------------------------------------------- 🚀 Get products over the finish line (much) faster Taking a product over the finish line sometimes feels like pulling teeth—ouch! monday dev empowers teams to move from ideation to product delivery faster and on a single platform. [Try for free →](~/AAAHUQA~/RgRorxOgP0UgNjZkNjQ1M2VhZGRhMTAzOTdlZjZlNDgwYWVmYTFlYWREgmh0dHBzOi8vc3J2LmJ1eXNlbGxhZHMuY29tL2Fkcy9sb25nL3gvVDZBS0daRENUVFRUVFQzUFpDTENLVFRUVFRUWllIUkNLWVRUVFRUVEtUNEJZN0VUVFRUVFQyTFZDSkNDS1JKWTUzVjZFTlBFMks3NllBTEVaSFk2QzJESlZKQ1RXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~) Come say hi! SitePoint’s community is a place where you can come to talk tech, development, and design. Join us today and get involved with other members who share your interests in tech! [Join now →](~/AAAHUQA~/RgRorxOgP0UgNTk4Mzg4MDY0ZTc3OGQxM2FjNDU4YWYxNDQwYjYzZWJEJGh0dHBzOi8vd3d3LnNpdGVwb2ludC5jb20vY29tbXVuaXR5L1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) That's a wrap for today! Let us know how you felt about today's newsletter. ~/AAAHUQA~/RgRorxOgP0UgZDdhMTI0ZmMyMGMwZmY2NjkzY2U0ZTJjNzdkODVhMDREWWh0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1ob3dfZGlkX3lvdV9mZWVsPTAxSFdUSE40WUtXVzVGQkhOQ0NDVllDSFYxVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd ~/AAAHUQA~/RgRorxOgP0UgZTBkZjUxYjgwN2MzYWU3N2ZjNzkyMTExOWZlYjIyZThEWWh0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1ob3dfZGlkX3lvdV9mZWVsPTAxSFdUSE40WUtQSkE4Uk44QUJZV1QzNkNXVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd ~/AAAHUQA~/RgRorxOgP0UgNjE1Njg0MDY2YmNjOTQyY2YyMWIyYzk3ZDM0YTZkNjdEY2h0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1ob3dfZGlkX3lvdV9mZWVsPTEzNjg3YjBhLTMwZmQtNDQxNC1iZDFlLTRkNjQ1ZGIzYTkwMVcFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~ What do you want to see more of? ~/AAAHUQA~/RgRorxOgP0UgNDQxZGJmODc3NmFhNzYwMDk3OWY3OTk2ZmJkZTk1MjVEXmh0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1zZWVfbW9yZV9vZj0wMjQ1MWQ0ZC05Y2NhLTQzNmMtYmFhOS0zYzAzNmM4ODZhMGRXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~ ~/AAAHUQA~/RgRorxOgP0UgN2Y4ZWJhM2MxM2ZkMTRkNDZhNThhYmI0MDY3N2E1NjlEXmh0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1zZWVfbW9yZV9vZj1iZGYzZDg5ZS0xYmU1LTRjNTctYjhmNy1iNzljM2RiYjkyMmVXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~ ~/AAAHUQA~/RgRorxOgP0UgYTM2Yzk4NjM1NmE5ZjJlOGU0YTYzMTMwM2U4MzMyZjFEXmh0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1zZWVfbW9yZV9vZj00ZGYzYzQwZC1lMzhhLTQ0OWYtOGJmMi1kYWEwMDI1YTFkMWVXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~ ~/AAAHUQA~/RgRorxOgP0UgZWI5NzMzNDg0MjRjMWRjMDFlNWE5YTExZjA1MWRiZWNEXmh0dHBzOi8vZm9ybS50eXBlZm9ybS5jb20vdG8vdTVEQ3B0QkcjYW5zd2Vycy1zZWVfbW9yZV9vZj1hYTAzMzMxNi0zM2I4LTQzOWEtYTMwZi1hOTI1MGU0YjJhYjNXBXNwY2V1QgpmvKCOzGbCXgAYUht0cmlzdHJhbWJhbGR3aW45MUBnbWFpbC5jb21YBAAAZB0~ 71 Balmain Street Cremorne Vic 3121 Australia You received this email because you signed up on our website or made a purchase from us. [facebook social link](~/AAAHUQA~/RgRorxOgP0UgNWUxMzllNzg1ZDkwNjEzN2UyMTUwNTQ5Zjk4N2I2N2VEI2h0dHBzOi8vd3d3LmZhY2Vib29rLmNvbS9zaXRlcG9pbnQvVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd) [x social link](~/AAAHUQA~/RgRorxOgP0UgYWRjMjI4ZWNiYWQ3MTRkZjNjYTI3YmI0ZGVhMWFhNjVEJGh0dHBzOi8vdHdpdHRlci5jb20vc2l0ZXBvaW50ZG90Y29tL1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) [linkedin social link](~/AAAHUQA~/RgRorxOgP0UgMjBhMjUyYzE0MTQ2OTY0MzkxNWE1NGM0MWEwNWU5ZGZEJ2h0dHBzOi8vbGlua2VkaW4uY29tL2NvbXBhbnkvc2l0ZXBvaW50L1cFc3BjZXVCCma8oI7MZsJeABhSG3RyaXN0cmFtYmFsZHdpbjkxQGdtYWlsLmNvbVgEAABkHQ~~) [Unsubscribe from this list](~/AAAHUQA~/RgRorxOgP4QWAWh0dHBzOi8vYmVycmltYS5lb2NhbXBhaWduMS5jb20vdW5zdWJzY3JpYmU_ZXA9MiZsPWNhYTY1ODU4LTRhYzYtMTFlZS04MDE2LTRkY2U5YmEwOGU2ZCZsYz04NzA3ZWU4Ni01MmYwLTExZWUtYWY1Mi00YjUzODJiYTNiOTQmcD1mZjE1ODNhNi01ODlhLTExZWYtYWUwMy05NzQzZGQ0NzQ3ZjMmcHQ9Y2FtcGFpZ24mcHY9NCZzcGE9MTcyNDY3OTA0NCZ0PTE3MjQ2ODE4ODgmcz1iZDViNDJlYzdlNGFlZmE0Mjg3ZWIzZmE2NWM1YmM1NWE0MDM1NmMzMDdkMmZjMzMwZWQxMjQ2MmZkNGFhMTdlVwVzcGNldUIKZrygjsxmwl4AGFIbdHJpc3RyYW1iYWxkd2luOTFAZ21haWwuY29tWAQAAGQd)