Patrik Ahlström

Minor Hifi geek, Major IT Geek and music lover.

Sporadic blogger about Laravel and Database related topics.

@laracasts forum O.G.

[Patrik Ahlström @tray2_se]

@MrPunyapal One way around that is to use computed columns. That way you can index that column and get away with filtering on the year alone. Like always it depends on the need.

[Patrik Ahlström @tray2_se]

@patilvishi Select your gift from the basket.

From the basket select your gift.

I think the ”natural” flow is how you structure a sentence in you native language.

For example in german the verb is the last word in the sentence.

Your gift from the basket select.

[Patrik Ahlström @tray2_se]

@Akintola_steve I wrote a post on that for Laravel a few years back.

https://t.co/U4TCdNltPB

[Patrik Ahlström @tray2_se]

@Akintola_steve It depends, but I think of ORMs as a way to make the code more readable, and complex queries makes a mess regardless if you use ORM och plain SQL.
In such cases I use views, and then I can keep the ORM simple and readable, and tuck the SQL into a migration

[Patrik Ahlström @tray2_se]

@ImLunaHey It's a skill to de-technicalize complex things, and it takes a lot of patience to learn it.

[Patrik Ahlström @tray2_se]

@krunalbuilds Depends on the application, but I would likely do a hybrid.

Step 1. Inactivate the user.
Step 2. Delete the user after x days.

[Patrik Ahlström @tray2_se]

@simonhamp @aarondfrancis One of my favorite comedies, love when they drive on the railroad track, and then orders flapjacks.

[Patrik Ahlström @tray2_se]

@marcelpociot I wish

[Patrik Ahlström @tray2_se]

@SumitM_X No. Sooner or later your db will be slow due to too much data in the tables.

[Patrik Ahlström @tray2_se]

@marcelpociot @asumikam @kotomin_m That is awesome. If you haven't seen Gojira yet, I highly recommend it.

[Patrik Ahlström @tray2_se]

@javarevisited Nothing really, other that the formatting and the readability, and IN(1, 2, 3) would have been easier to read.

[Patrik Ahlström @tray2_se]

@SumitM_X That is called a hacker's wet dream.

[Patrik Ahlström @tray2_se]

@neerajjj6785 Json should almost never be used inside the database. The only reason I see valid for storing it there, is when you receive a big payload from an API and you process it with a schedule job, rather them at once.

[Patrik Ahlström @tray2_se]

@javarevisited Mute the CEO.

[Patrik Ahlström @tray2_se]

@EOEboh Nope, binary data does not belong in the db, it belongs on the file system.

[Patrik Ahlström @tray2_se]

@MrPunyapal I can not agree more.

[Patrik Ahlström @tray2_se]

@Umesh__digital If you have one key in your pocket, it's fast to get it, if you have 100 keys in your pocket, how long does take to get the correct key?

[Patrik Ahlström @tray2_se]

@christophrumpel The UX of many form inputs is really bad.

[Patrik Ahlström @tray2_se]

@ashoKumar89 Regular integers, faster and takes less space.