AllSQL

<p align="center"> <!-- <a href="https://github.com/calcom/cal.com"> <img src="https://github.com/masteradit/AllSQL/raw/master/images/GitHub-readme-banner.png" alt="Logo"> <img src="./images/GitHub-readme-banner.png" alt="Logo"> </a> --> <h1 align="center">AllSQL</h1> <p align="center"> An open-source compact browser-based SQL Compiler, built using Flutter. <br /> <a href="https://sql.allmityapp.com">Website</a> · <a href="https://github.com/masteradit/AllSQL/issues">Issues</a> · <a href="https://github.com/masteradit/AllSQL/pulls">Pull Requests</a> · <a href="https://github.com/masteradit/AllSQL/discussions">Discussions</a> </p> </p> <p align="center"> <!-- GitHub Stars --> <a href="https://github.com/masteradit/AllSQL/stargazers"><img src="https://badgen.net/github/stars/masteradit/AllSQL" alt="GitHub Stars"></a> <!-- GitHub Forks --> <a href="https://github.com/masteradit/AllSQL/forks"><img src="https://badgen.net/github/forks/masteradit/AllSQL" alt="GitHub Forks"></a> <!-- GitHub Forks --> <a href="https://github.com/masteradit/AllSQL/forks"><img src="https://badgen.net/github/forks/masteradit/AllSQL" alt="GitHub Forks"></a> <!-- License --> <a href="https://github.com/masteradit/AllSQL/blob/main/LICENSE"><img src="https://img.shields.io/github/license/masteradit/AllSQL" alt="License"></a> <!-- Style --> <a href="https://github.com/masteradit/AllSQL"><img src="https://img.shields.io/badge/style-lint-4BC0F5.svg" alt="Style"></a> <!-- Repo size --> <a href="https://github.com/masteradit/AllSQL"><img src="https://img.shields.io/github/repo-size/masteradit/AllSQL" alt="Repo Size"></a> <!-- GitHub Open Issues --> <a href="https://github.com/masteradit/AllSQL/issues"><img src="https://img.shields.io/github/issues/masteradit/AllSQL" alt="GitHub Open Issues"></a> <!-- GitHub Closed Issues --> <a href="https://github.com/masteradit/AllSQL/issues?q=is%3Aissue+is%3Aclosed"><img src="https://img.shields.io/github/issues-closed/masteradit/AllSQL" alt="GitHub Closed Issues"></a> <!-- GitHub Open Pull Requests --> <a href="https://github.com/masteradit/AllSQL/pulls"><img src="https://img.shields.io/github/issues-pr/masteradit/AllSQL" alt="GitHub Open Pull Requests"></a> <!-- GitHub Closed Pull Requests --> <a href="https://github.com/masteradit/AllSQL/pulls?q=is%3Apr+is%3Aclosed"><img src="https://img.shields.io/github/issues-pr-closed/masteradit/AllSQL" alt="GitHub Closed Pull Requests"></a> <!-- Commits Per Year --> <a href="https://github.com/masteradit/AllSQL/pulse"><img src="https://img.shields.io/github/commit-activity/t/masteradit/AllSQL" alt="Commits Per Year"></a> <!-- Last Commit --> <a href="https://github.com/masteradit/AllSQL"><img src="https://img.shields.io/github/last-commit/masteradit/AllSQL" alt="Last Commit"></a> <!-- Pricing --> <a href="https://github.com/masteradit/AllSQL"><img src="https://img.shields.io/badge/pricing-free-brightgreen" alt="Pricing"></a> <!-- GitHub Release --> <a href="https://github.com/masteradit/AllSQL/releases"><img src="https://img.shields.io/github/v/release/masteradit/AllSQL" alt="GitHub Release"></a> <!-- GitHub Contributors --> <a href="https://github.com/masteradit/AllSQL/graphs/contributors"><img src="https://img.shields.io/github/contributors/masteradit/AllSQL" alt="GitHub Contributors"></a> <!-- GitHub Watchers --> <a href="https://github.com/masteradit/AllSQL/watchers"><img src="https://badgen.net/github/watchers/masteradit/AllSQL" alt="GitHub Watchers"></a> <!-- Netlify Deploys --> <a href="https://sql.allmityapp.com"><img src="https://api.netlify.com/api/v1/badges/31d231ee-72ca-4f9a-84d1-7e73ef4851c1/deploy-status" alt="Netlify Deploys"></a> <!-- TODO: Product Hunt --> <!-- TODO: Uptime --> <!-- TODO: Hacker News --> <!-- TODO: Add more - https://shields.io/ --> </p> <p align="center"> <!-- Follow --> <a class="github-button" href="https://github.com/masteradit" data-color-scheme="no-preference: light; light: light; dark: dark;" data-size="large" data-show-count="true" aria-label="Follow @masteradit on GitHub">Follow @masteradit</a> <!-- TODO: Sponsor --> <!-- <a class="github-button" href="https://github.com/sponsors/masteradit" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-heart" data-size="large" aria-label="Sponsor @masteradit on GitHub">Sponsor</a> --> <!-- Watch --> <!-- Place this tag where you want the button to render. --> <a class="github-button" href="https://github.com/masteradit/AllSQL/subscription" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-eye" data-size="large" data-show-count="true" aria-label="Watch masteradit/AllSQL on GitHub">Watch</a> <!-- Star --> <a class="github-button" href="https://github.com/masteradit/AllSQL" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-star" data-size="large" data-show-count="true" aria-label="Star masteradit/AllSQL on GitHub">Star</a> <!-- Fork --> <a class="github-button" href="https://github.com/masteradit/AllSQL/fork" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-repo-forked" data-size="large" data-show-count="true" aria-label="Fork masteradit/AllSQL on GitHub">Fork</a> <!-- Issue --> <a class="github-button" href="https://github.com/masteradit/AllSQL/issues" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-issue-opened" data-size="large" data-show-count="true" aria-label="Issue masteradit/AllSQL on GitHub">Issue</a> <!-- Discuss --> <a class="github-button" href="https://github.com/masteradit/AllSQL/discussions" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-comment-discussion" data-size="large" aria-label="Discuss masteradit/AllSQL on GitHub">Discuss</a> <!-- Download --> <a class="github-button" href="https://github.com/masteradit/AllSQL/archive/HEAD.zip" data-color-scheme="no-preference: light; light: light; dark: dark;" data-icon="octicon-download" data-size="large" aria-label="Download masteradit/AllSQL on GitHub">Download</a> <!-- More: https://buttons.github.io/ --> </p>

