{"id":9733217,"name":"lsql-csv","ecosystem":"hackage","description":"lsql-csv is a tool for small CSV file data querying from a shell with short queries. It makes it possible to work with small CSV files like with a read-only relational databases. The tool implements a new language LSQL similar to SQL, specifically designed for working with CSV files in a shell. LSQL aims to be a more lapidary language than SQL. Its design purpose is to enable its user to quickly write simple queries directly to the terminal.","homepage":"https://github.com/stastnypremysl/lsql-csv/","licenses":"GPL-3.0-only","normalized_licenses":["GPL-3.0-only"],"repository_url":"https://github.com/stastnypremysl/lsql-csv","keywords_array":["gpl","library","program","text","Propose Tags"],"namespace":null,"versions_count":7,"first_release_published_at":"2024-04-15T13:07:44.000Z","latest_release_published_at":"2024-05-08T22:54:00.000Z","latest_release_number":"0.1.0.6","last_synced_at":"2026-08-31T19:52:17.662Z","created_at":"2024-04-15T13:19:02.220Z","updated_at":"2026-09-01T01:23:10.237Z","registry_url":"https://hackage.haskell.org/package/lsql-csv","install_command":"cabal install lsql-csv","documentation_url":null,"metadata":{},"repo_metadata":{"id":55735306,"uuid":"266841594","full_name":"stastnypremysl/lsql-csv","owner":"stastnypremysl","description":"lsql-csv is a tool for small CSV file data querying from a shell with short queries. It makes it possible to work with small CSV files like with a read-only relational databases. The tool implements a new language LSQL similar to SQL, specifically designed for working with CSV files in a shell. LSQL aims to be a more lapidary language than SQL.","archived":false,"fork":false,"pushed_at":"2025-04-27T13:29:30.000Z","size":2924,"stargazers_count":1,"open_issues_count":0,"forks_count":0,"subscribers_count":1,"default_branch":"master","last_synced_at":"2026-02-25T10:52:47.610Z","etag":null,"topics":["csv","data-analysis","data-processing","haskell","language","linux-shell","lsql","lsql-csv","new-language","query-language","relational-database","sql","unix-command","unix-philosophy","unix-shell"],"latest_commit_sha":null,"homepage":"","language":"Haskell","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"gpl-3.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/stastnypremysl.png","metadata":{"files":{"readme":"README.md","changelog":"CHANGELOG.md","contributing":"CONTRIBUTING.md","funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null}},"created_at":"2020-05-25T17:36:14.000Z","updated_at":"2025-04-27T13:29:34.000Z","dependencies_parsed_at":"2024-04-15T15:18:55.391Z","dependency_job_id":"9131d6ea-6e55-4434-919c-7810cf83c21c","html_url":"https://github.com/stastnypremysl/lsql-csv","commit_stats":null,"previous_names":[],"tags_count":17,"template":false,"template_full_name":null,"purl":"pkg:github/stastnypremysl/lsql-csv","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/stastnypremysl","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":37009780,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-08-22T15:14:58.755Z","status":"online","status_checked_at":"2026-08-31T02:00:07.497Z","response_time":119,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"},"owner_record":{"login":"stastnypremysl","name":"Přemysl Šťastný","uuid":"4378279","kind":"user","description":"Apparently, this user prefers to keep an air of mystery about them.","email":"","website":null,"location":null,"twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/4378279?v=4","repositories_count":40,"last_synced_at":"2024-04-18T02:00:46.637Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/stastnypremysl","funding_links":[],"total_stars":35,"followers":6,"following":10,"created_at":"2023-07-08T06:27:13.647Z","updated_at":"2024-04-18T02:00:52.937Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/stastnypremysl","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/stastnypremysl/repositories"},"tags":[{"name":"v0.1.0.6","sha":"7c0a57ff3f798ef3291bbfb1c95e754debbdad96","kind":"commit","published_at":"2024-05-08T22:33:39.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/v0.1.0.6","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/v0.1.0.6","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@v0.1.0.6","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.6","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.6/manifests"},{"name":"v0.1.0.5","sha":"3926c645d13fb4e05678109aadb27aa4c1e6e9e7","kind":"commit","published_at":"2024-05-01T19:22:14.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/v0.1.0.5","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/v0.1.0.5","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@v0.1.0.5","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.5","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.5/manifests"},{"name":"v0.1.0.4","sha":"71d0acbc04ae28c4acba218d66ef8121a67e8b17","kind":"commit","published_at":"2024-04-30T14:26:47.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/v0.1.0.4","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/v0.1.0.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@v0.1.0.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.4/manifests"},{"name":"v0.1.0.3","sha":"938caecd19735e8f08af1177a97e16a0c7930f10","kind":"commit","published_at":"2024-04-17T07:49:17.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/v0.1.0.3","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/v0.1.0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@v0.1.0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.3/manifests"},{"name":"v0.1.0.2","sha":"1b3a2636f5ffc220d557a29eeaf53ea5f2fdd53d","kind":"commit","published_at":"2024-04-15T13:56:18.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/v0.1.0.2","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/v0.1.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@v0.1.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.2/manifests"},{"name":"v0.1.0.1","sha":"02ce72f1cd52174614619562890131dd15e53fd0","kind":"commit","published_at":"2024-04-15T13:41:47.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/v0.1.0.1","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/v0.1.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@v0.1.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/v0.1.0.1/manifests"},{"name":"0.4.6","sha":"38a5c9b11b6c5eb031207685cb37b6541d6b36bb","kind":"commit","published_at":"2020-12-12T19:33:59.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4.6","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4.6","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4.6","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.6","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.6/manifests"},{"name":"0.4.5","sha":"b1d123c40be375766a64f6b557df60c273497eaf","kind":"commit","published_at":"2020-12-12T17:57:19.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4.5","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4.5","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4.5","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.5","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.5/manifests"},{"name":"0.4.4","sha":"88180641e9a02c974bc0199fbac415372da8174d","kind":"commit","published_at":"2020-07-13T05:59:43.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4.4","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.4/manifests"},{"name":"0.4.3","sha":"2df9c090d023b19462bce8bd52c8bdf3f50d7161","kind":"commit","published_at":"2020-07-12T16:10:08.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4.3","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.3/manifests"},{"name":"0.4.2","sha":"06d21a87b9d95eda2de6a28dda883cc3aececd61","kind":"commit","published_at":"2020-07-10T06:30:45.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4.2","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.2/manifests"},{"name":"0.4.1","sha":"c7ab0bc69bf5e4b3e750da638c613f091a38a8d9","kind":"commit","published_at":"2020-07-09T20:05:19.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4.1","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4.1/manifests"},{"name":"0.4","sha":"59537baf413057d776bc4a1b4f6d545db4ccfa73","kind":"commit","published_at":"2020-07-09T14:39:16.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.4","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.4/manifests"},{"name":"0.3","sha":"ef7088213361b5f4d52e6fd658d24d08d78d0ba9","kind":"commit","published_at":"2020-06-16T14:16:01.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.3","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.3/manifests"},{"name":"0.2.1","sha":"1da4849a1951656dcde66a66779d28b74d32276d","kind":"commit","published_at":"2020-06-13T18:13:11.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.2.1","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.2.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.2.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.2.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.2.1/manifests"},{"name":"0.2","sha":"0b26226c1c34e259644748eeed0f1e7bc9bdf84e","kind":"commit","published_at":"2020-06-13T14:25:13.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.2","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.2/manifests"},{"name":"0.1","sha":"09fd692a9d04f1c1b0a93295b05a8fa707b27978","kind":"commit","published_at":"2020-06-12T14:02:13.000Z","download_url":"https://codeload.github.com/stastnypremysl/lsql-csv/tar.gz/0.1","html_url":"https://github.com/stastnypremysl/lsql-csv/releases/tag/0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/stastnypremysl/lsql-csv@0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/tags/0.1/manifests"}]},"repo_metadata_updated_at":"2026-09-01T01:23:10.237Z","dependent_packages_count":1,"downloads":487,"downloads_period":"total","dependent_repos_count":0,"rankings":{"downloads":99.94367149214217,"dependent_repos_count":57.78741621134456,"dependent_packages_count":19.208021179518955,"stargazers_count":43.42120085614509,"forks_count":37.06770305283316,"docker_downloads_count":null,"average":51.485602558396785},"purl":"pkg:hackage/lsql-csv","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/hackage/lsql-csv","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/hackage/lsql-csv","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/hackage/lsql-csv/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-08-17T11:44:21.870Z","issues_count":0,"pull_requests_count":9,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":8.666666666666666,"issues_closed_count":0,"pull_requests_closed_count":9,"pull_request_authors_count":1,"issue_authors_count":0,"avg_comments_per_issue":null,"avg_comments_per_pull_request":0.0,"merged_pull_requests_count":9,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/stastnypremysl%2Flsql-csv/issues","maintainers":[{"login":"stastnypremysl","count":9,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/stastnypremysl"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/packages/lsql-csv/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/packages/lsql-csv/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/packages/lsql-csv/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/packages/lsql-csv/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/packages/lsql-csv/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/packages/lsql-csv/codemeta","maintainers":[{"uuid":"stastnypremysl","login":"stastnypremysl","name":null,"email":null,"url":null,"packages_count":2,"html_url":"https://hackage.haskell.org/user/stastnypremysl","role":null,"created_at":"2024-04-15T13:19:04.893Z","updated_at":"2024-04-15T13:19:04.893Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/hackage.haskell.org/maintainers/stastnypremysl/packages"}]}