andatki

7 ms·

31.
by andatki 2y ago
Author here! If you use PostgreSQL with web apps, what sorts of things surprised you as functionality that was useful, that you didn't initially know about? Or maybe, what functionality was more complex than you expected? Thanks!
32.
Top Five PostgreSQL Surprises from Rails Developers(andyatkinson.com)
8 points by andatki 2y ago|2 comments
33.
IndieRails – Andrew Atkinson – The Postgres Specialist(andyatkinson.com)
1 points by andatki 2y ago|0 comments
34.
Merging and Splitting Partitions with Minimal Locking PostgreSQL 17(andyatkinson.com)
1 points by andatki 2y ago|0 comments
35.
by andatki 3y ago
Congrats on the launch Gwen!
36.
Rails and Postgres – Postgres.FM 086 podcast(postgres.fm)
1 points by andatki 3y ago|1 comments
37.
by andatki 3y ago
Michael and Nikolay are joined by Andrew Atkinson, author of High Performance PostgreSQL for Rails, to discuss how Rails and Postgres work together — where the limits are, how people use the ORM, things that are improving, and some things w
38.
by andatki 3y ago
I was able to adopt fish shell and get many features from bash that were provided from plugins. I prefer the more “stock” shell configuration for easier maintenance across computers and over time, and a less complex dotfiles project. https
39.
by andatki 3y ago
That's great! Hopefully the authors of Rails Guides and the Getting Started tutorial see this. I'll share it with a core member and ask them to reshare it. I'm sure they'd appreciate seeing their hard work get recognized
40.
by andatki 3y ago
Correct, when the query conditions match the index conditions, and they both select a low proportion of the rows. For PostgreSQL and those unfamiliar with partial indexes, worth a read: https://www.postgresql.org/docs/c
41.
by andatki 3y ago
Thank you! Beta book period is nearly wrappped up!
42.
by andatki 3y ago
Great! I wasn’t sure whether to plug it but it seemed very relevant to the post. :)
43.
by andatki 3y ago
I tend to agree as a SQL enthusiast. However I have yet to see a Rails team that doesn’t use Active Record or writes much SQL directly, or by default, across 100s of apps. I’m sure it happens but in my experience it’s rare. This is a place
44.
by andatki 3y ago
I like how the PostgreSQL docs use the term “profitable” for whether an index helps. The purpose of the index often is to lower the “cost” (greater profit), by providing more values the query is accessing (filtering, ordering, selecting) wi
45.
by andatki 3y ago
Really solid list! I went through all the Active Record, query design, and index design tips for PostgreSQL, and can +1 them all. Nice work. For readers who want all of these and more in book form, with a sample Rails app and big data to te
46.
by andatki 3y ago
Thanks! Appreciate it.
47.
by andatki 3y ago
Thank you!
48.
by andatki 3y ago
Use code turkeysale2023 for 40% off any Prag Prog book through November 30, 2023.
49.
Show HN: I Wrote a Book on PostgreSQL for Rails(pragprog.com)
47 points by andatki 3y ago|5 comments
50.
by andatki 3y ago
Mind sharing your sass business, or the category? Always inspiring to hear about those.
51.
by andatki 3y ago
We (Rails programmers) appreciated all your amazing content and skills as an educator Ryan! A well-deserved Ruby Hero award recipient.
52.
by andatki 3y ago
That last idea is really good Tristan and I bet you’ll have interest. You could lead an online meetup. Melanie Plageman was interested in ideas like that as well. We briefly discussed different types of office hours.
53.
by andatki 3y ago
Thanks. This looks great!
54.
by andatki 3y ago
I’ve been editing my Markdown files with it and wrote about it here: https://andyatkinson.com/blog/2023/05/26/better-writing-vale