The biggest turn off with Google login is when you use it for a third party app, you cannot share that access with anyone. They will need to log in with Google too, which means giving Google access to all their data. There is no way to just share the app itself.
A better UI and improved search functionality would be a great start for making GitHub better. @jaredpalmer
ChatGPT just launched Atlas, a browser with AI built in. It reads pages, cites sources, remembers context, and can even act using agent mode to book, research, and organize. Rolling out on macOS now with Windows, iOS, Android coming soon. #ChatGPT #Atlas
🚀 PostgreSQL pro tip: You can make columns auto-compute themselves 👇 CREATE TABLE users ( first_name text, last_name text, full_name text GENERATED ALWAYS AS (first_name || ' ' || last_name) STORED ); 💡 Auto-updates when data changes ⚡ Indexable 🧠 No triggers
API design is 70% planning and structuring the database, 20% implementing the routes, and 10% testing to make sure everything actually works. #APIs
App idea: A simple notes app that fits your lifestyle, summarizes your thoughts, reminds you when needed, and helps you learn in your own way. No matter if you're a programmer, student, designer, or just trying to stay organized, it's made for you. #ai #startupcommunity
0.1 + 0.2 in JavaScript 👀 console.log(0.1 + 0.2) // 0.30000000000000004 ⚠️ Binary floats can't store 0.1 exactly ⚠️ Happens in most languages, not just JS ✅ For money: use integers (cents) ✅ For comparisons: check if difference < 0.00001
PostgreSQL MONEY type 👀 ⚠️ Formatting depends on locale settings ⚠️ Only handles one currency per database ⚠️ Limited math operations NUMERIC(19,4) is more common now: ✅ Precision control ✅ Works with any currency ✅ Better for calculations
EXCLUDED in PostgreSQL 👀 References the row you tried to insert during conflicts: INSERT INTO stats (id, views) VALUES (1, 5) ON CONFLICT (id) DO UPDATE SET views = stats.views + EXCLUDED.views; ✅ Increment instead of replace ✅ Cleaner upserts ✅ Access attempted values
satisfies in TypeScript 👀 Checks types but keeps literal values: const routes = { home: '/', user: '/user' } satisfies Record<string, string> ✅ Type validation ✅ routes.home stays '/' not string ✅ Better than 'as' casting
Gapless IDs 👀 ✅ Ticket table with SELECT ... FOR UPDATE Example: UPDATE tickets SET id = id + 1 RETURNING id; ✅ Manage sequencing in application logic with proper locking (e.g. Redis INCR or a mutex) ⚠️ Keep in mind: gapless IDs = higher contention + slower writes
PostgreSQL SERIAL creates gaps when transactions fail 😵 If you need gapless IDs, don't use SERIAL 🚫 Only use it when gaps are fine 👍 Next: better ways to handle sequential IDs 👀
PostgreSQL SERIAL creates gaps when transactions fail 😵 If you need gapless IDs, don't use SERIAL 🚫 Only use it when gaps are fine 👍 Next: better ways to handle sequential IDs 👀
if you vibe with typescript + backend + postgresql, hit follow 👀 posting dev stuff from tomorrow, let’s ship 🚀 #typescript #OpenSource
United States Тренды
- 1. Miami 79.9K posts
- 2. Marcel Reed 2,353 posts
- 3. Carson Beck 3,174 posts
- 4. Dawson 6,383 posts
- 5. Isak 31.3K posts
- 6. Toney 3,982 posts
- 7. Romero 18.9K posts
- 8. St. John 6,017 posts
- 9. Lowe 9,318 posts
- 10. Liverpool 68.2K posts
- 11. Clinton 468K posts
- 12. Aggies 3,892 posts
- 13. Jayden Quaintance 2,050 posts
- 14. #CFP2025 N/A
- 15. #GoCanes 7,823 posts
- 16. Fletcher 5,870 posts
- 17. Carter Davis N/A
- 18. #TOTLIV 19.9K posts
- 19. Wirtz 30.2K posts
- 20. Tottenham 31.4K posts
Something went wrong.
Something went wrong.