Worksheet Systems - Blog


How To Make Parallel API calls in JSPython


A tutorial that demonstrate how you can make a parallel API calls with JSPython in WORKSHEETS Data Studio. Making parallel calls will reduce the latency and improve the performance of your solution

Read More

Online SQL Client for low code data management


Online SQL client is a core part of WORKSHEETS Data Studio - our low code data management platform. Because keeping your data in the database is a fundamental part of any data-centric IT solution

Read More

How to import JSON file into SQL Server Database


Explore best practices in our step-by-step tutorial on using WORKSHEETS Data Studio to seamlessly import JSON files into an SQL database.

Read More

How to open and analyse large JSON file online


Learn how to efficiently open and analyze large JSON/JSV files using WORKSHEETS Data Studio in this informative tutorial.

Read More

Import stock data from Alpha Vantage into SQL database


A tutorial on how you can import historical stock data from Alpha Vantage api into the SQL database. Transform raw data into a readable data format, ready to be stored to the database or exported in to the Excel. Then we will setup a Scheduled Task to run this daily

Read More

Why we introduced our new coding language - JSPython?


JSPython is a python-like syntax interpreter implemented with javascript that runs entirely in the web browser and/or in the NodeJS environment. It does not transpile/compile your code into JavaScript, instead, it provides an interactive interpreter that reads Python-like code and carries out its instructions. With JSPython you should be able to safely interact with any JavaScript libraries or API’s with the popular Python-like syntax.

Read More

Worksheet Systems - low code data management platform


Quite often, custom software teams can’t cope with ever-changing requirements. As a result, business users (usually tech savvy) turn to Excel, some bits of Python and SQL in order to automate and improve their data management workflows. With respect to the business users we worked with, most of them are super smart and intelligent people, they don’t know how to write maintainable, well architected, robust and scalable software. That is why their excel “systems” always fall short. And over time, these “systems” become unmaintainable, unreliable and often do not accurately produce vital figures. The solution to the problem is a SQL centric low code data management platform that allows business users and IT professionals to rapidly iterate and produce custom solutions in a streamlined and scalable way.

Read More
Introducing Worksheet Systems

Introducing Worksheet Systems


Today we are proud to announce the launch of Worksheet Systems, a cloud-based data platform that allows businesses to manage and share their data effectively. Why did we create Worksheet Systems? Every business has unique data that it needs to work with to provide its services, support its employees, and inform its customers, yet not all businesses have access to software solutions that allow them to manage and use that data effectively and securely. In our experience, many businesses struggle to manage and use their data effectively to support their employees and customers. Popular data tools, such as Microsoft Excel, lack the data structure, permissioning, and security features necessary to provide an effective data solution.

Read More