Manejando datos

Visual Studio Code: essential editor

Posted by in Databases, Programming

From time to time, it is good not to accommodate what you know and you have to leave the comfort zone. This is my case with text editors, who have always worked a lot with Notepad ++, but for certain things, I found it insufficient. Atom was a good test, especially since lately I have been developing with TypeScript 2.x, and CATS 2.x in my day to day. It doesn’t work very well on Windows 7. And now, I venture to know if Visual Studio Code does I have to…read more

Modify COLLATE of all tables and columns in MySQL-MariaDB

Posted by in MariaDB, MySQL

Working with the characters in the databases seems to have no consequences, until you come across things that do not match. In today’s post I tell you how to make it easier to change the COLLATE of the tables all to it. The reason for this entry The reason for this entry is that when making a query, it did not get the correct result. We reproduce what happened to me, and create a database, such that: CREATE DATABASE `test` /*!40100 COLLATE ‘utf8_general_ci’ */; so, let’s create a new table:…read more

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