andersoncode42 @andersoncode42

Analista de Sistemas. Um generalista sempre tentando aprender um pouco sobre tudo. Joined June 2021

Tweets

2K
Followers

13
Following

231
Likes

2K

Crunchy Data @crunchydata

2 days ago

Postgres tip for testing extensions: You can use the `LOAD` to load shared libraries in a single session instead of changing `shared_preload_libraries` and restarting Postgres. LOAD 'auto_explain'; LOAD 'pg_stat_statements';

1 3 11 634 3

Siva @sivalabs

7 days ago

Just got my reviewer copy 🙂

6 4 115 3K 45

Download Image

Crunchy Data @crunchydata

6 days ago

Postgres tip: use jsonb_pretty for readable vertical json data

0 4 32 1K 6

Download Image

Crunchy Data @crunchydata

7 days ago

Postgres tip: Use underscores for big numbers in SQL 💰 SELECT 1_000_000_000; INSERT INTO classic_cars (name, price) VALUES ('Ferrari 250 GTO', 70_000_000);

0 4 25 720 4

Crunchy Data @crunchydata

a week ago

psql tip: \dn for showing all schemas. Often you’ll pop into a database in the default or public schema. \dn can show you the other schema names. The schema is part of the psql search path, so to change schemas, you change the search path: SET search_path TO new_schema;

0 3 15 848 3

Mohit Mishra @chessMan786

2 weeks ago

Understanding File System Management In Unix-Like Operating Systems This blog post gets into the intricacies of how these systems keep track of files, manage file descriptors, and implement features like pipes for inter-process communication.

2 7 119 4K 93

Download Image

Principe do Oceano @rponte

2 weeks ago

existem 4 golden patterns de resiliência em sistemas distribuídos que eu considero SUPER importantes e (quase) obrigatórios : 1️⃣ Timeout 2️⃣ Retry 3️⃣ Idempotency 4️⃣ Outbox Pattern os 3 primeiros são os mais importantes; não à toa, eu já palestrei sobre...

5 19 300 13K 237

Aadriksh @Aadriksh

3 weeks ago

Master x86-64 Assembly by Building a GUI from Scratch: The Ultimate Hands-On Learning Experience!

17 215 2K 128K 2K

Download Image

Crunchy Data @crunchydata

3 weeks ago

B-tree skip scanning in Postgres 18: There’s a nice performance bump coming in Postgres 18 for some multi column B-tree indexes. Traditional B-tree index scans work by reading an index from a single starting point, determined by the query's conditions on the index’s columns in…

1 22 207 7K 134

Download Image

Mohit Mishra @chessMan786

a month ago

Understanding Reader-Writer Locks: Enhancing Concurrency in Multithreaded Applications A detailed guide to reader-writer locks, exploring how they improve concurrent access patterns and enhance performance in scenarios with multiple readers and occasional writers.

2 12 54 2K 43

Download Image

Mohit Mishra @chessMan786

a month ago

Write Your Own Shell

1 38 315 13K 320

Download Image

Crunchy Data @crunchydata

a month ago

Data modeling with a lot of tags? Try arrays with Postgres: - they can be faster to query - smaller to store - simpler to query crunchydata.com/blog/tags-aand…

0 9 30 2K 13

Download Image

Vlad Mihalcea @vlad_mihalcea

a month ago

The best UUID type for a database Primary Key vladmihalcea.com/uuid-database-…

5 9 91 6K 54

Download Image

Crunchy Data @crunchydata

a month ago

Let’s talk about Postgres scan types. Most of us have been in EXPLAIN and read some plans. Here’s some details about the different scan types and a diagram for thinking about how they work. ❖ Sequential scan: reads the entire table, row by row checking to see what matches the…

0 30 139 9K 159

Download Image

trish @_trish_xD

a month ago

Building a Simple HTTP Server from Scratch devlogs.xyz/blog/simple-ht…

5 34 389 20K 377

Download Image

Vlad Mihalcea @vlad_mihalcea

a month ago

Why you should use compact table columns vladmihalcea.com/compact-table-…

0 3 9 2K 4

Download Image

It's FOSS @itsfoss2

a month ago

You can easily hide your bash history. 😉

12 12 173 9K 37

Download Video

Crunchy Data @crunchydata

a month ago

🔥 Postgres 18 update: indexable UUIDs Postgres 18 is in beta and will be out in production databases near you this fall. There’s a new addition to the uuid data type for supporting UUIDv7. UUIDs are randomly generated strings. They are inherently globally unique. UUIDs are…

1 27 101 5K 46

Download Image

Crunchy Data @crunchydata

a month ago

We have a new blog out today - a deep dive on Postgres logging. This post has a lot in it, including: • Setting up logging levels • How to log SQL • Rotating logs • Logging for performance monitoring crunchydata.com/blog/postgres-…