me_bx's comments

On: First Contact with SQLite

[me_bx]

Don't Application-Defined SQL functions fulfill the role of stored procedures?

https://www.sqlite.org/appfunc.html

[qazxcvbnm → me_bx]

Yes, but you have to write C; I am more confident in SQL, and SQL fits better with the rest of my data stack.

On: Ask HN: Who is hiring? (July 2024)

[me_bx]

Hi,the job offer is not visible publicly, wellfound.com asks for the creation of an account first. Is this on purpose?

On: Software galaxies

[me_bx]

From the same author:

  * Related subreddits graph - https://anvaka.github.io/sayit/?query=linux
  * Map of reddit - https://anvaka.github.io/map-of-reddit/?x=18239&y=12514&z=32433.55559794627&v=2

On: Build a side project using your data

[me_bx]

In case this is your project, there are some issues with the demo dashboard's bar charts (top 20 countries):

* Works well on Firefox mobile / android * On Firefox desktop, only every other country name is displayed, for some reason. The name of other countries can only be seen by hovering on the bars, in a tooltip. This kind of makes the chart not so usable * On Chromium desktop, linux (A somewhat old version, v90), the bar charts don't display at all, the error message below is shown in the console:

    Uncaught (in promise) TypeError: e.at is not a function
        at new bi (VennDiagram.svelte_svelte_type_style_lang.BQFLKn8W.js:1)
        at VennDiagram.svelte_svelte_type_style_lang.BQFLKn8W.js:4
        at /async https:/fc24.fact.ist/_app/immutable/nodes/0.vgSQbLXH.js:1
        at async Promise.all (/index 3)
        at async $p (0.vgSQbLXH.js:1)
        at async Tp (0.vgSQbLXH.js:1)
        at async Pt (entry.CN-1OTG9.js:1)
        at async ut (entry.CN-1OTG9.js:1)
        at async cn (entry.CN-1OTG9.js:1)
        at async Module.hn (entry.CN-1OTG9.js:1)

[creatuluw → me_bx]

Thanks! I will look into it.

On: An infinite canvas for code exploration

[me_bx]

+1, it's only thanks to parent comment that I realized the image is a video, and I need to right-click, select play to start playback.

On my device (Linux) no control is shown at all even in full screen.

I just thought this was a screenshot, and got disappointed that login is compulsory to try the tool, without showing anything about it beforehand.

On: Show HN: Online database diagram editor

[me_bx]

You might want to mention that it is a "data modelling tool" somewhere in the description text, as some of your target users will definitely use that term to search for such a solution...

[1ilit → me_bx]

thanks! will do

On: Show HN: Jampack – Optimizes static websites as a ...

[me_bx]

I believe the project is not maintained anymore.

Github repository is archived: https://github.com/apache/incubator-pagespeed-ngx.

Or has it perhaps moved to some other location?

[codetrotter → me_bx]

That repository links to a site https://www.modpagespeed.com/ which in turn links to a different repository https://github.com/we-amp/ngx_pagespeed

It only has one extra commit, which deletes RETIRED.txt which was added in the repo you linked.

So at the moment it seems someone is intending to continue development. And might even be working on it, but haven’t pushed any work to the main branch.

[aendruk → me_bx]

I haven’t seen a clear answer. https://news.ycombinator.com/item?id=37578513

On: Show HN: An AI-Powered WordPress Site Builder That...

[me_bx]

I'm curious about whether there are any ethics boundaries for the website generator, as the demo video posted on twitter shows that fake 5 stars "user" reviews are automatically included in the website created...

[asranihardeep → me_bx]

Depends on the context here. In our tool, we comply with OpenAI policies to avoid generating anything like hate speech and etc. For the review, you get more of a starter-content as a website admin to start customizing, not the final edit but a start point. Hope it makes sense.

On: Two scammers, a web of betrayal, and Europe's frau...

[me_bx]

A mini-series was also recently released: Of Money and Blood.

Trailer: https://www.youtube.com/watch?v=fLzlimhCdkA

[sambf → me_bx]

Based on Fabrice Arfi's book of the same name. He works at Mediapart, a french journal that outed many state scandals. He's also one of the four french members of the International Consortium of Investigative Journalists (ICIJ).

On: Show HN: SlideSynth

[me_bx]

The audio does not play on Firefox on linux, and the interactions don't seem to have any effect either.

Warning message in the console:

> An AudioContext was prevented from starting automatically. It must be created or resumed after a user gesture on the page.

On Firefox / android, this works fine.

[Apreche → me_bx]

No Audio on Firefox/MacOS either.

[amadeuspagel → me_bx]

It's only for touchscreens.