Recently found one of my test failing due to my inmemory SQLite  database not enforcing foreign key constrains. Googled around and found a solution for it, reposting that solution here so i can easily find it in the future, and that other people can more easily find a copy-pastable solution.   Put the following code in your AppServiceProvider file within the boot() method:   Source: https://stackoverflow.com/questions/31228950/laravel-5-1-enable-sqlite-foreign-key-constraints
Read more [...]

Ngrok is a neat way to provide webdev clients or colleagues with a preview link to your local web server without having to deal with port forwarding or deploying to a separate dev environment. I don't like writing lots of fluff just for the sake of exceeding the magic 500 word seo threshold, so let's look at some realistic scenarios for this tool. Tunneling to a Virtual host I often use custom whatever.local domains when I am developing new websites and applications, I point these domains to
Read more [...]

I recently tried to solve a problem of checking if a certain user was available for work within a certain time period based on other entries in a table containing start and end dates. When searching online I didn't find quite as much information as I had hoped, however found a very useful illustration that helped me visualize the problem more easily   From this i wrote the following SQL code     Another interesting problem I had
Read more [...]

When developing locally, I often like to separate my projects with a separate domain name like helgesverre.local and clientwebsite.local etc. It's fairly easy to get this working using XAMPP, however it might be daunting to try to research this on your own if you don't know what you're looking for, so I will teach you how to do it, ain't I nice? :)   What you need to do is to open the following file in a text editor C:\xampp\apache\conf\extra\httpd-vhost.conf It will look something like
Read more [...]