Posts

  • How to change SQLizer plan to upgrade, downgrade, or cancel

    Learn how upgrade, downgrade, or cancel your SQLizer plan. It just takes 5 quick steps to switch SQLizer plan, we let you do it yourself - with a few clicks. Change your plan any time: ‘How to’ steps First up, you’ll need to sign into your SQLizer account with your...

  • The SQLizer File Conversion API is now free for everyone

    API-powered file conversion to MySQL, PostgreSQL, and MS SQL Server, all for $0. We’re excited to announce that from today, customers on the SQLizer free plan will have access to the SQLizer API. Previously only available on our paid plans, the SQLizer API allows programmatic access to our file conversion...

  • What's new in SQLizer 3.0

    What’s new in SQLizer 3.0. We’re excited to announce the launch of a new updated version of SQLizer, available to all customers immediately. Better performance We’ve rewritten some of our core conversion code, and made conversions of most file types about 10% faster than before. Get your structured data into...

  • What the Stack Survey tells us about databases in 2019

    It’s that time of year again - the Stack Overflow developer survey brings news of the most highly regarded languages, databases and frameworks out there - along with salaries and more. No surprise for us SQL fans that MySQL, MS SQL Server and PostgreSQL occupy the top 3 slots for...

  • .NET Client Available as NuGet Package

    The SQLizer .NET API Client is available on NuGet as a package. Add it to your project with: dotnet add package sqlizer-client-dotnet --version 0.0.23 See: The NuGet package page for the SQLizer .NET Client. The SQLizer API lets you easily and securely convert Excel, JSON, CSV and other files into...

  • Convert JSON to SQL Database in 30 seconds

    अपने पाठ प्रारूप (JSON, Excel, CSV, XML) फ़ाइलों को मुफ्त में डेटाबेस फ़ाइलों में बदलें।

  • SQLizer .NET API Client Now Available

    See Github for the SQLizer .NET API Client. Also see the SQLizer API Help & Documentation pages. We’re delighted to announce the new .NET API client for SQLizer. Using this free open-source library you can add database conversion and migration to your .NET application with a few lines of code....

  • Programmers self-automating with SQLizer

    The Coders Programming Themselves Out of a Job Atlantic did a great long-form post last week on the programmers quietly automating their own jobs - either entirely or in part. This was interesting to us at SQLizer because, since we launched the SQLizer API we’ve heard from a handful of...

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

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

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

  • SQLizer Product Update March 2017

    SQLizer Product Update March 2017 As you’ve probably noticed, we’ve made a few UI changes to SQLizer in the past month or so. These changes should improve the overall conversion experience and make the app even easier to use. But SQLizer hasn’t just had a minor facelift - we’ve rolled...

  • How to convert CSV to SQL - the easy way

    SQLizer makes it painless to convert CSV files to SQL databases (in only 30 seconds too!) But for the sake of fairness we thought we’d outline three other ways you can convert CSV to SQL. You know… just in case you enjoy spending time doing fiddly, manual tasks. First up,...

  • An overview of privacy and security at SQLizer

    SQLizer has two priorities: data security and consistently smooth SQL conversions. Ensuring smooth conversion ranks pretty highly but nothing is more important than keeping your data safe. You’ve entrusted your data and SQL conversion to us and we take that extremely seriously. ​ Security is our highest priority ​ How...

subscribe via RSS

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

SQLizer.io