HNHacker News
TopNewBestAskShowJobs

lfconsult

11 karma · joined December 27, 2022

https://github.com/TeddyBear06
submissionscomments
lfconsult··on Tracking SQLite Database Changes in Git
Awesome...! Thanks for sharing!
lfconsult··on Geospatial SQL queries in SQLite using TG, SQLite-tg and datasette-SQLite-tg
Awesome! Another nice gift for the open source community. I'll try it out soon.
lfconsult··on I'm fed up with it, so I'm writing a browser
Great, thanks for sharing!
lfconsult··on Tell HN: ChatGPT Can Decode Base64
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.

lfconsult··on Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalent for other DBMS?
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.

lfconsult··on Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalent for other DBMS?
Thank you for your answer.

It makes sense.

I didn't catch the "client side" part as you do, thanks for the explanation.

lfconsult··on Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalent for other DBMS?
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

lfconsult··on Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalent for other DBMS?
Thank you for your answer.
lfconsult··on Ask HN: Is there is an sqlite3_expanded_SQL()'s equivalent for other DBMS?
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?

lfconsult··on GNU Parallel, where have you been all my life?
Wonderful... Thanks for sharing.
lfconsult··on Unesco calls for global ban on smartphones in schools
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.
lfconsult··on Hurl 4.0.0
I really do love this project . Using it in production for testing purposes. Great job guys.
lfconsult··on Mailpit – An email and SMTP testing tool with API
I use it on daily basis. Wonderful tool. Supports attachements. A must have.
lfconsult··on Hurl, a terrible (but cute) idea for a language
Right.
lfconsult··on MiniMit – Bringing Minitel back to life
Wonderful project.

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

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

Edit: They are working on a v1.1 and they want to release it soon. Keep following the repo.

lfconsult··on An Excel error led Austria's SPÖ to announce the wrong candidate as the winner
Incredible story.
lfconsult··on All Your Licensing Are Belong to Us^W You
Great news! Congratulations for open sourcing it! Hope the best for the future.

Edit: I'm a happy user ;-)

lfconsult··on Show HN: YouTube Full Text Search – Search all of a channel from the commandline
Fixed.
lfconsult··on Show HN: YouTube Full Text Search – Search all of a channel from the commandline
Fixed.
lfconsult··on Show HN: YouTube Full Text Search – Search all of a channel from the commandline
You're right. Thanks for sharing the link to your full-text search helper, really neat.
lfconsult··on Facebook claims people showing art, electronics, wheelchair mods is hate speech
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.
lfconsult··on Show HN: YouTube Full Text Search – Search all of a channel from the commandline
Probably due the YouTube cookies consent page.

I opened an issue:

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

Hope it helps.

lfconsult··on Show HN: YouTube Full Text Search – Search all of a channel from the commandline
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.

lfconsult··on Facebook claims people showing art, electronics, wheelchair mods is hate speech
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.
lfconsult··on Spotify sleep timer seems gone on Android
Since today, the Spotify sleep timer is not available anymore on Android app.
lfconsult··on Laravel 10 Bug Hunt
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.
lfconsult··on Simple WiFi QR code reader for Windows
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".
lfconsult··on Ask HN: Is anyone else getting spammed via GitHub recently?
Got exactly the same content schema.
lfconsult··on Ask HN: Is anyone else getting spammed via GitHub recently?
Yes, just happened this morning... First, I received a GitHub notification without tag (I even didn't know how is it possible) then I was tagged in a comment to a README "I’m completely nak*d Wanna see the photo" plus a link (obviously)...

Edit: It's in the "Discussions" GitHub tab.

Edit: Got a GH response:

"Our review of the account(s) and/or content named in your report has concluded. We have determined that one or more violations of GitHub’s Terms of Service have occurred and have taken appropriate action in response."

lfconsult··on Show HN: Merry Sky, Dark Sky replacement and merry-timeline open source lib
Wonderful piece of work. Clear and fast. Didn't know pirateweather before. Thanks for sharing.
Page 1 of 2Next →