I did get No supported encrypter found The cipher and or key length are invalid error when i clone my laravel project But when i run project on browser i was getting this error i did try to solve this error finally i found bellow error you can generate application key by using bellow command
This is more one post on mysql query I dont remember exactly time but i had need to change name of foreign key constraint column field We can rename field name easily if we didnt set foreign key constraint But if you set foreign key constraint then you cant rename easily I had rename directly
This is more one post on mysql query I dont remember exactly time but i had need to change name of foreign key constraint column field We can rename field name easily if we didnt set foreign key constraint But if you set foreign key constraint then you cant rename easily I had rename directly
Using Docker for development is a great way of ensuring that what you develop will be the same that you deploy in production. This is true for almost everything. If you develop on Linux, the above statement holds. If you develop on a different operating system (OSX or Windows) there are several restrictions.
I showed one of those issues in a recent article (MySQL and Docker on a Mac: networking oddity.) When you want to export a port from a service running in the container, the exported port is not available in your mac, but in the virtual machine that runs Docker services. This happens with any application that listens to a port.
The second limitation I found affects only MySQL, and it is related to using volumes. The proper way of achieving data persistence with …
[Read more]Sometimes we require to get randomly data using laravel query builder you can use mysql rand with order by If you want to get random data using laravel eloquent then we need to use DBraw In bellow example you can i use DBrawIn this example i use DBrawRAND inside orderBy an
In an industry as fast-growing and interconnected as database technology’s, it’s exciting to track how innovations in one platform can ignite beneficial, rippling effects on other, surrounding systems. At VividCortex we frequently find ourselves faced with opportunities to improve our monitoring solutions based on how database technologies (such as MySQL, Redis, PostgreSQL, etc) develop and integrate new upgrades.
When those platforms that we monitor -- already powerful, tried and true -- equip themselves with new features, we work to discover how VividCortex can leverage those features and make our own technology even better. In the case of MySQL 5.7.8’s recent introduction of Generated Virtual Columns, we found the opportunity to use a new feature to make our queries simpler and more elegant, with results …
[Read more]This blog post discusses what is going on in the MySQL high availability market, and what Percona’s plans are for helping customers with high availability solutions.
One thing I like to tell people is that you shouldn’t view Percona as a “software” company, but as a “solution” company. Our goal has always been to provide the best solution that meets each customer’s situation, rather than push our own software, regardless of whether it is the best fit or not. As a result, we have customers running all kinds of MySQL “flavors”: MySQL, MariaDB, Percona Server, Amazon RDS and Google Cloud SQL. We’re happy to help customers be successful with the technology of their choice, and advise them on alternatives when we see a better fit.
One area where I …
[Read more]Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 16.04 server with PHP 7 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .
When i was working my laravel application at that time i need to remove column from database But i am not sure that column is exists or not in tables So i was thinking but i found solution from Laravel Database Migration Schema we can check column is exists or not in tabales using hasColumn If
Sometimes we require to get randomly data using laravel query builder you can use mysql rand with order by If you want to get random data using laravel eloquent then we need to use DBraw In bellow example you can i use DBrawIn this example i use DBrawRAND inside orderBy an