2009 African Youth Championship squads
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
gollark: This lets me do this```javascriptconst getPage = name => SQL`SELECT * FROM pages WHERE name = ${name} ORDER BY updated DESC LIMIT 1`.get() || null```*without* the glaring SQL injection vulnerabilities!
gollark: ```javascriptexport const SQL = (strings, ...params) => { const sql = strings.join("?") let stmt const cachedValue = preparedStatements.get(sql) if (!cachedValue) { stmt = DB.prepare(sql) preparedStatements.set(sql, stmt) } else { stmt = cachedValue } return { get: () => stmt.get.apply(stmt, params), run: () => stmt.run.apply(stmt, params), all: () => stmt.all.apply(stmt, params), statement: stmt }}```observe some stuff from my code.
gollark: I've never written that.
gollark: They do have more brackets though, sadly.
gollark: Even my (Node.)JS programs are probably faster.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.