Make SQL Queries Secure in Python
Ғылым және технология
Today we learn how to design secure SQL queries in Python when working with SQLite3.
◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚
🐍 The Python Bible Book: www.neuralnine.com/books/
💻 The Algorithm Bible Book: www.neuralnine.com/books/
👕 Programming Merch: www.neuralnine.com/shop
🌐 Social Media & Contact 🌐
📱 Website: www.neuralnine.com/
📷 Instagram: / neuralnine
🐦 Twitter: / neuralnine
🤵 LinkedIn: / neuralnine
📁 GitHub: github.com/NeuralNine
🎙 Discord: / discord
🎵 Outro Music From: www.bensound.com/
Пікірлер: 22
Hello, can you make a tutorial on how to make async Api calls in background using any web framework of Python?
Thank you! I had always read one should use prepared statements because they are more secure but I never saw HOW they were more secure explained so neatly.
Thanks for the simple explanation! It's really valuable!
Your content is always top notch! Thanks!
Wow, crazy speed and well explained. Thx
I prefer to use APSW rather than the standard SQLite3 module that comes with Python. Also, here is a handy generator function I like to use, that performs a query and lets you iterate over the returned rows, putting them through an optional mapping function (e.g. turning the row tuple into a dict mapping field names to values) before returning them: def db_iter(conn, cmd, values = None, mapfn = lambda x : x) : for item in conn.cursor().execute(cmd, values) : yield mapfn(item) ♯end for ♯end db_iter
Great content 💯
Can you do a video about password authentication from the database but with hash encryptions
great, excellent video. Maybe just slow down when executing and swapping window. Otherwise great.
it is so usefull for me...i was beggining to learn this database and python connection....Can you direct me some free database hosting solutions for begginers and how to use them ?
Thank you
It was interesting
I'd love more windows file handling tutorials. Your file renamer was ace.
@Trazynn
Жыл бұрын
Maybe constructing pdf's in bulk but with dynamic content, like giving people a certificate with their name and their score in it or something.
@lawrencedoliveiro9104
Жыл бұрын
The Cairo graphics library lets you render graphics calls to different kinds of target surfaces, including PDF, SVG and PostScript files.
Does it work for python/mysql connector? Also, how is this different from f-string or .format()?
What’s the name of the sql syntax highlighting extension?
Hi, I have a similar problem but it concerns the tables' name. I need to create many, many tables (each table for separate stock data and stock name is a table name). How can I put into my SQL query table name as variable, but without breaching the sanitation rule?
@jimmynoosetron6518
Жыл бұрын
Do the thing where you
@lawrencedoliveiro9104
Жыл бұрын
That’s a, shall we say, suboptimal way to do it. Given that the structure of the data is the same for all stocks, have just one table, and add the stock ID as a column to the table.
Hi
TEACH ME HOW TO BE A l33t h4x0rs