Manejando datos

SQLAlchemy, a Python ORM for databases

Posted by in Databases, Python

I haven’t talked about Python for a long time, not because I don’t have things to tell, but because I’ve been focused on what I’ve already explained here, and I haven’t expanded on other fields. In today’s post, I present SQLAlchemy, a powerful Python library for working with relational databases. The basic concept is the antipode to what I have always done (I still have to rethink this new way of programming): The use of normal Python objects to represent database tables and query execution There are a number of…read more

Lovefield, the Javascript Relational Database

Posted by in Databases, HTML5

Today I am writting related to a Google project called Lovefield, and it is a Javascript Relational Database designing for developing web applications. I have met this projects thanks to the Google website where they have published all Open Source projects the contribute to, or they have develop, order by categories. Here you have their creator, a googler, explaining what Lovefield is about: Lovefield The basic idea of Lovefield is to use relational models to develop webapps, by using a database either online either offline. The second feature is to…read more

Business Intelligence Platform: Tutorial Using MongoDB Aggregation Pipeline

Posted by in MongoDB

This article is originally written in toptal, and you can learn about MongoDB, a NoSQL database that I already wrote about it long ago. Using data to answer interesting questions is what researchers are busy doing in today’s data driven world. Given huge volumes of data, the challenge of processing and analyzing it is a big one; particularly for statisticians or data analysts who do not have the time to invest in learning business intelligence platforms or technologies provided by Hadoop eco-system, Spark, or NoSQL databases that would help them…read more

Challenges for 2017

Posted by in Databases

Happy christmas and a happy new year 2017!!!! It seems like it was yesterday when I wrote challenges for 2016, but the year is ending, so let’s see what I have done, and how was the challenge for 2016. Challenges done in 2016 No doubt, 2016 has been a year where I have written a lot about privacy and data, I try to show to my readers how important is their data, and the consecuences of it. Big Internet companies have no doubt of doing everything for getting data. I…read more

Common_schema: repetitive tasks with foreach

Posted by in MariaDB, MySQL

Although we have spoken several times of this framework MariaDB MySQL-today a new feature, I bring very useful when you need to perform repetitive tasks based on consultations. It is used foreach call. Here I present a practical example of how you’ve used to perform a specific task: to replace all null to zero in a table with a lot of fields values. Locating the table fields The best way of locating the fields that will be used in our task is by using the information_schema, an internal database needed…read more