SQLMatches 0.3.6

SQLMatches, match & demos recorder.

Help support SQLMatches development & hosting

• Subscribe to SQLMatches on the 'Owner Panel' under the 'Subscriptions / Billing' tab.
• Donate via PayPal

✨ Help show support by starring this repo! Watch it to get notifications when updated. ✨

Setup

Hosted version

• Visit SQLMatches.com & follow the video.
• Follow the setup section on the Plugin repo.

Self-hosing

• Install SQLMatches with pip3 install SQLMatches --upgrade.
• Create a file like run.py.
• Set up uvicorn with Starlette.
  • I recommend running Nginx as a reverse proxy.
    • Production Config
    • Development Config
  • Use a UDS (UNIX domain socket) for production.
    • e.g. uvicorn.run(app, uds="/tmp/uvicorn.sock", log_level="warning")
  • SSL with Certbot.
  • Setup a SMTP server, I use Postfix.
  • Build the Frontend or run it in development mode.
    • If building, make sure to edit line 16 & 48 to the location of the built frontend.
• Run run.py using PM2 or screen.

Thanks to

• WardPearce - backblaze - Contributor - Maintainer
• encode - databases - uvicorn - starlette
• Pallets Projects - Jinja2
• Woile - starlette apispec
• Miguel Grinberg - socketio
• aio-libs - aiocache - aiohttp - aiomysql - aiojobs
• cole - aiosmtplib
• Martin Richard - asynctest
• marshmallow code - marshmallow - webargs
• Steven Loria - webargs starlette
• sqlalchemy
• Tin Tvrtković - aiofiles
• Omnilib - aiosqlite
• MagicStack - asyncpg
• To all the developers who helped to make these packages!