Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 5 of 5 « Previous | Next »
Displaying posts with tag: laravel (reset)
Aug
18
2021
Use Database Connection Strings with Laravel 8
Posted by Lorna Mitchell on Wed 18 Aug 2021 07:56 UTC
Tags:

I’ve been doing a lot of database stuff lately, and not much PHP, so when I returned to make my first Laravel project for a while, I had to check the docs to remind myself how some of this works. I noticed that the default approach to database credentials is still to use separate credentials for the host, port, and other variables. I’m using Aiven databases (because I work there and managed databases are great for demo apps as well as real ones!) which supply connection strings, but Laravel supports these too.

For MySQL, the database connection string from Aiven is in the format: 

mysql://username:password@hostname:port/dbname

You can remove the configuration for DB_* and instead use the variable DATABASE_URL with the full string.

Pro-tip: Laravel’s built …

[Read more]
Jun
29
2019
Laravel CRUD Example with jQuery Datatable
Posted by parvez alam on Sat 29 Jun 2019 08:56 UTC
Tags:

This laravel tutorial help to add CRUD operation with datatable, I will just share laravel code to create new record, edit record and delete record. I have already shared How To Use jQuery Datatable With Laravel.We have integrated jQuery datatable with laravel. We will cover following functionality in this laravel tutorial : Create record Template […]

The post Laravel CRUD Example with jQuery Datatable appeared first on Phpflow.com.

Aug
31
2017
Complete Megalist: 25 Helpful Tools For Back-End Developers
Posted by Hovhannes Avoyan on Thu 31 Aug 2017 15:11 UTC
Tags:

 

The website or mobile app is the storefront for participating in the modern digital era. It’s your portal for inviting users to come and survey your products and services. Much attention focuses on front-end development; this is where the HMTL5, CSS, and JavaScript are coded to develop the landing page that everyone sees when they visit your site.

 

But the real magic happens on the backend. This is the ecosystem that really powers your website. One writer has articulated this point very nicely as follows:

 

The technology and programming that “power” a site—what your end user doesn’t see but what makes the site run—is called the back end. Consisting of the server, the database, and the server-side applications, it’s the behind-the-scenes functionality—the brain of a site. …

[Read more]
Jan
26
2017
Working with JSON in MySQL
Posted by Scotch.io on Thu 26 Jan 2017 17:57 UTC
Tags:

SQL databases tend to be rigid.

If you have worked with them, you would agree that database design though it seems easier, is a lot trickier in practice. SQL databases believe in structure, that is why it's called structured query language.

On the other side of the horizon, we have the NoSQL databases, also called schema-less databases that encourage flexibility. In schema-less databases, there is no imposed structural restriction, only data to be saved.

Though every tool has it's use case, sometimes things call for a hybrid approach.

What if you could structure some parts of your database and leave others to be flexible?

MySQL version 5.7.8 introduces a JSON data type that allows you to accomplish that.

In this tutorial, you are going to learn.

  1. How to design your database tables using …
[Read more]
Oct
07
2016
LaraconEU video
Posted by Gabriela D'Ávila on Fri 07 Oct 2016 17:30 UTC
Tags:

This is the video from LaraconEU 2016 on Making the Most out of MySQL.