Make life easier with SQL Views

In a complex database, with many tables, you often end up with long queries combining those tables. Rather than repeatedly writing out those queries, you can use SQL Views–turn those complex queries into a virtual table, and use that table instead. Requires hardly any storage space, always up-to-date, wish I had found this earlier.

In this blog post, I explain how SQL Views can be applied in the database structure of eZ Publish.Go to the post on share.ez.no.

Tweet about this on TwitterShare on FacebookShare on Google+Share on LinkedInEmail this to someone

Leave a Reply

Your email address will not be published. Required fields are marked *