Posts
-
Convert Excel, CSV, JSON to PostgreSQL with SQLizer
SQLizer adds support for PostgreSQL databases Rejoice PostgreSQL fans! As well as our existing support for MySQL and Microsoft SQL Server, we’re delighted to announce that SQLizer can now prepare your Excel, CSV or JSON file for insertion into a Postgres database. PostgreSQL is the world’s most powerful open source...
-
Building a data pipeline with HubSpot and SQLizer APIs
HubSpot, the beastly sales and marketing software, is almost ubiquitous. For teams using it it houses a lot a of data: contact lists, marketing funnels and sales pipelines, blog posts, landing pages, emails, successful deals, and so on. While HubSpot would love for you to keep your data in their...
-
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...
Subscribe via RSS
