Releases: julien040/anyquery
0.3.1
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- abbb833 ✨ Add buffer flushing using functions
- 766bb11 ✨ Add colUsed field to more efficient database queries
- 527d410 ✨ Add partial updates to Notion plugin
- 93bcea9 ✨ Add support for except/intersect queries
- f7a1d9d ✨ Nicer plugin development UX.
- 5111faa ⬆️ Update Anyquery RPC version for notion
- a1a35a5 🐛 Ensure parser properly format query parameters
0.3.0
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
Database querying
Anyquery now supports database querying. You can join data between APIs, local files, apps, and now SQL databases.
At the moment, we support PostgreSQL-wire and MySQL-wire compatible databases.
Fixes
There are a lot of fixes that have been made. Feel free to open an issue if you find any new bugs.
Breaking changes
- To work with PRQL, PRQL now needs to be installed on your machine and available in the
PATH. - The Anyquery's SQL parser has changed, which means that there might be undiscovered issues.
- When you query from a remote file, the cache can now be invalidated.
- Anyquery cannot be installed with
snapcraftanymore due to confinement issues.
Commits
- 00b9fb3 ✅ Remove failing test for plugin loading
- 1311a60 ✅ Update weird failing test
- b322d10 ✨ Add ClickUp plugin
- 5d39397 ✨ Add Coda plugin
- 8e56cd0 ✨ Add PostgreSQL db querying
- 50524ef ✨ Add SQLite version to -v flag
- e263e2f ✨ Add Salesforce custom plugin
- c2247a7 ✨ Add Salesforce plugin
- 4bc37c9 ✨ Add hashing function for query constraint
- afed809 ✨ Add hubspot plugin
- 4abdd6e ✨ Add new SQL date functions
- 0e07a11 ✨ Add new type conversion for plugin configuration
- c632b6c ✨ Add search bar to website
- a8be1f1 ✨ Add stanchion plugin
- eb9dce5 ✨ Add support for MySQL-based databases
- 8937e50 ✨ Add support for additionnal types
- 1fc1da7 ✨ Modify the release header to include a SQL snippet
- 347bb68 ✨ Update website to document databases connections
- e2d412c ➖ Ditch pg_query parser for SQL query
- 2844256 ⬆️ Run go mod tidy
- ea4deec ⬆️ Run go mod tidy and update vitess lib
- bc9b932 ⬆️ Update SQLite to v3.47.0
- d1798da ⬆️ Upgrade dependencies to latest version
- e4797ba 🐛 Fix DESCRIBE table_name queries on composite PK
- 53861ec 🐛 Fix issue in goreleaser template Tabs instead of spaces...
- 3d0fb0e 🐛 Fix issue with argument type for Salesforce plugin
- 49f201d 🐛 Fix pull request query
- a6399aa 🐛 Fix weird cache invalidation bug for the query hub
- 1de3cec 🐛 Proper data validation for profile creation
- 9d01809 🐛 SQLparser quoting issue Ensure that if a single quote was encountered in a string literal, the formatter would return '' to escape it. Before, it would attempt to write ', which is MySQL specifix syntax.
- bbf350e 👷 Remove snapcraft publishing
- dc37f1f 💄 A few UI updates to the website
- 725af31 💄 Larger tables for terminal output
- 0be92c0 💄 Update header image
- 1ad6de1 📝 Add more docs for query hub
- 7a269a1 📝 Remove snapcraft tutorial while snap issues aren't fixed
- c84be1b 📝 Update README.md to talk about databases
- fab1995 📦️ Move snapcraft to classic confinement
- 10d0933 📦️ Update name format to a namespace based one (thanks @asg017)
- 925ecf7 🔍️ Update SEO desc
- 86e215a 🔥 Remove statical linking of PRQL
- f7b881a 🚑️ Add support for non public schema tables in PostgreSQL
- 0e866ef 🚸 Registry refreshes every two days now
Contributors
Assets 16
0.2.2
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- f987aea ⚡️ Add cache TTL for the run cmd
- 2e14eaf ✨ Add a few github community queries
- 5e40695 ✨ Add new fields for hub queries
- c061c2c ✨ Add query hub to website
- b09e96a ✨ Update a couple of community queries
- 6aeb31c ✨ Update git plugin
- 6908c4e 🐛 Fix #4: Pretty table output was too wide for some terminals
- 13217dd 👷 Rename branch for winget repository
- a1b1390 💄 Add hovering effects to links
- 2f99872 📝 Update docs for anyquery run
- e3f71a1 🚑️ Fix critical issue with INSERT stmt
0.2.1
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
0.2.0
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
What's new?
Community repository
Go to https://anyquery.dev/queries to find a community repository of predefined queries. You don't have to touch SQL anymore. Answer questions easily from various sources.
JSON output
JSON output now correctly handles arrays and objects.
Log querying
Log querying is now faster and more powerful. Before, it often failed due to RegExp issues. They are now fixed!
Changelog
- 0942aee ✨ Add reproducible build for future plugins
- be94d5b ✨ Add support for community queries
- 893e3a5 ✨ Strengthen log querying capabilities
- 8f9fb97 ⬆️ Upgrade SQLite to 3.46.1
- c73835e 🐛 Fix issue #17
- b2b5daa 💄 Update plugins list cmd rendering
- 3b235b3 🗃️ Update query templates
- 673b9c5 🩹 Ensure the query splitter handle comments
0.1.3
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- eb2a3a1 ✨ Add -v, --version flags
- a1859c6 ✨ Add Google Contacts plugin
- 88433e1 ✨ Add Nylas plugin
- 73aff63 ✨ Add new plugins from asg017
- 2c921ab ✨ Add plugin Google Tasks
- 88ff95f ✨ Add shopify plugin
- 4f6646e ✨ Add sqlean extensions
- aeaf765 ✨ Add table "github_stargazers_from_repository" to GitHub plugin
- 2507e3b ✨ Make the JSON output stream
- 4469f41 🐛 Fix NULL to empty array
- c0b5d53 🐛 Fix issue with OAuth 2.0 scopes in Google Contacts plugin
- 379cf22 🐛 Fix issue with PRQL build (#9)
- 34e4bf7 🐛 Fix rare map race condition
- 6166fef 💄 Add icons to integrations
- b8e18cc 💄 Add logo variant
- 74d092b 💄 Fix landing page from feedback
- 7f64e90 💄 Update website - Add a few changes to the landing - Hide test integrations - Update doc of Anyquery limitations
- c823aac 📝 Add examples to commands reference
- d060b52 📝 Update Google plugins documentation about OAuth
- 9a2daa4 📝 Update README.md
0.1.2
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- ca8e135 ✏️ Fix 404 on footer
- dcaedac ✨ Add Docker plugin
- b5c8bb8 ✨ Add Todoist plugin
- 0e6ded0 ✨ Add Vercel plugin
- 05c4dea ✨ Add log querying
- 0b84b58 ✨ Update HN plugin: add list tables
- 84db1ad ⬆️ Update RPC dependency for plugins with DB
- 3443508 🐛 Enclose column name for CSV, HTML, and JSONL
- 88d3bdc 💄 Add Product Hunt badge
- 658ae54 💬 Fix typo in README.md
- 40b88b8 📝 Update doc
0.1.0
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- 9fcd98b 🔥 Remove uncessary test output files
- f8466c8 All downhill from here
- 9a604dc Merge pull request #1 from julien040/imgbot
- 842eeac [ImgBot] Optimize images
- fb4a628 [ImgBot] Optimize images (#2)
- 0c05f0a ♻️ Reorganize tooling command and add pass hashing Now, all the little command helper are under the tool command Also, I've added a command mysql-password that allows you to hash a password so that it can be used in the authentication file
- 09fa7a8 ⚡️ Make MySQL specific query more resilient Query like SHOW TABLES now show tables from plugins Also, namespaces don't block at one connection now anymore so that each MySQL query can have its own SQLite conn
- 9c05588 ✅ Add test for go-sqlite3 op code
- fdec4c1 ✅ Add tests for the plugin
- 082ca05 ✅ Add tests for the rpc package
- 9452999 ✅ Fix tests logger Added a null logger to tests so that it doesn't sigsegv
- 0659c61 ✨ Add ".sql" command
- 9fb3918 ✨ Add Airtable plugin
- dabaf35 ✨ Add Apple Notes plugin
- 95418a2 ✨ Add GitHub plugin
- e9f26bc ✨ Add Google Forms plugin
- 3d93a60 ✨ Add Google Sheets plugin
- 060e4d4 ✨ Add HN plugin
- edfe9dc ✨ Add JSON and CSV tables
- 68564b5 ✨ Add Notion plugin
- fcdd4c4 ✨ Add ORDER BY constraints to plugin context
- 0de139a ✨ Add PRQL and PQL alternative languages for querying
- 1e1ba63 ✨ Add XDG Base Directory Specification handling
- f72e47c ✨ Add a plugin to generate random data
- 0a97c52 ✨ Add ability to generate markdown docs of commands
- da420a0 ✨ Add apple reminders plugin
- bc8c0df ✨ Add calendar plugin
- d2ecb36 ✨ Add chromium based plugin
- 39593c8 ✨ Add cli to manage the registry
- aaeae76 ✨ Add config database with SQLite
- 61f50fe ✨ Add connectionID to args in plugin
- cc0e520 ✨ Add developer mode
- 1df4efc ✨ Add file plugin
- d78c7da ✨ Add git plugin
- 4e83d11 ✨ Add goreleaser config
- fdde181 ✨ Add hjson support for dev manifest
- dc9c60d ✨ Add homebrew plugin
- 3a30624 ✨ Add html elem reading for non table element
- b1e41f4 ✨ Add imap plugin
- 11408c0 ✨ Add input description in profile form
- 3ed5e75 ✨ Add integration pages
- 121436e ✨ Add ip-api.com plugin
- df4b967 ✨ Add middleware to allow dynamic schema
- 4201362 ✨ Add new date functions
- 8179dba ✨ Add new fields to store manager
- aace9b6 ✨ Add plugin PyPI
- 4c0338a ✨ Add pocket plugin
- 8e5aec7 ✨ Add profile and plugin commands
- a1d1025 ✨ Add raindrop plugin
- abb5757 ✨ Add read only database to namespace
- a2e3ac6 ✨ Add read-only opening of the config database
- 95f3b04 ✨ Add registry and plugin download Anyquery is now able to download plugins and store them locally This works by using a registry. It's a simple HTTPS API that anyone can host. To ensure that a registry is compliant, the plugin will validate it against a JSON schema
- a95769d ✨ Add rss plugin
- c8eeb12 ✨ Add safari plugin
- 2425c3f ✨ Add schema declaration in SQLite
- 3993837 ✨ Add server command
- 5e55dff ✨ Add spotify plugin
- 226b2b2 ✨ Add support for Insert/Update/Delete operations on vtable
- 5fe1f89 ✨ Add syntax highlighting to landing page code
- c11399b ✨ Add the ability to pass the json path as a second arg Before, to specify a json path, you had to pass the arg jsonpath='$.whatever' Now, you can just write read_json('file', '$.whatever')
- bff740c ✨ Add the anyquery standard library It's a collection of useful functions that can be used in SQL queries
- 0baec99 ✨ Add the query command
- 181ab85 ✨ Add typeform plugin
- 41e3da5 ✨ Alias command created
- b1fe9b8 ✨ Allow loading of local extensions in the CLI
- d2ad074 ✨ Allow plugins to redirect stderr to an io.Writer
- d8281c6 ✨ Allow transaction with MySQL server Now each MySQL connection has its own SQLite connection so that BEGIN and COMMIT can work Also, some functions (like RunShowStatement) have been modified so that they can be exported and use by other packages
- 7c56d99 ✨ Built a library to help plugin creation
- 3c39a26 ✨ Create reader for YAML, TOML, JSONL, Parquet and HTML files
- 978b23f ✨ Create the registry related command
- 895c11e ✨ Define commands hashdir and plugins
- c8acf5b ✨ Enable dev plugin in server mode
- c3144ff ✨ Implement BestIndex, Disconnect, EOF, Filter, Next and RowId of Vtab
- edd7028 ✨ Implement RPC between the host and plugins
- fe786cc ✨ Implement column parsing for SQLite
- 0feeceb ✨ Improve dev experience The CLI can now generate the plugin boilerplate Func reload_dev_plugin can now run a build command
- 9300b77 ✨ Introduce namespaces
- 9b8c3a4 ✨ Introducing connection pooler
- 2e8ccb5 ✨ Let user conf have different types than string Before this commit, configuration of plugins were handling only string. Now, by replacing it with an interface{}, more types can be handled (such as bool)
- cca3a08 ✨ Remove the requirement for a column parameter Before this commit, if a column was marked as a parameter, not adding it in the WHERE constraints would make the plugin to fail. Now, the same behaviour can be used if the column is marked as required. Therefore, a parameter column can be missing without any trouble.
- d9dfd0e ✨ Update GitHub plugin Add table
my_issues - 8739e9f ➕ Add asg017 SQLite extensions
- d998114 ⬆️ Bump go-sqlite3-anyquery package By bumping this package, it pushes sqlite to version 3.46.0. It therefore solves the issue https://stackoverflow.com/q/78806496/15573415
- 74b46c7 ⬆️ Upgrade go-sqlite3 fork to last version This version handles the omit flag for an OFFSET
- a3de328 🎨 Add IF NOT EXISTS to INFORMATION_SCHEMA views
- e01a128 🎨 Add functions to create flags
- d115715 🎨 Create func signatures for the SQLite VTab
- 245c931 🎨 Create structure for the CLI
- 37b1520 🎨 Split the project in modules
- bc02d1d 🏗 Update plugin types Add an operator type to represent an operator in a SQL query Add a flag in the schema to specify the table arguments
- ce714b6 🐛 Bump go-sqlite3 for segfault fix
- 41013d1 🐛 Fix 404 in footer
- 7d7f751 🐛 Fix ASCII Table division by zero When no column is passed to the ASCII table, a division by zero would occur.
- 5097ae5 🐛 Fix Imap plugin the plugin wasn't requesting the right user config
- 4448541 🐛 Fix cache issue The in-memory cache was way too high while the on-disk file was a bit small
- bda27e2 🐛 Fix default ...