pvergain (framapiaf)
boosted
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14
![export const addUser = (connection)=>{
router.post('/api/data/add/user', (req, res)=>{
const data = req.body;
connection.query(
'INSERT INTO usertable (FirstName, LastName, Username, AccessCode, UserEmail) VALUES (?,?,?,?,?)',
[data.FirstName, data.LastName, data.Username, data.AccessCode, data.UserEmail],
(err, results)=>{
if(err){
console.error(err);
res.status(500).json({error: 'Database insertion (User) failed'});,→
return; }
res.json({ success: true, id: results.insertId});
})
})
return router;
}](https://storage.googleapis.com/hci-social-storage/media_attachments/files/115/705/822/541/082/441/original/b40a9e8b62dc0d82.png)