News for hackers. Stuff that matters.

lfconsult

Re:Tracking SQLite Database Changes in Git on Thursday November 02, 2023 @05:47AM (#38111106)
Awesome...! Thanks for sharing!
Awesome! Another nice gift for the open source community. I'll try it out soon.
Re:I'm fed up with it, so I'm writing a browser on Friday September 22, 2023 @03:14AM (#37608896)
Great, thanks for sharing!
Re:Tell HN: ChatGPT Can Decode Base64 on Thursday September 21, 2023 @05:48PM (#37604885)
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?

Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalent for other DBMS?

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...

( Read More... | 9 comments | 2 points | on HN )
Re:GNU Parallel, where have you been all my life? on Monday August 21, 2023 @08:12AM (#37208403)
Wonderful... Thanks for sharing.
Re:Unesco calls for global ban on smartphones in schools on Wednesday July 26, 2023 @09:38AM (#36877492)
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.
Re:Hurl 4.0.0 on Friday June 30, 2023 @05:49PM (#36542841)
I really do love this project . Using it in production for testing purposes. Great job guys.
Re:Mailpit – a better way for email testing on Saturday June 24, 2023 @02:53AM (#36456250)
I use it on daily basis. Wonderful tool. Supports attachements. A must have.
Re:Hurl: A terrible but cute idea for a language on Monday June 19, 2023 @04:25PM (#36396052)
Right.
Re:MiniMit – Bringing Minitel back to life on Monday June 19, 2023 @05:11AM (#36388933)
Wonderful project.

Does anybody knows something about source code release (as stated in the GitHub repo)?

https://github.com/multiplie-fr/minimit

Incredible story.
Re:All Your Licensing Are Belong to Us^W You on Thursday June 01, 2023 @04:29PM (#36156932)
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.
Probably due the YouTube cookies consent page.

I opened an issue:

https://github.com/NotJoeMartinez/yt-fts/issues/1

Hope it helps.

This tool itself does works great.

This behavior is due to the YouTube cookies consent page.

I opened an issue about this specific issue: https://github.com/NotJoeMartinez/yt-fts/issues/1

Glad if you want to help.

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.
Re:Spotify sleep timer seems gone on Android on Tuesday January 17, 2023 @05:43PM (#34420573)
Since today, the Spotify sleep timer is not available anymore on Android app.
Re:Laravel 10 Bug Hunt on Wednesday January 11, 2023 @08:13AM (#34337997)
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.
Re:Simple WiFi QR code reader for Windows on Thursday December 29, 2022 @08:30AM (#34172399)
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".

Older »