✨ Demo

Website: https://sql.allmityapp.com

<a href="https://sql.allmityapp.com"><img src="https://github.com/masteradit/AllSQL/raw/master/images/recording.gif" alt="AllSQL Demo GIF"></a>

⚡ Features

• ✅ Server is not required
• ✅ Output is neatly formatted in the form of a table
• ✅ Helper text to explain the use of each option with example
• ✅ Very small size (< 6 MB)
• ✅ Works on web
• ✅ Can be installed as a Progressive Web App on Android, iOS, Windows, MacOS and Linux
• ✅ Works offline
• ✅ Responsive design (works on all screen sizes)
• ✅ Shows a detailed error when an exception is thrown

🐛 Known issues/bugs

• ❗ Automatically execute commands instead of selecting the type of command manually
• ❗ Show multiple tables in output if multiple select queries are entered
• ❗ Add dark theme
• ❗ Add syntax highlighting

🤔 Why did I make AllSQL?

I created AllSQL when I was in college. I had a Database Systems course in college, where our teacher recommended us to download Oracle Database 19c, which is around 2.7 GB in size. Some of my friends faced issues while installing the software. So, I wanted to make a ligh weight, compact, browser based compiler, where anyone could practice SQL commands, on any device without installing a heavy software, which would also work offline so that we could use it during our lab exams as well. Thus, I sat down one night and challenged myself to build an SQL compiler before the next morning that would match all the constraints.

👏 Getting Started

This project is a starting point for a Flutter application.

A few resources to get you started if this is your first Flutter project:

• Lab: Write your first Flutter app
• Cookbook: Useful Flutter samples

For help getting started with Flutter development, view the online documentation, which offers tutorials, samples, guidance on mobile development, and a full API reference.

Initial Setup

1. Clone the repo.

2. Run flutter pub get. This will get all the dependencies for this project.

3. Run dart run sqflite_common_ffi_web:setup. This will create 2 files sqlite3.wasm and sqflite_sw.js.

   Note: when sqlite3 and its wasm binary are updated, you may need to run the command again using the force option: dart run sqflite_common_ffi_web:setup --force

   However since it depends on sqflite3 version and its associated binary, if it gets updated and the tool still download the old version (sorry it is hardcoded) you might have to manually download a compatible binary from sqlite3.wasm binaries I don't have a better option yet, sorry.

   Source: https://pub.dev/packages/sqflite_common_ffi_web#setup-binaries

📚 Documentation

• Website: https://docs.sql.allmityapp.com/
• GitHub repository: https://github.com/masteradit/AllSQL-Docs

🙏 Show your support

Please ⭐️ this repository if this project helped you!

<a href="https://www.buymeacoffee.com/aditluhadia" target="blank"><img src="https://github.com/masteradit/AllSQL/raw/master/images/bmc-button.png" alt="Buy me a coffee" height="45" /></a>

👥 Contributors

<a href="https://github.com/masteradit/AllSQL/graphs/contributors"> <img src="https://contrib.rocks/image?repo=masteradit/AllSQL" /> </a>

Made with contributors-img.

<!-- ## Contributors over time  -->

⭐️ Stargazers over time

[](https://starchart.cc/maste