Posts
-
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...
-
A brief history of JSON
JavaScript Object Notation, or JSON to you and me, was popularized by a man who made video games at Atari in the 1980s. But more on that later. In the 15 years it’s been around, JSON has replaced XML as the file format for transferring data on the web. A...
-
The decade of fierce database debate
The great NoSQL vs SQL flamewars of a few years ago may have calmed down, but what did we learn? Aside from the fact that arguing on the internet doesn’t get anyone anywhere, maybe not much at all. If anything, the market is even more confusing now than ever...
-
SQLizer or script for database migration?
Developers are SQLizer’s main customers and you’d be forgiven, as a developer, for thinking “why don’t I just write a DB converter script myself?” Yet it’s really not so simple. Getting a script to work some of the time is different from it working 98% of the time. But if...
-
A brief history of the CSV file
Ahh… the trusty CSV (comma separated values) file! Knocking around ten years before the first personal computer (that’s since 1972), the CSV file is one of the most ubiquitous and useful file types there is. One of the most common uses: transferring data between databases, often CSV to SQL. Just...
-
7 surefire ways to lightning charge your SQL queries
Nobody likes hanging around for results while their SQL query sluggishly retrieves data - especially if you’ve already waited to convert Excel to MySQL or some other data conversion. The two biggest factors affecting SQL query run-time are database design and SQL query optimization. While database design might be out...
-
When should you store data as a JSON string?
JSON is a popular format for storing and exchanging data on the web. It’s also becoming an increasingly common format for database migration from modern apps (such as MixPanel, SalesForce, and Shopify) over to SQL databases. We know because we see a fair amount of JSON to MySQL conversions 😄...
Subscribe via RSS
