lfconsult
lfconsult on Hacker News
Awesome...! Thanks for sharing!
Awesome! Another nice gift for the open source community. I'll try it out soon.
Great, thanks for sharing!
Does ChatGPT integrates basics known encoders/decoders aside from LLM (if not, I thought that it was the case)?
Base64 is about encoding not hashing... So decoding it is... natural. The point here is that it's integrated inside ChatGPT? It seems to me that it's an "obvious" "feature" kind of.
Exact, it's not what I'm looking for but it's interesting anyway, thank you for your answer and the links.
It's a bit weird but I'm using a langage (for a specific project) where prepared statements aren't available (except if you pay or use a specific DBMS, I can't do both because the client won't pay and I need SQLServer).
My initial idea was to use a DLL from PDO (I'm developping on a Windows env) or whatever known piece of code that is trustable in order to sanitize user inputs (of course we do it client side but user is devil :-)) before sending it to SQLServer.
After all answers and my researches, I think that I'll use a tiers piece of code to escape queries (probably a C# program using SQLCommand).
Thanks all.
If anybody knows exactly how SQLServer is handling SQL Statements, please let us know.
Thank you for your answer.
It makes sense.
I didn't catch the "client side" part as you do, thanks for the explanation.
Side note: The result of sqlite3_expanded_sql() is a pointer to the string containing the SQL statement with bound parametrer(s):
"The string returned by sqlite3_expanded_sql(P) [...] is obtained from sqlite3_malloc() [...]"
From SQLite documentation: https://www.sqlite.org/c3ref/expanded_sql.html
Thank you for your answer.
Thank you for your answer.
I'm still wondering why it's not available for SQLServer (because there are use cases for this feature).
It is "just" a matter of driver interface (I mean the piece of code that implement ODBC API) that "just" do not give this feature or it's letteraly not possible with SQLServer?
Posted by
lfconsult on Tuesday September 19, 2023 @04:08PM
from the ask-hn dept.
Hi HN,I'm digging around in order to find a way to get back the SQL statement from a compiled statement with bound parameters (avoid SQLi) for others DBMS.I've found - with excitements- that the SQLite C interface have a sqlite3_expanded_sql()* function to get exactly what I needed.As I didn't found anything for SQLServer, I thought - at first - that it was just not possible at all because the...
Wonderful... Thanks for sharing.
Well, I'm not supporting this. Our society try to ban everything. I believe education is better than repression. Ok, it takes time but it worth it.
I really do love this project . Using it in production for testing purposes. Great job guys.
I use it on daily basis. Wonderful tool. Supports attachements. A must have.
Great news! Congratulations for open sourcing it! Hope the best for the future.
Edit: I'm a happy user ;-)
You're right. Thanks for sharing the link to your full-text search helper, really neat.
Really interesting toughts, thanks for sharing. You're right, around me anybody has left Facebook except me. Do I feel worse about that, not at all.
Just leave thoose platforms (Facebook, Twitter, etc...). Really... If no users, no ads, no money then the platform disappear... And voilà! If a trusted and trustfull post from Adafruit is not allowed to be public, imagine what can be "censored" too.
Posted by
lfconsult on Tuesday January 17, 2023 @05:43PM
from the community.spotify.com dept.
Since today, the Spotify sleep timer is not available anymore on Android app.
Nice move from Laravel, but the fact that it's a contest with only one winner (if I'm not mistaken) doesn't motivate me enough to spend time on it... Thanks for sharing anyway, Laravel rocks.
Hi HN,
Just wanted to share a simple - yet useful - tool.
It's able to decode a WiFi QR code and copy its password directly in your clipboard.
Usefull when you need to connect à new network and you've a WiFi QR code under your hands.
Just show the QR code in front of your webcam (required obviously) and the tool decode it for you.
The tool is open source so build your version if you does not trust mine :-)
Edit: It also respect your privacy as no data is sent anywhere and nothing is recorded, decoding is done "on the fly".
Posted by
lfconsult on Thursday December 29, 2022 @08:30AM
from the github.com dept.