Guyub adalah perusahaan TI berpusat di Palembang dengan fokus pada F/OSS Produk-produk >> Layanan-layanan >>
Rss Posts
Oct 28, 2010
This is a followup to my previous post about Virtual Columns. In this post I will do a more in-depth test on using virtual columns in a use case where MariaDB is used as a document store. Document oriented DB basics Relational databases store data in 2-dimensional tables, rows and columns. Document oriented databases do not store Word documents or novels, rather the “documents” are essentially serialized PHP arrays, Java-objects, etc. The most popular document format today is JSON. JSON “documents” have exactly the same syntax as a JavaScript array, originally JavaScript programmers would just eval(“data = ” + jsondocument); to get the data into a variable (unserialize). For more information about JSON and how a JSON database would work, see the Wikipedia article and for instance the MongoDB manual. Another format that has been used for document stores is XML documents, and many programming languages can serialize objects into XML. read more
Jun 15, 2010
I have introduced some new people to MySQL recently and had to back track the years to figure out how I learned what I learned about MySQL indexes. A quick way to get up to speed about MySQL indexes is these three podcasts by Sheeri Cabral.OurSQL Episode 13: The Nitty Gritty of IndexesOurSQL Episode 17: Hashing it outOurSQL Episode 18: De-myth-tifying IndexesThose three episodes do a good job of explaining how indexes work so that you have a better understanding of how MySQL indexes find your data.
