Posts

  • 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 😄...

  • April 2017: Microsoft SQL Server support, new features, bug fixes, and front page Hacker News!

    SQLizer product update April 2017 This month brings a massive new feature, some small product tweaks, and various bug fixes. What’s new Support for Microsoft SQL Server There’s now a Database Type dropdown on the homepage The API has a new DatabaseType property Changing the DatabaseType to SQLServer means you...

  • SQL is 43 years old - here’s 8 reasons we still use it today

    In this year’s Stack Overflow Developer’s Survey 64,000 developers laid bare their innermost developer secrets. How they learn, the tools they use, what they want - it’s all there. The whole survey is a fascinating foray into the brains of developers and the global software industry. But one thing struck...

  • How to convert Excel to SQL hassle-free

    It’s normal to have data in an Excel workbook that needs to be converted into a SQL database. The easiest way by far is to use an online Excel to SQL converter like SQLizer. But if you’ve got some time to kill there are other methods. This post looks at...

  • How to convert XML to SQL - the clever way

    To convert XML to SQL some wizardry is needed. Unlike CSV files and database tables, XML files aren’t naturally organized into rows and columns: XML is hierarchical. In this way XML is similar to JSON. In order to convert XML to SQL then, SQLizer must work out how to flatten...

  • How to convert JSON to SQL - the quick and easy way

    If you want to convert JSON to SQL there’s no concrete or straightforward way of doing things. Conversion is usually tricky because JSON and SQL are written using different structures. Realistically, you have only two options: use a conversion tool like SQLizer or write some code and build yourself a...

Subscribe via RSS

© 2012 - 2021 D4 Software Ltd (company 08065648) 483 Green Lanes, London, N13 4BS, UK.

SQLizer.io