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 Trendy
- 1. Paramount 61.8K posts
- 2. Alina Habba 3,260 posts
- 3. Chargers 12.7K posts
- 4. #CHILISSKILLETQUESO N/A
- 5. Kyle 31.8K posts
- 6. Go Birds 5,409 posts
- 7. NextNRG Inc. 2,579 posts
- 8. #NXXT_DOEsupport N/A
- 9. Tim Banks 1,574 posts
- 10. #GoldenGlobes 111K posts
- 11. Warner Bros 101K posts
- 12. #SLFS N/A
- 13. Jiffy Pop N/A
- 14. Crockett 19.5K posts
- 15. #MondayMotivation 13.5K posts
- 16. The ACC 49.7K posts
- 17. Bruiser N/A
- 18. Leavitt 5,880 posts
- 19. Allred 2,954 posts
- 20. Harada 16.1K posts
Something went wrong.
Something went wrong.