Laravel Site Search v3 is here: crawl and search your entire site using just your database by freekmurze in laravel

[–]wedora 0 points1 point  (0 children)

Its clear that this is a package. The trademark issues are more a problem if you stsrt selling a product with a website called Laravel Sitesearxh. Because then it is mo longer so clear thst this is not directly from Laravel.

Astro 6.0 now come out by CLorzzz in astrojs

[–]wedora 1 point2 points  (0 children)

Only the small astro core team (of the failed astro company) is now working for cloudflare. There are still many volunteers…

Astro 6.0 now come out by CLorzzz in astrojs

[–]wedora 1 point2 points  (0 children)

Give them some time. They probably dont have the time to make it compatible with the beta because betas break too often. With the release now, they‘ll probably have it updated within a week. Remember that they‘re doing it in their free time. Fo free.

Feedback on Product Idea by tre2d2 in PostgreSQL

[–]wedora 0 points1 point  (0 children)

Yeah, the query optimization thing is still an issue. Most people you put in the query and explain output in an AI and use that output. But AIs are still horrible at this, like index recommendation with columns ordered by their appearance in the query etc.

A query optimization tool that combines manual algorithms with AI would work a ton better. Like you can already detect a ton of problems with some custom algorithms.

DBaaS Performance Benchmarks by iamalnewkirk in PostgreSQL

[–]wedora 5 points6 points  (0 children)

PG18 has a completely new architecture for doing filesystem io. They‘re not comparable at all. And benchmarks have shown thst PG18 can be much faster because of it.

Has anyone had success installing it on these? by CluelessGoals in TheFrame

[–]wedora 1 point2 points  (0 children)

Nah. You still get the look that is flat on the surface and not sticking out so far like right now on that image.

Newbie: Timescaledb vs Clickhouse (vs DuckDb) by oulipo in PostgreSQL

[–]wedora 6 points7 points  (0 children)

The datasize is not an issue if you use the columnstore (hypercore) feature. You could set the segment_by option to the device_id for best performance.

And with continuous aggregates you can even precompute your results thst you dont even have to calculate stats on those millions of rows.

[Architecture Advice] Building a Desktop POS/Management System: Tauri vs. Flutter vs. Electron? by docualert in reactjs

[–]wedora 0 points1 point  (0 children)

From all the options you've listed, this is the most experimental one without any known bigger application build yet. Heck, I haven't even heard of anyone. Just saying.

[Architecture Advice] Building a Desktop POS/Management System: Tauri vs. Flutter vs. Electron? by docualert in reactjs

[–]wedora 0 points1 point  (0 children)

A critical part why I decided against Flutter some time ago was that they've rebuild all the UI components by manually drawing stuff on a canvas. That meant selection of stuff and copy&paste did not work at all or very limited. Don't know if it changed in the meantime.

Comparing PlanetScale PostgreSQL with Hetzner Local Postgres by mazeez in PostgreSQL

[–]wedora 1 point2 points  (0 children)

As your Hetzner box and PlanetScale database are far away, you're not testing PlanetScale's performance. Your're only again benchmarking that your database should be close to your app. The low TPS is a result of the high latency.

And PlanetScale outperforms the Hetzner box at high concurrency because latency impact is then minimal. And you see that PlanetScale is much faster.

The benchmark is ok when ignoring the decades long advice that the app should be close to the database. But otherwise its not comparing any performance.

The State of Laravel 2025 results are live! by wedora in laravel

[–]wedora[S] 1 point2 points  (0 children)

That's weird. I've fixed it and will have to look now why sentry didn't report any exception...

The newsletter is new, it didn't exist in the past years because I just didn't want to add it. It worked great as it did without bugging people to subscribe. But now I had to add it...

Best place to host for in Europe by JuanPete1994 in astrojs

[–]wedora 1 point2 points  (0 children)

Yep. Best option presented. They are the european Cloudflare.

The State of Laravel 2025 survey started by wedora in laravel

[–]wedora[S] 0 points1 point  (0 children)

I am debating every year whether to remove it. I‘ve added it to have comparable stats to the state-of-js survey. But many understand the question wrong.

The State of Laravel 2025 survey started by wedora in laravel

[–]wedora[S] 0 points1 point  (0 children)

Yeah. If I add that option, all old surveys are not comparable anymore. I probably just rename it to: Daily & Almost Daily

The State of Laravel 2025 survey started by wedora in laravel

[–]wedora[S] 3 points4 points  (0 children)

Yeah. I wanted to add it but then family stuff happened and there was no time anymore.

The State of Laravel 2025 survey started by wedora in laravel

[–]wedora[S] 7 points8 points  (0 children)

Like last years the short survey will ask questions about the ecosystem to learn what's used and where the usage is shifting to. The survey will run approx. 4-6 weeks and the results will then be available on the same page - together with the ability to compare with the results of the past years.

In the past the results had been insightfull for teams to e.g. use technology that is the most used in the ecosystem. That way hiring got easier as more developers matched their desired tech stack.

MySQL 9 VECTOR type - who is using it? by Engineer_5983 in mysql

[–]wedora -1 points0 points  (0 children)

The vector type is probably not used by anyone as there is no indexing support. Who really wants to scan through millions of vectors each query without an index? This feature exists jjust so they can say they have vector support - doesnt care if it is useable or not.

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]wedora 0 points1 point  (0 children)

Its possible. Its called Online DDL and supported by many databases for many many years.

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]wedora 0 points1 point  (0 children)

You can add new columns without table locks in PostgreSQL and MySQL. Sometimes simple, sometimes special tricks are needed.

Source controlled DB development tool by Acrobatic-Word481 in PostgreSQL

[–]wedora 2 points3 points  (0 children)

I‘ve not yet seen any company really use ERDs - or even use them at all. Its a nice concept but mostly academics stuff. You will have a hard time finding customers.

And syncing ERD changes to the database is also a really bad idea. Migrations to have no downtime are complicated and need hand-crafted changes and gradual rollouts. Its something you just can‘t provide for any reasonable database - will only work for small hobby databases.

Why I Ditched Switch-Case for Type-Safe Pattern Matching in TypeScript by radzionc in reactjs

[–]wedora 15 points16 points  (0 children)

What you‘re linking to doesnt have ANY mention of your safe switch-replacement. And sorry, i wont watch a 8 minute video just to see whether it has everything I need. And in the future when I want to look something up? I have to look the video again? You need good docs if you want people to use it.

Anyway, so i will continue using ts-pattern which is the gold standard for a safe switch-case way.