SQL input sanitization

I’m a relative newcomer to web technology, and I thought I’d play around with it a bit in my favorite language for numeric computing. I need a DB to back the project I’m playing with, so I’m also learning a bit of SQL in the midst of all of this.

One thing that repeatedly comes up is protecting against SQL injection, which it looks like many wrapper libraries in other languages have special functions to do that for users. I don’t seem to see functions in any of the https://github.com/JuliaDatabases packages for doing that. Anybody have advice on dealing with SQL sanitization in Julia or links to resources teaching how to sanitize strings for SQL from scratch?


1 Like

You can prepare statements with LibPQ.jl.