Paulo Renato

Building and Prototyping a Remote-Controlled Telescope with Elixir and Rust elixirmerge.com/p/building-a… #MyElixirStatus

SQL books won’t teach you this. Natural Keys vs. Autoincrement IDs vs. Public IDs. (or maybe all together) Natural Keys Natural keys carry intrinsic meaning because they are part of the domain. They are directly related to the data, making them intuitive and easy to understand. Examples include email addresses or employee IDs. The problem is that they are usually not good for performance, but they can also be a security risk if you expose them. Autoincrement IDs Autoincrement IDs automatically generate unique integers to identify rows within a table. They are often used as primary keys. Simple integers are fast for the database to index and query. They provide optimal performance. However, they are vulnerable to enumeration attacks since predicting the next or previous record is easy. Public IDs (UUIDs) UUIDs (Universally Unique Identifiers) are 128-bit identifiers used to uniquely identify information without relying on a centralized authority. They are difficult to guess, making them suitable for public exposure in APIs. The problem is they are larger and more complex than integers. This can impact performance, particularly in indexing and storage. Finding the Sweet Spot: A Mixed Approach Combining different types of keys can offer a balanced solution: • InternalID: Used for internal operations and relationships between tables. • PublicID: Used in API responses and endpoints to securely reference user records. • Email (Natural Key): Used to ensure unique identification of users within the business logic. The mixed approach keeps your system fast, secure, and easy to understand. Thoughts?

Ok I know it's bragging but I have to 😆 It's so great to hear from @josevalim itself. If you're interested what this is about, then you can look here github.com/Valian/live_vue/b…

🚀DYK 8 - Scalability - A Tour of the BEAM (Elixir, Gleam, Erlang) on Fault-Tolerance, Concurrency, Parallelism, Distribution and Scalability Do you know that the BEAM is known to scale well in performance and design? 🧵 1/13 #MyElixirStatus #BEAMDYK #Elixir #Erlang #GelamLang