AllSQL is an open-source compact browser based SQL Compiler, built using Flutter.

Related tags

Data sql pwa online flutter onlinecompiler
Overview

AllSQL - An open-source compact browser based SQL Compiler

style: lint repo size issues open pull requests open license: MIT latest version Netlify Status contributors watchers stars forks

AllSQL is an open-source compact browser based SQL Compiler, built using Flutter. Please create an issue on GitHub if you find a bug or have a feature request. Feel free to create pull requests if you are interested in contributing to this project.

✨ Demo

Website: https://sql.allmityapp.com

Demo GIF

Please ignore the mouse in the gif above. The screen recording software glitched the mouse position.

⚡ 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

🐛 Known issues/bugs

  • ❗ Make AllSQL responsive on smaller screens
  • ❗ Show error message when an exception is thrown
  • ❗ 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 have a Database Systems course in college. 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.

👏 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:

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

📚 Documentation

🙏 Show your support

Please ⭐️ this repository if this project helped you!

Buy me a coffee

👥 Contributors

Made with contributors-img.

Stargazers over time

Stargazers over time

📝 License

Copyright © 2021 Adit Luhadia.

This project is MIT licensed.

Comments
  • Issue regarding user experience

    Issue regarding user experience

    I find it annoying that I cannot copy the example code provided in the grey box that is below the run button.

    Also it is very annoying that the I get no output.

    Does the app even work?

    enhancement good first issue 
    opened by shuhia 2
  • Release v1.2.0+3

    Release v1.2.0+3

    Change Log:

    • 46877c23aa936b1f284f597842cb08db95d21971 - Make option description text selectable (Fix #15)
    • e58f5595555d3a7939f012231c94c1b3df2a87cd - Set URL Strategy to PathUrlStrategy and remove # from URL (Fix #11)
    • 0430bcfb3f63ea1eefd7cf234f50fcca9408330e - Add new badges and update allsql to AllSQL in README.md
    • 55c4a365a908470e9d4debeb26fb41d8c0a55f99 - Minor formatting change in README.md
    • 1b483116071062f06fb43e0e60d711efd110f289 - Add Contributors over time & Stargazers over time in README.md
    • 45f1c7fa303095d698df681b569e43bc39444f33 - Update dependencies in pubspec.yaml
    • dc462432bdeca00cc2489c5bd65246742b1dc030 - Remove require.js script import in index.html
    • 0515c5a7a956171ffa1bfabd46815ba1add3bc40 - Change version to v1.2.0+3 in pubspec.yaml

    Latest deploy URL: https://sql.allmityapp.com

    v1.2.0+3 deploy URL: https://61403f15d1684f6dd30c32be--keen-haibt-bde842.netlify.app

    opened by masteradit 0
  • [ImgBot] Optimize images

    [ImgBot] Optimize images

    Beep boop. Your images are optimized!

    Your image file size has been reduced by 7% 🎉

    Details

    | File | Before | After | Percent reduction | |:--|:--|:--|:--| | /images/bmc-button.png | 23.84kb | 11.47kb | 51.89% | | /web/icons/apple-icon.png | 6.92kb | 5.32kb | 23.13% | | /web/icons/apple-icon-precomposed.png | 6.92kb | 5.32kb | 23.13% | | /web/icons/android-icon-192x192.png | 6.49kb | 5.06kb | 22.00% | | /web/icons/ms-icon-150x150.png | 5.63kb | 4.67kb | 17.01% | | /web/icons/apple-icon-144x144.png | 5.25kb | 4.39kb | 16.47% | | /web/icons/ms-icon-144x144.png | 5.25kb | 4.39kb | 16.47% | | /web/icons/android-icon-144x144.png | 5.25kb | 4.39kb | 16.47% | | /web/icons/android-icon-96x96.png | 3.15kb | 2.64kb | 16.03% | | /web/icons/favicon-96x96.png | 3.15kb | 2.64kb | 16.03% | | /web/icons/apple-icon-152x152.png | 5.78kb | 4.86kb | 15.82% | | /web/icons/apple-icon-114x114.png | 3.72kb | 3.14kb | 15.63% | | /web/icons/apple-icon-180x180.png | 7.34kb | 6.24kb | 14.95% | | /web/icons/apple-icon-120x120.png | 3.88kb | 3.30kb | 14.94% | | /web/icons/apple-icon-72x72.png | 2.57kb | 2.21kb | 13.73% | | /web/icons/android-icon-72x72.png | 2.57kb | 2.21kb | 13.73% | | /web/icons/ms-icon-310x310.png | 16.57kb | 14.47kb | 12.64% | | /images/recording.gif | 808.06kb | 769.17kb | 4.81% | | /web/icons/apple-icon-60x60.png | 1.94kb | 1.91kb | 1.11% | | /web/icons/android-icon-48x48.png | 1.75kb | 1.73kb | 0.73% | | /web/icons/apple-icon-57x57.png | 1.94kb | 1.93kb | 0.65% | | /web/icons/ms-icon-70x70.png | 2.13kb | 2.12kb | 0.37% | | /web/icons/favicon-32x32.png | 1.34kb | 1.33kb | 0.36% | | /web/icons/apple-icon-76x76.png | 2.20kb | 2.20kb | 0.35% | | /web/icons/android-icon-36x36.png | 1.39kb | 1.39kb | 0.35% | | | | | | | Total : | 935.01kb | 868.51kb | 7.11% |

    Black Lives Matter | 💰 donate | 🎓 learn | ✍🏾 sign

    📝 docs | :octocat: repo | 🙋🏾 issues | 🏅 swag | 🏪 marketplace

    opened by imgbot[bot] 0
  • Add syntax highlighting

    Add syntax highlighting

    Highlighting the code based on syntax can be really useful for users as it makes it easier to read and understand code.

    I came across a few plugins and resources that can help in this case:

    enhancement 
    opened by masteradit 0
  • Show multiple tables in output if multiple select queries are entered

    Show multiple tables in output if multiple select queries are entered

    Currently, the web app only shows the output of one of the SELECT queries. If a user enters multiple queries, it should show multiple tables in the output.

    bug help wanted 
    opened by masteradit 0
Releases(v1.2.0+3)

  • v1.2.0+3(Sep 14, 2021)

    Change Log:

    • 46877c23aa936b1f284f597842cb08db95d21971 - Make option description text selectable (Fix #15)
    • e58f5595555d3a7939f012231c94c1b3df2a87cd - Set URL Strategy to PathUrlStrategy and remove # from URL (Fix #11)
    • 0430bcfb3f63ea1eefd7cf234f50fcca9408330e - Add new badges and update allsql to AllSQL in README.md
    • 55c4a365a908470e9d4debeb26fb41d8c0a55f99 - Minor formatting change in README.md
    • 1b483116071062f06fb43e0e60d711efd110f289 - Add Contributors over time & Stargazers over time in README.md
    • 45f1c7fa303095d698df681b569e43bc39444f33 - Update dependencies in pubspec.yaml
    • dc462432bdeca00cc2489c5bd65246742b1dc030 - Remove require.js script import in index.html
    • 0515c5a7a956171ffa1bfabd46815ba1add3bc40 - Change version to v1.2.0+3 in pubspec.yaml

    Latest deploy URL: https://sql.allmityapp.com

    v1.2.0+3 deploy URL: https://61403f15d1684f6dd30c32be--keen-haibt-bde842.netlify.app

    Source code(tar.gz)
    Source code(zip)

  • v1.1.0+2(Sep 10, 2021)

    • Allow screen rotation in mobile PWA (Fix Allow screen rotation in mobile PWA #3)
    • Update README.md
      • Add Website URL
      • Add ✅ Works offline in ⚡ Features section

    Latest deploy URL: https://sql.allmityapp.com

    v1.1.0+2 deploy URL: https://613b4b294616d1cdcfccdbca--keen-haibt-bde842.netlify.app

    Source code(tar.gz)
    Source code(zip)

  • v1.0.0+1(Sep 9, 2021)

Owner
Adit Luhadia
Founder and Developer @allmityapp | Snapchat India Rep | MIT '23
Adit Luhadia
GitHub https://sql.allmityapp.com
:fire:GeoFlutterFire:fire: is an open-source library that allows you to store and query firestore documents based on their geographic location.

GeoFlutterFire ?? GeoFlutterFire is an open-source library that allows you to store and query a set of keys based on their geographic location. At its

Darshan N 282 Dec 11, 2022
Stream-based strongly typed GraphQL client for Dart

A simple, powerful GraphQL Client for Flutter and Dart Documentation ?? Features ✅ Fully Typed: work faster and safer with compile time checks and IDE

GQL Dart 484 Jan 9, 2023
A Cool Datepicker Built With Flutter

Cool datepicker Features It's the best datepicker ui ever. (at least for me ?? ) It's possible to set all colors of datepicker Support selected date l

null 6 Nov 6, 2022
A GraphQL client for Flutter, bringing all the features from a modern GraphQL client to one easy to use package.

GraphQL Flutter ?? Bulletin See the v3 -> v4 Migration Guide if you're still on v3. Maintenance status: Low. Follow #762 for updates on the planned ar

Zino App B.V. 3.1k Jan 5, 2023
Create a DataTable with Flutter to display data in columns, rows, and cells and also learn how to sort the data within the table.

Flutter Tutorial - Sortable DataTable Create a DataTable with Flutter to display data in columns, rows, and cells and also learn how to sort the data

Johannes Milke 22 Oct 9, 2022
Moor is an easy to use, reactive, typesafe persistence library for Dart & Flutter

Moor is an easy to use, reactive, typesafe persistence library for Dart & Flutter

Simon Binder 1.8k Dec 30, 2022
A Full-Featured Mobile Browser App (such as the Google Chrome mobile browser) created using Flutter and the features offered by the flutter_inappwebview plugin.

Flutter Browser App A Full-Featured Mobile Browser App (such as the Google Chrome mobile browser) created using Flutter and the features offered by th

Lorenzo Pichilli 270 Jan 2, 2023
Redux Compact is a library that aims to reduce the massive amount of boilerplate that follows maintaining a Flutter Redux application.

Redux Compact Redux Compact is a library that aims to reduce the massive amount of boilerplate that follows maintaining a Flutter Redux application. T

Ómar Óskarsson 9 Apr 8, 2022
Remote Flutter/Dart Compiler for CloudRun and Docker

flutter_remote_compiler Running the Application Locally Run aqueduct serve from this directory to run the application. For running within an IDE, run

Rody Davis 32 Dec 12, 2022
Flutter BlurHash - Compact representation of a placeholder for an image.

Compact representation of a placeholder for an image. Encode a blurry image under 30 caracters for instant display like used by Medium. Maintainer: @Solido

Flutter Community 408 Dec 30, 2022
Parser tool is a real-time compiler and runtime engine for strongly typed PEG parsers

parser_tool Version 0.1.1 (BETA) Parser tool is a real-time compiler and runtime engine for strongly typed PEG parsers. Parser tool contains libraries

null 6 Jun 28, 2021
Compact representation of a placeholder for an image. Encode a blurry image under 30 caracters for instant display like used by Medium. Maintainer: @Solido

Flutter BlurHash Compact representation of a placeholder for an image. Generation You can use https://blurha.sh/ for testing or use any official api o

Flutter Community 408 Dec 30, 2022
A Dart build script that downloads the Protobuf compiler and Dart plugin to streamline .proto to .dart compilation.

A Dart build script that downloads the Protobuf compiler and Dart plugin to streamline .proto to .dart compilation.

Julien Scholz 10 Oct 26, 2022
A Flutter plugin that allows you to add an inline webview, to use a headless webview, and to open an in-app browser window.

Flutter InAppWebView Plugin A Flutter plugin that allows you to add an inline webview, to use an headless webview, and to open an in-app browser windo

Lorenzo Pichilli 2.3k Jan 8, 2023
you can open google browser in your app

flutter_open_browser A new Flutter project. Getting Started This project is a starting point for a Flutter application. A few resources to get you sta

Mehrab Bozorgi 1 Nov 14, 2021
Persist data with Flutter's Sqflite Database locally on your Android or iOS device by using Raw SQL statements.

Flutter Tutorial - Database Storage Using Sqlite & Sqflite Persist data with Flutter's Sqflite Database locally on your Android or iOS device by using

Johannes Milke 170 Dec 30, 2022
A simple but powerful path-based navigation router with full web-browser and deeplink support.

nav_stack A simple but powerful path-based routing system, based on MaterialApp.router (Nav 2.0). It has browser / deeplink support and maintains a hi

gskinner team 22 Nov 28, 2022
A simple but powerful path-based navigation router with full web-browser and deeplink support.

nav_stack A simple but powerful path-based routing system, based on MaterialApp.router (Nav 2.0). It has browser / deeplink support and maintains a hi

gskinner team 22 Nov 28, 2022
GetDoctor is a complete app developed in Flutter, Firebase and Blazor,.Net Core API and SQL Server

GetDoctor ?? ?? ?? GetDoctor is a complete app developed in Flutter, Firebase and Blazor,DotNet Core API and SQL Server GetDoctor is a complete packag

Sunil Vijayan 69 Dec 19, 2022
A complete grocery store developed with Flutter, .Net Core, Firebase, One Signal and SQL Server as backend

# Grocery-Store developed in Flutter,DotNet Core, Firebase, One-Signal, SQL-Server, Stripe, Razorpay, Paypal A complete grocery store developed with F

Sunil Vijayan 31 Jan 1, 2023