PHP Reddit – Telegram
PHP Reddit
34 subscribers
292 photos
37 videos
24.9K links
Channel to sync with /r/PHP /r/Laravel /r/Symfony. Powered by awesome @r_channels and @reddit2telegram
Download Telegram
Looking for work... 15+ years experience

I have more than 15 years of experience. Message me if you know of a position. Thanks

https://redd.it/1jt4zvp
@r_php
Weekly Ask Anything Thread

Feel free to ask any questions you think may not warrant a post. Asking for help here is also fine.

https://redd.it/1jtbqut
@r_php
Weekly help thread

Hey there!

This subreddit isn't meant for help threads, though there's one exception to the rule: in this thread you can ask anything you want PHP related, someone will probably be able to help you out!

https://redd.it/1jtedf1
@r_php
How much Livewire is too much Livewire

Kind of a philosophical question here I guess. I am probably overthinking it.

Backstory: I am a well versed Laravel dev with experience since v4. I am not a strong front end guy, and over the years never really got on board with all the javanoscript stuff. I just haven't really loved it. I have been teaching myself Vue and using it with Inertia and I actually like it a lot, but find myself incredibly slow to develop with it. Obvious that will change over continued use and experimentation, but sometimes I want to "just ship."

So I started tinkering with Livewire finally, and I understand the mechanics of it. I am actually really enjoying the workflow a lot and how it gives me some of the reactivity I am looking for in a more backend focused way. But I am curious if there's any general thoughts about how much Livewire is too much Livewire, when it comes to components on a page.

For example: In my upper navigation bar I have mostly static boring links, but two dropdowns are dynamic based on the user and the project they are working on. As I develop this I have made each of those dropdowns their own components as they are unrelated. This feels right to me from a separation of concerns standpoint, but potentially cumbersome as each of these small components have their own lifecycle and class/view files in the project.

I kind of fear if I continue developing in this manner I'll end up with a page that has 10, or more, components depending on the purpose/action of the page. So my question to the community and particularly to those who use a lot of Livewire. Does this feel problematic as far as a performance standpoint? Should my navigation bar really just be a single component with a bunch of methods in the livewire class for the different unrelated functions? Or is 10 or so livewire components on a page completely reasonable?

https://redd.it/1jtvt32
@r_php
Breeze: React (JSX) + Inertia + Laravel + NO Tailwind

Hey r/PHP ! (New here).

Quick question: Does anyone have a link to a starter kit, boilerplate, or public repo for Laravel + Inertia + React (JSX/JS) that sets up auth scaffolding (like Breeze) but comes without Tailwind CSS?

I'm looking to use vanilla CSS / CSS Modules and want to avoid the tedious process of manually removing all the Tailwind className attributes from the default Breeze components and all the UI add-ons. Just need a clean starting point with the routes and the auth but with minimal code and preferably not styling at all.

Any pointers to existing solutions or recomendations would be amazing!

Thanks you very much.

https://redd.it/1jtxinm
@r_php
Should I Learn Node.js First and Then Move to PHP, or Study Both at the Same Time?

Should I learn Node.js first and then switch to PHP, or should I study both at the same time?

https://redd.it/1ju9wtw
@r_php
Avoid Using SQLite in Development Unless It's Also Used in Production

Using SQLite as the dev database is a trend in the Laravel community nowadays. On the other hand, SQLite was promoted as the default database in the framework. But I’ve experienced unexpected issues with this practice, and I don't want others to face the same.

It might be fine if you only use query builder methods, but even then, there are issues. For instance, if you're familiar with FULLTEXT indexes in MySQL and try to use them in a SQLite dev database, you'll get an error since SQLite doesn't support them. You'll have to take some additional steps like following.

// migrations
if (in_array(DB::connection()->getName(), ['mariadb', 'mysql', 'pgsql'])) {
$table->fullText(['noscript', 'text']);
}

// controllers
if (in_array(DB::connection()->getName(), ['mariadb', 'mysql', 'pgsql'])) {
return $this->builder->whereFullText(['noscript', 'review'], $this->value);
}

If you are developing a large-scale project, you can't limit yourself to using only the query builder especially when you have dashboards. Recently, we shipped a project(uses MySQL in production and SQLite in dev) to production. This was a project with a very limited time frame, so we didn't have much time to plan properly. In fact we rushed to development. Everything worked as expected in the development environment and all tests passed. But then, our clients started reporting server errors. We had to spend a considerable amount of time and effort debugging it since it was so unexpected. At first, we thought it was an issue with our server, but eventually, we found the culprit in the following line.

$query->selectRaw(
"SUM(amount) as amount,
SUM(CASE WHEN type = ? THEN amount END) as infinite,
SUM(CASE WHEN type = ? THEN amount END) as recurring,
strftime('%Y-%m', subscribed_at) AS interval",
[SubnoscriptionType::Infinite->value, SubnoscriptionType::Recurring->value]
);

Can you spot the issue? Don’t worry if you can’t, most of us aren’t DB experts. It was `strftime('%Y-%m', subscribed_at) AS interval`. MySQL doesn’t have a `strftime` function, so we had to change it to MySQL equivalent `DATE_FORMAT(subscribed_at, '%Y-%b') AS \`interval\``.

So the final MySQL equivalent is:

$query->selectRaw(
"SUM(amount) as amount,
SUM(CASE WHEN type = ? THEN amount END) as infinite,
SUM(CASE WHEN type = ? THEN amount END) as recurring,
DATE_FORMAT(subscribed_at, '%Y-%b') AS `interval`",
[SubnoscriptionType::Infinite->value, SubnoscriptionType::Recurring->value]
);

This is just one instance. There are many differences between MySQL and SQLite.

Conclusion: **Use a production database system in development environments**.

Finally we'd better use follow practice: **Use a production-equivalent environment as much as possible in development (not limited to the database)**.

I'd love to hear your thoughts.

https://redd.it/1jubxrg
@r_php