# bitilia.com

> Project archive of Ilia Kalina.

Authoritative profile: https://ilia.kalina.uk/
Person entity: https://ilia.kalina.uk/#person

- Profile: https://ilia.kalina.uk/
- GitHub: https://github.com/bitilia
- LinkedIn: https://www.linkedin.com/in/iliakalina/
- X: https://x.com/bitilia00
- ORCID: https://orcid.org/0009-0002-0510-6261
- Archive: https://bitilia.com/

## Team

- [TradeRange](https://traderange.net): Free trading-skills platform with competitions.
- [TradeChart](https://github.com/techareaone/TradeChart): Python library for market charts from mixed data sources.

## Personal

- [ES3D](https://es3d.org/): Declarative 3D scenes for the web, built from shapes instead of a fixed mesh. Preprint: [10.5281/zenodo.23403919](https://doi.org/10.5281/zenodo.23403919). Source: [github.com/bitilia/es3d](https://github.com/bitilia/es3d).
- [SQL Learn](https://sqllearn.bitilia.com/): A free way to learn SQL by writing it. Each exercise gives you tables and a task. You write a query, run it in the browser, and see whether the result matches. There is no account, no install, and nothing is sent to a server. Practice SELECT, WHERE, joins, grouping, window functions, INSERT, UPDATE, DELETE, and more, including PostgreSQL, MySQL, SQL Server, and Oracle dialects on SQLite in the browser.
- [Database Central](https://databasecentral.bitilia.com/): Visual schema canvas for tables, keys, and normal-form examples. Import CSV and export CSV, PDF, or PNG.
- [PageScan](https://pagescan.bitilia.com/): Generate ruled, squared, graph, dot grid, Cornell and music sheets with QR registration markers in the corners. Print them, write on them, scan them back into a PDF.
- [Prompt-a-thon](https://prompt-a-thon.bitilia.com/): Web platform for AI literacy competitions in schools.
- [VCoder](https://vcoder.bitilia.com/): Use instead of standard input handling so backends stay secure by default. Also on [PyPI](https://pypi.org/project/vcoder/) and [GitHub](https://github.com/bitilia/vcoder).

## Archived

- [scrape-block](https://github.com/bitilia/scrape-block): Generate a per-user anti-scrape font that hides emails from scrapers by scrambling the font cmap.
- [Crop](https://crop.bitilia.com/): Trim transparent padding and resize an image in the browser.

## Machine-readable

- Projects JSON: https://bitilia.com/projects.json
- Sitemap: https://bitilia.com/sitemap.xml