Are you looking to improve your database development and SQL skills? You've come to the right place. Learn how to improve these skills by watching the videos on my channel. You'll learn: - how to use many different SQL functions and features - how to design a database and normalise your database tables - how to set up different databases - how to use SQL Developer and other IDEs Plus much more!
Thanks for the helpful tips! Here's an additional suggestion to prevent database connection breaks after a certain period: install an extension called 'Keeplive'. This extension sends periodic queries to maintain active database connections.
very understandable 💯 but i think using that EAV approach it will not fit when your products are linked variations like "BLACK color SM size SILK fabric..." like that first approach would work, could it cause u can retrieve one buy one no way to linked them to be select as one choice while being a combination of different features
I think I understand your concern, but I think the query would be OK. You can get all of the product variations in one query and their variations, and display them on the page as needed.
Hi I have a question. All around the internet they say that storing as an Integer is a no-no. I want to store hundreds of millions of numbers in the database and perform duplication checks on them. Wouldn't using integers be better here as the database would require less resources/time to duplicate check on them considering that i'm talking about hundreds of millions of rows ? Btw I wont use formatting or special characters or leading zeros. Its all numbers only
Good question! I'm not sure whether it will be easier for the database to check for duplicates on numbers or varchar fields. I am guessing the numbers would be faster... but it could be worth running a test on them. You could store a smaller amount of them as varchar, and then remove duplicates, and see how long it takes. Then try the same thing but store it as number and see how long that takes. You could run this experiment on 100,000 rows to compare the performance.
I was always tempted to use ENUMs, I didn't know about CHECK constraints and I always thought LOOKUP TABLES were overkill in resources and performance, thanks for finally clearing it out for me.
I am using this extension and it works fine, but I can't find an option to export my query results to a file or even copy them in a good manor, does anyone know how?
I thought you could select the results and copy them. If not, I'm sure it's something that the team will release soon. According to Twitter, they seem to be making regular enhancements to it.
@@DatabaseStar Thanks for posting. I am also seeing this error. It is during buildContainerImage.sh. A little more detail if you may have any suggestions: => ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh 0.1s ------ > [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh: 0.076 /bin/sh: /opt/oracle/oraInventory/orainstRoot.sh: No such file or directory
@@DatabaseStar Thanks for posting. I am also seeing this error. It is during buildContainerImage.sh.A little more detail if you may have any suggestions: => ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh 0.1s ------ > [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh: 0.076 /bin/sh: /opt/oracle/oraInventory/orainstRoot.sh: No such file or directory
At 11:49, you have created a shopping cart table which only holds its own ID and the related user's ID. Each cart item then stores the cart ID. Would it be a bad practice if, instead of creating a separate table named shopping_cart, each cart_item directly referenced the user ID? Because each user is going to have only one shopping cart anyways?
which version of workbench you have used... because my workbench version is 8.0.34 and its says that it may not work properly Good explanation by the way
i was designinf an RBAC for my system and came up with this tutorial.i was about to use enums role types but just one statement from why use lookup table changed my idea completely.Thank you