4 ms·
Does anyone else have any other unorthodox use cases? I love SQLite, and am always happy to ram this square peg into a round hole.
by fbdab103 4y ago
Does anyone else have any other unorthodox use cases? I love SQLite, and am always happy to ram this square peg into a round hole.
- aarchi 4y agoPostgreSQL is Turing-complete, as proven by implementations of a cyclic tag system[0] and Turing machine[1]. The Mandelbrot set[2] and travelling-salesman problem[3] have also been implemented in it. Transact-SQL is also Turing-complete, as proven by a Brainfuck implementation[4]. With that, you can theoretically compute anything :). [0]: https://wiki.postgresql.org/wiki/Cyclic_Tag_System https://wiki.postgresql.org/wiki/Cyclic_Tag_System [1]: https://blog.coelho.net/database/2013/08/17/turing-sql-1.html https://blog.coelho.net/database/2013/08/17/turing-sql-1.htm... [2]: https://wiki.postgresql.org/wiki/Mandelbrot_set https://wiki.postgresql.org/wiki/Mandelbrot_set [3]: https://web.archive.org/web/20201111224603/http://assets.en.oreilly.com/1/event/27/High%20Performance%20SQL%20with%20PostgreSQL%20Presentation.pdf https://web.archive.org/web/20201111224603/http://assets.en.... [4]: https://stackoverflow.com/questions/900055/is-sql-or-even-tsql-turing-complete/34847489#34847489 https://stackoverflow.com/questions/900055/is-sql-or-even-ts...
- robertlagrant 4y agoDoes any of the above apply to SQLite?
- yawaramin 4y agoCoincidentally I just wrote this about using SQLite for managing i18n strings: https://dev.to/yawaramin/translations-without-the-tears-1n9k https://dev.to/yawaramin/translations-without-the-tears-1n9k