{"_id":"sqlime","_rev":"5-43b4ab67eaf8fc3c12ca4c6ac0cdd07c","name":"sqlime","dist-tags":{"latest":"0.1.5"},"versions":{"0.1.0":{"name":"sqlime","version":"0.1.0","description":"Online SQLite playground","author":{"name":"Anton Zhiyanov"},"license":"MIT","homepage":"https://github.com/nalgeon/sqlime","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"devDependencies":{"esbuild":"0.17.10"},"gitHead":"2ca3d130b22468e4d575f6307d9f8c5e8778fb48","bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"_id":"sqlime@0.1.0","_nodeVersion":"16.15.1","_npmVersion":"8.11.0","dist":{"integrity":"sha512-PLylFXO3eltEBIsnEDXU76cbHYIbJutpYxAaoLz6rmYZf78IhT9XhCZBCJMr1Hm+XyBvSQ30TkC8S9iGL60kTA==","shasum":"903e7fee611a704a0ae1a80fefcb8eebd111965d","tarball":"https://registry.npmjs.org/sqlime/-/sqlime-0.1.0.tgz","fileCount":7,"unpackedSize":995938,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCgporLiDhZCV2b8lyy7VFEDb10lb6l6HV0Ak3KL6IAkgIgW+NmLZT/5qqYOpswx4+VM4ebRZl79AvaCgIiOhuWJAo="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkAi5QACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmpdig//RZV/yOc3Iy9sO+OVUf1/lFMYhijO8IsyyEdYYt7+UeTlmsK0\r\nftM0cYSSiL5imAQ6kSN4Dw6EA5hGTs09ixwVL7f/T74s6LQdbgp848E0FjWu\r\nxSPHMk5Y3xUqK1W5O3AEFY48OBCv/65JmvFLB0AlgXzGEiWujQjJDYUKr78h\r\n09DPwummj9cY2VqPzz143Sk6hK+7cP33LF5mXxe2+vp1RdkgXPT++PCrKk3z\r\nnmlmsS45J3IEo4b40ctH9xOLB0pKcM5+C88yyl0BHJb7Brt9dEUg/HCGOMSI\r\nVuw6b7y1W1aajQ+34SPyGpt1p7PXVzVskBptjwLfvEwvf3fwAJZ9zfHYkLSj\r\nwcLZR2ZKPkSEzstcz+cQHM4njavwi/wsJOTeI3p4i4wckmU4d020eQY8ZKgH\r\njJt3QltCybVRMUDLTSeEGf3yJvEzJBybvWXAzvXOuKeucX6XJDxvGF4qPdhC\r\nc9msaUe3BwywpEQKgDBtipzVWMaGF6XIwSqFjWCpkAfdv/LhUYHfr9uH/ejf\r\nrY0Bu73R+uywYsBltb4vYX8O0qKn7VpesicXua833PDYDntfNGW1YjiF2DIn\r\nQEH36J+c9296SwrDt2lrY1zuwVDMG4YD3j6O3tp3yaJoSzOVWDhtsA8XabAQ\r\n8EKzHymlA4ymU7/+o2XPrHcSUVtOmlIIaMw=\r\n=AMbX\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"antonz","email":"m@antonz.ru"},"directories":{},"maintainers":[{"name":"antonz","email":"m@antonz.ru"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlime_0.1.0_1677864528158_0.785096437772373"},"_hasShrinkwrap":false},"0.1.1":{"name":"sqlime","version":"0.1.1","description":"Online SQLite playground","author":{"name":"Anton Zhiyanov"},"license":"MIT","homepage":"https://sqlime.org/","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"devDependencies":{"esbuild":"0.17.10"},"gitHead":"beffbe27ebe7e4bcdd31b938cf6ee77477a898f0","bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"_id":"sqlime@0.1.1","_nodeVersion":"16.15.1","_npmVersion":"8.11.0","dist":{"integrity":"sha512-i6PlINjXhCCCUKrw736wh301xd2bvchODiJh3cBRcmf8idgugZ/ZKVFp5NleeLTsLNwS0OYmhRyTt3ml2+YNbA==","shasum":"f20fe28dced189e4e5a95891155032c27df60175","tarball":"https://registry.npmjs.org/sqlime/-/sqlime-0.1.1.tgz","fileCount":8,"unpackedSize":1002477,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIB2R3vlMyp14DdFx2Tu+I/9O8xPjVXpuwNSMtnuWl1LFAiAnv/r1dQ0nawBQL9oX1iDuya4g7rekZUgECCPPs2gBwg=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkAzfVACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoJGQ//dUuN2s6hLRgIewkc4BB1M+rUcZIj1pdEC6i7jyCbCyozy0gj\r\nzKLdK1iitGgyZmG4hg/18P+3v2/GWzx2Y0i5y9Bw+xiiKW9F79HWGOq2476u\r\nJOKBK2yT9YexStKjs7SGfXEr3VPhLTOLmaW5glu5ntkme/UU6Cl0aWSj4T2l\r\nXK/er0NBV30KlmVIiOW5ugMPLyXP0NKO0/PM/TQbX2gzegEjMK/rGwpzZ3lp\r\npl5+6EBojK1ziBfQQJMQ/VfbZFLFwOa8iCZhfkGfPbzJ9iakNsoKR2ZwvonO\r\nzGJA0T3I7n3mSUFk6KtH4adY9zle7oJ2Xe12Kr/VrPMUy6/5UX4G38bHZEG9\r\nM2rrcOMAnV39gj6fUyq6YIgG0xEodxldxuaHyNv32B4jxQ7FIv22pWoUJKLE\r\nh3oF2/pb9Ii0rQMvjfx5YNFppDBIhgRubkjGgoRILTiMdmVUNoic4JGrwWNy\r\n+ZlsyKZ+aJApfEMwj/qJzp0/8FO6UKA4NXOeMUAHZfmHCHMHH+/wbbqwUVch\r\nic4DuOsWcSnpHkFn8LOzvKouvqCOmmKre49RHXwhVq9NGICihA/glEkg8IWr\r\n1gkqbkqbrhxuxYrlD0CT3rsYeXdC+A8BSESsxB7wg5HIruQx9U7BDA77Bbnl\r\nRvJTYpdpyub2L4R2v171BULqsLV3y4vOots=\r\n=ez11\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"antonz","email":"m@antonz.ru"},"directories":{},"maintainers":[{"name":"antonz","email":"m@antonz.ru"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlime_0.1.1_1677932501703_0.321103519702997"},"_hasShrinkwrap":false},"0.1.2":{"name":"sqlime","version":"0.1.2","description":"Online SQLite playground","author":{"name":"Anton Zhiyanov"},"license":"MIT","homepage":"https://sqlime.org/","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"devDependencies":{"esbuild":"0.17.10"},"gitHead":"14144d58556d13af77904aa5104a9fea0c664be7","bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"_id":"sqlime@0.1.2","_nodeVersion":"16.15.1","_npmVersion":"8.11.0","dist":{"integrity":"sha512-UckS+bHsahXaCGM5aooWtM9Qda82cJ/Y+8dINKNjSwmrYXGKEem7ulLKrGzwVXXzETDrY57NSvhxQ2p23Tc2YQ==","shasum":"cacdcd0245a647b8b9b98ddc97cb1e8597792144","tarball":"https://registry.npmjs.org/sqlime/-/sqlime-0.1.2.tgz","fileCount":8,"unpackedSize":1002786,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCnsvLov9+t2MiC0mRwg+kvDWIEXJxMksWNI2LkBJyn+QIhAK3p2Wrb0oOSZ2GvuhA+L3COEHO8aWYA6mEAi8VtpSuN"}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkA1F5ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmo7zA/+PVDCTAIlOir+uyAED7GZ6uZPggMSc0p8cwHJ6Mluain4LPBB\r\ngUQOvjKW2UwJhfdgmetbBK1OEujNHaX+qwkzMcAfLCIlRUxJf7ZrXyxIj29d\r\nZmSgOzFJoNzLiuTRUlnHOUoihFR/siMfDx/BAoN9FMv4HL3CF9cv6mb0kXLP\r\n9aJSlhZii9NBrJ/EwRctxjvA8SKN3E/uR7bpTTvFXkeXyUeaMNSM6xXHIIyb\r\nH+1Z2RVy9teIcAsjBDcj2kGjTBr5kjTqbGA2pSBteNKT5h+Sqm1xayLA3SOZ\r\nrhZwfo/v7eCV0maHpBwyGyw1AzG1HhYILi4qyzG41bVDv7SjCRBqE7bH2wEt\r\nP3wbpD1qbDczNhD8GfFCrsH+rsRY4qPEjMYUZ0qBATn52y3kVCPPr02jlsrz\r\ntDpS9WRCuiAj7rpWGlQMnpqAKa/ILjSR9QXiTGJDz8G7C7PWfblAGQH5zMwZ\r\nQ3V5NqqSJMvSdSwweJHa6+v/2TxeOxZCUZwQu3Lba7MxInrUmSGwSHVIGxMZ\r\nVepVN8Yfba6nvO+K2MTmRnp7LfD+EydwxHeooR1JiL+yL4O5mO806h89ZzfQ\r\ngc6quVccTABIi1yrKtMlA1ReC047OON27JyfXTuVblRtDF5iLSYoO2YqbCl4\r\ndgkTdhRPyfLOCHmMPQ/o3+y/FYA6nW3BGDw=\r\n=Rzzx\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"antonz","email":"m@antonz.ru"},"directories":{},"maintainers":[{"name":"antonz","email":"m@antonz.ru"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlime_0.1.2_1677939064920_0.524349268452998"},"_hasShrinkwrap":false},"0.1.3":{"name":"sqlime","version":"0.1.3","description":"Online SQLite playground","author":{"name":"Anton Zhiyanov"},"license":"MIT","homepage":"https://sqlime.org/","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"devDependencies":{"esbuild":"0.17.10"},"gitHead":"fbf3d8b47b818adf6f97cac5ba810e21a20d791c","bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"_id":"sqlime@0.1.3","_nodeVersion":"16.15.1","_npmVersion":"8.11.0","dist":{"integrity":"sha512-8f3kNX/h2TaZM4UUL4qXYofpY+kpBfdAgvx9dZ/cvbnavNjqQX5TDslzNsmTDKQrt2OhGmdgu6p10tHmbyGYgg==","shasum":"0ccf2576f11490aa95ef18ffd448f846edbadb82","tarball":"https://registry.npmjs.org/sqlime/-/sqlime-0.1.3.tgz","fileCount":5,"unpackedSize":14788,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCa9k0pMhxpglpi4ZpcB9be91p+IIxiD1cv3ZOfUYj7JgIgM1K6AEs3rm+jveL71Kb6MuBrSr3BzAl5gYyqp9tw1ew="}]},"_npmUser":{"name":"antonz","email":"m@antonz.ru"},"directories":{},"maintainers":[{"name":"antonz","email":"m@antonz.ru"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlime_0.1.3_1684823398243_0.6449450574403792"},"_hasShrinkwrap":false},"0.1.4":{"name":"sqlime","version":"0.1.4","description":"Online SQLite playground","author":{"name":"Anton Zhiyanov"},"license":"MIT","homepage":"https://sqlime.org/","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"devDependencies":{"esbuild":"0.17.10"},"gitHead":"53fcd4245daccf25d9008eac499c75efb5633ca7","bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"_id":"sqlime@0.1.4","_nodeVersion":"16.15.1","_npmVersion":"8.11.0","dist":{"integrity":"sha512-Tcx0uZRpMqQus/nVyYqLmbPPvykGpMry/RBJxIXLZV4MT0qt683UsgowT3g59YMGHBL8dV8rHYN/eglX6whcnQ==","shasum":"9e22eefc14d61c8b81bf610e7671f551d6b86d6b","tarball":"https://registry.npmjs.org/sqlime/-/sqlime-0.1.4.tgz","fileCount":5,"unpackedSize":14942,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICVnlRwip2SDbd1+8ExMD/yAEq3mlBbqxlOiIxIJdagdAiEA35NgRpq86cMD40jJm9nBBq4DVI+xVxtfK58bRyudXvY="}]},"_npmUser":{"name":"antonz","email":"m@antonz.ru"},"directories":{},"maintainers":[{"name":"antonz","email":"m@antonz.ru"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlime_0.1.4_1684830714404_0.6329323821004331"},"_hasShrinkwrap":false},"0.1.5":{"name":"sqlime","version":"0.1.5","description":"Online SQLite playground","author":{"name":"Anton Zhiyanov"},"license":"MIT","homepage":"https://sqlime.org/","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"devDependencies":{"esbuild":"0.17.10"},"gitHead":"f48397bfbe7acdac8670c92a7d1cc3c7ec6e0c8e","bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"_id":"sqlime@0.1.5","_nodeVersion":"16.19.1","_npmVersion":"8.19.3","dist":{"integrity":"sha512-O53byLqKx3F3H94rX+NBlYscjnDkNQVBJ+RnO1pbuLxVNyyqGm7cnOKyXH5NbiThcV43YKrmxdQrVgm3eUCsoA==","shasum":"9ae1da24dc987ebb2767aea1aaf3d9cbc500ea33","tarball":"https://registry.npmjs.org/sqlime/-/sqlime-0.1.5.tgz","fileCount":5,"unpackedSize":15649,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHhcouFSJvA8W/JviPQA6rD6RhNLZfT1LbeemGWOo+GSAiEA6DWrXX9kvtjpcMvggGv3TaYAH+Yd5PweQbOahjlPSyk="}]},"_npmUser":{"name":"antonz","email":"m@antonz.org"},"directories":{},"maintainers":[{"name":"antonz","email":"m@antonz.org"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlime_0.1.5_1688665650587_0.5212886690788061"},"_hasShrinkwrap":false}},"time":{"created":"2023-03-03T17:28:48.157Z","0.1.0":"2023-03-03T17:28:48.533Z","modified":"2023-07-06T17:47:31.060Z","0.1.1":"2023-03-04T12:21:41.908Z","0.1.2":"2023-03-04T14:11:05.176Z","0.1.3":"2023-05-23T06:29:58.423Z","0.1.4":"2023-05-23T08:31:54.545Z","0.1.5":"2023-07-06T17:47:30.883Z"},"maintainers":[{"name":"antonz","email":"m@antonz.org"}],"description":"Online SQLite playground","homepage":"https://sqlime.org/","repository":{"type":"git","url":"git+https://github.com/nalgeon/sqlime.git"},"author":{"name":"Anton Zhiyanov"},"bugs":{"url":"https://github.com/nalgeon/sqlime/issues"},"license":"MIT","readme":"# Sqlime\n\n**[Sqlime](http://sqlime.org/)** is an online SQLite playground for debugging and sharing SQL snippets. Kinda like JSFiddle, but for SQL instead of JavaScript.\n\n🌟 **New!** [Ask AI](#-ask-ai) for help with your queries.\n\n🌟 **New!** Turn static SQL code in your articles into [interactive examples](./examples.md).\n\n<a href=\"https://sqlime.org/\">\n    <img src=\"./img/sqlime.jpg\" alt=\"Sqlime\" width=\"600\">\n</a>\n\nHere are some notable features:\n\n### 🔋 Full-blown database in the browser\n\nSqlime is backed by the latest version of SQLite via the [sqlean.js](https://github.com/nalgeon/sqlean.js) project. It provides a full-featured SQL implementation, including indexes, triggers, views, transactions, CTEs, window functions and execution plans.\n\nIt also includes essential SQLite extensions, from math statistics and regular expressions to hash functions and dynamic SQL.\n\n### 🔌 Connect any data source\n\nConnect any local or remote SQLite database. Both files and URLs are supported. For example, try loading the [Employees database](http://sqlime.org/#https://raw.githubusercontent.com/nalgeon/sqliter/main/employees.en.db) from the GitHub repo.\n\n### 🔗 Save and share with others\n\nSqlime saves both the database and the queries to GitHub so that you can revisit them later or share them with a colleague. The database is stored as a plain text SQL dump, so it's easy to read the code or import data into PostgreSQL, MySQL, or other databases.\n\nFor example, here is the [gist](https://gist.github.com/nalgeon/e012594111ce51f91590c4737e41a046) for the Employees database, and here is the [sharing link](https://sqlime.org/#gist:e012594111ce51f91590c4737e41a046) for it.\n\n### 🤖 Ask AI\n\nConnect an OpenAI account to get help with your queries from the state-of-the-art ChatGPT assistant. AI can explain, teach, and troubleshoot your SQL.\n\n<img src=\"./img/sqlime-ai.jpg\" alt=\"Ask AI\" width=\"600\">\n\n### ✨ Interactive examples\n\nWith Sqlime JavaScript widgets, you can turn static SQL code in your articles or documentation into\n[interactive examples](./examples.md).\n\n### 📱 Mobile friendly\n\nMost playgrounds are not meant for small screens. Sqlime was specifically designed and tested on mobile devices. No need to zoom or aim at tiny buttons — everything looks and works just fine.\n\n### 🔒 Secure and private\n\nThere is no server. Sqlime works completely in the browser. GitHub and OpenAI credentials are also stored locally. Queries are saved as private GitHub gists within your account. Your data is yours only.\n\n### ⌨️ Dead simple\n\nSqlime has zero third-party dependencies other than SQLite. Good old HTML, CSS, and vanilla JS — that's all. No frameworks, no heavy editors, no obsolete and vulnerable libraries. Just some modular open-source code, which is easy to grasp and extend.\n\n## Last but not least\n\n**⭐️ Star the project** if you like it\n\n[**🚀 Follow @ohmypy**](https://twitter.com/ohmypy) on Twitter to keep up with new features\n\n[**🍋 Use Sqlime**](https://sqlime.org/) to debug and share SQL snippets\n","readmeFilename":"README.md"}