While designing the database for a laravel software using MYSQL, is assigning foreign keys relevant or does Laravel take care of that "Software side". In the migration we have something like Table Example: $table->unsignedBigInteger('user_id'); should i modify the example table…
There are 2 samples. In the first example, it gives faster results when using orderby. (according to phpmyadmin speed report) In the other example, I don't use order by, it gives slower results. (according to phpmyadmin speed report) Isn't it…
I have an java spring / hibernate application and I cant create a connection beween the mysql and java containers. When I start just the mysql Container and run the java application manualy in CMD it works fine. But once…
I have hosted my Laravel project on Shared hosting. Everything works fine on local but my main problem is in Phpmyadmin when i imported my sql file into it. In my local i every table has primary key, auto increment…
I have a database that holds stock levels for certain items that are supplied by different suppliers. Each supplier sends me a daily CSV file with their current stock levels. I am trying to update the stock levels into my…
They are newbie to docker. Get phpmyadmin, php, home assistant working. But I can't configure the docker well to be able to connect from php to a database. Could you help me see what the problem is. I tried everything.…
Currently, I have a grid of employees photos on a webpage. Each employee has an IN and OUT photo. They are named firstname_here.jpg and firstname_away.jpg respectively. When I click on a photo it toggles between the two. This is just…
I designed a database model on MySQLWorkbench. Then, I export the model to generate a SQL script. Finally, when I import it in MariaDB PhpMyAdmin it raises errors like : #1067 - Invalid default value for 'created' MariaDB version :…
so I'm currently working on some Statistics. for that, I need 3 datetimes one between 7:50 and 8:10, one between 11:50 and 12:10, and one between 14:50 and 15:10. SELECT * FROM sensor WHERE zone = 5 and updated >='2020-08-12…
We are in the middle of refactoring a custom-built middleware/API from Python 2 to 3. The software is responsible for creating and updating categories, products, listings, orders, stock, etc. on many different platforms (like ebay, amazon, shopware) by data exported…