denismagda Profile Banner
Denis Magda Profile
Denis Magda

@denismagda

Followers
4K
Following
5K
Media
635
Statuses
3K

šŸ” Last 10+ years - distributed systems and databases (Postgres, YugabyteDB, ApacheIgnite) ā˜• Before - Java dev team at Oracle and Sun

Florida Man šŸ“ā€ā˜ ļø
Joined October 2010
Don't wanna be here? Send us removal request.
@denismagda
Denis Magda
4 months
Spoiler Alert. In just a few hours, @ManningBooks kicks off theĀ Deal of the DayĀ for books on best-in-class databases — Postgres and Mongo. Seize the deal. It’s never too late to master databases. The books will appear on this page at midnight on April 19th (Eastern Time):
Tweet media one
2
9
33
@denismagda
Denis Magda
4 months
The @ManningBooks team has just released two more chapters of ourĀ Just Use PostgresĀ book. It’s time to learn how Postgres deals with JSON data and handles full-text search. A funny fact is that I decided to write this book after having a conversation with a friend of mine about
Tweet media one
4
17
79
@denismagda
Denis Magda
5 months
RT @eivanov89: Here is the recording of my recent talk, ā€˜Sharded and Distributed Are Not the Same: What You Must Kn….
0
12
0
@denismagda
Denis Magda
6 months
Every developer should absolutely do one thing… attend a live coding tech talk by @starbuxman . It's like watching a maestro perform on stage. This time Josh shared the stage with Dr. Mark Pollack at @devnexus to show Spring AI in action.
Tweet media one
0
3
16
@denismagda
Denis Magda
6 months
This is the next tech book on my must-read list šŸ‘‡. We tend to learn from our own mistakes and often realize that failure is the best teacher. I embrace this mindset when the challenge—and potential failure—affects only me or a small group of people who are willing to take the
Tweet media one
3
7
39
@denismagda
Denis Magda
6 months
Working the Postgres booth with @dave_cramer and @robtreat2 at @devnexus. Postgres definitely needs no introduction within the Java community. Many just stop by to say "Thank you!"
Tweet media one
2
2
29
@denismagda
Denis Magda
6 months
As of today, the chapter about indexes is available in the early access version of the book. This chapter primarily shows how to use indexes backed by B-trees. The following chapters will explain how to leverage GIN, GiST, HNSW, BRIN and other index data types.
Tweet media one
1
9
81
@denismagda
Denis Magda
6 months
Postgres remains popular with the tech community regardless of the rise of AI. It’s truly inspiring to see that the early version of the Just Use Postgres book has been in the top 5 bestselling books for the last two months. Thanks to all of you for your support and feedback!
Tweet media one
1
0
6
@denismagda
Denis Magda
7 months
It's great that @ManningBooks has an early access program that lets authors hear the voice of the reader before the first copy of a book is printed. Without it, it's highly unlikely that we would have "Postgres as message queue" and "When NOT to use Postgres" sections in the
Tweet media one
1
1
11
@denismagda
Denis Magda
7 months
I knew @starbuxman was a big fan of Postgres. So, when the "Just Use Postgres!" book dropped in early access last week, we decided to set up a fireside chat on his YouTube channel. The live stream kicks off this Friday, January 24th, at 5:30 PM ET (2:30 PM PT).
2
5
33
@denismagda
Denis Magda
7 months
Postgres is not much different from programming languages when it comes to this šŸ‘‡šŸ».
@vlad_mihalcea
Vlad Mihalcea
7 months
Pro tip: When using PostgreSQL, columns are aligned, and padding may occur. For this reason, in this particular case, there is no difference between smallint and int for the first column. To save space, you need to do some "column tetris":.
Tweet media one
Tweet media two
0
0
2
@denismagda
Denis Magda
7 months
Just Use Postgres. I’ve always thought this would make an excellent title and topic for a book. And now, it’s happening! We’ve partnered with @ManningBooks to bring it to life. This is the book I wish I had 15 years ago when I, a fresh graduate app developer, was introduced to
Tweet media one
3
17
127
@denismagda
Denis Magda
10 months
If a developer is knowledgeable enough about databases and their team doesn’t have a dedicated DBA, then the developer is destined to fit that role. Experiencing this firsthand right now….
5
2
34
@denismagda
Denis Magda
10 months
One thing I keep reminding others about is that secondary indexes can help boost not only selects/searches but also updates/deletes. This usually applies to any major database that supports secondary indexes. In one AWS DocumentDB case I was involved in, performance was boosted.
1
0
15
@denismagda
Denis Magda
11 months
Common table expressions (CTEs) are usually used with SELECT statements. This is a typical example šŸ‘‡. WITH total_sales AS (. SELECT region, SUM(total) AS total. FROM sales GROUP BY region).SELECT region, total FROM total_sales .WHERE total > 1000000;. But, PostgreSQL also.
0
1
6
@denismagda
Denis Magda
11 months
RT @Sharat_Chander: šŸ“¢ReminderšŸ“¢. #Java developers, the #Java23 launch stream is fast approaching on 17-Sept. Please watch from the official….
0
15
0
@denismagda
Denis Magda
1 year
Today, I’m saying goodbye to my fellow Yugabeings. Keep building that unstoppable, distributed Postgres that scales and never fails. Remember, this is THE database that not only withstood the massive Super Bowl traffic but kept performing flawlessly as 200 million people watched
Tweet media one
11
3
65
@denismagda
Denis Magda
1 year
FInally! No more need to writt stuff like this. floor(1 + random() * 10). just do. random (1, 10) in Postgres 17.
@jkatz05
Jonathan S. Katz
1 year
TIL @PostgreSQL 17 supports random ranges - another reason to upgrade (GA planned for Sep 26! šŸ˜‰)
Tweet media one
2
1
17
@denismagda
Denis Magda
1 year
Remember that the official Postgres distributions come with a powerful command-line client called psql. It lets us start a fresh instance of Postgres and connect to it in under a minute. How? Simply start a Postgres container and open a psql connection šŸ‘‡. docker exec -it.
0
1
5