Posts
-
Export MongoDB data and convert it into SQL
MongoDB is good for certain tasks and certain data. But, even though it’s a NoSQL database, you’ll sometimes need to export data and get into a SQL database. In this scenario you’re left with a number of questions. How can you export your MongoDB data with minimal hassle? Is there...
-
The complicated nature of dates in CSV files
Dates can be represented in hundreds of different ways. As such they complicated for humans and computers to figure out. Just give someone who doesn’t live in America US date format (mm/dd/yy) and they’ll scratch their head for a while trying to figure out what the date is. Likewise for...
-
Export Mixpanel data and convert it to SQL using only APIs
Mixpanel is one of the more widely known and used analytics platforms. As such, there’s a lot of data locked away inside the platform. If you’re like us, you like to keep your data in a central location, likely a SQL database. Mixpanel understand this and offer a raw data...
-
Build a continuously deliverable data migration pipeline with the SQLizer API
With SQLizer it takes just 4 steps to get your data from any proprietary platform with an API for data export (e.g. MongoDB, Mixpanel, or Salesforce) into a MySQL or MS SQL Server database. Following the API instructions provided by the platform that you want to migrate data from,...
-
How can you navigate the database technology maze?
Before we begin let’s take a moment to remember the poor soul who accidentally deleted the production database on their first day. While it was junior who deleted the database, it’s the seniors in charge of database credentials and onboarding who are ultimately responsible. But the data technology landscape increasingly...
-
Is it possible to host Facebook on AWS?
Facebook has been around since 2004. In the years since, the company, now one of the five US tech giants, has moved from a single server running in a dorm room to seven purpose-built data centres dotted around the globe. It’s likely there are more planned for coming years as...
-
How big were the first hard drives?
Throughout human history we’ve found ways to increase our individual and collective data storage. It began with our own memories and moved on to cave paintings. Then spoken language, the written word, and numbers: all massively increased our collective storage of knowledge, of data. The printing press and libraries were...
-
Easily extract Salesforce data using APIs
Your valuable company data is in Salesforce and you’ve been tasked with getting it outta there and safe and sound into your own MySQL or MS SQL databases. After all, nobody wants their precious data fragmented across third party services. Sadly, Salesforce doesn’t currently have the option to connect directly...
Subscribe via RSS
