Commit graph

424 commits

Author SHA1 Message Date
Kacper Kula
1799898a2b fix: deleted automatic column transformation to lowercases 2026-05-04 15:29:40 +01:00
github-actions[bot]
8972c9c7f4
release: Release 0.40.1 (#211)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2026-05-04 10:52:55 +01:00
Kacper
42a6541650
fix: wa-sqlite initialisation fix (#210)
* fix: wa-sqlite initialisation fix

* chore: adding changeset

* fix: passing wasm between workers to reduce bundle size

* fix: fixing issue with vault names
2026-05-04 10:51:44 +01:00
github-actions[bot]
6d4dcc5ece
Release 0.40.0 (#201)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2026-04-12 10:46:01 +01:00
Kacper
33e19df3db
fix: fixing issue with config and extra logs (#209) 2026-04-07 08:53:15 +01:00
Kacper
c038366783
feat: add TAGS() macro and auto-detection for multi-tag AND queries (#202)
* feat: add TAGS() macro and auto-detection for multi-tag AND queries

Introduces two complementary solutions for the common mistake of filtering
by multiple tags with AND (which always returns zero results):

1. TAGS() macro: explicit opt-in syntax
   WHERE TAGS('#project', '#active')
   → path IN (SELECT path FROM tags WHERE tag = '#project'
              INTERSECT SELECT path FROM tags WHERE tag = '#active')

2. Auto-detection: transparently rewrites the broken pattern
   WHERE tag = '#a' AND tag = '#b'
   → path IN (...INTERSECT...)
   Mixed conditions (AND name = 'test') are preserved correctly.

Both use INTERSECT subqueries which are more flexible than an EXISTS
approach (no hardcoded table reference required).

Adds disableTagAutoDetection setting so advanced users can opt out of
the transparent rewrite and handle the SQL themselves.

Docs updated in query-vault-content.md and faq/understanding-tags.md.

* chore: adding changeset
2026-04-06 12:50:00 +01:00
Kacper
b852977496
chore: Disabling console logs on production builds (#208)
* chore: Disabling console logs on production builds

* chore: adding changeset
2026-04-06 12:37:36 +01:00
Kacper
fc24a4f9c0
feat: add JSONL/NDJSON file format support with sidebar preview (#203)
feat: support for JSONL and NDJSON
2026-04-06 12:36:50 +01:00
Kacper
c8567131cd
feat: expose task status symbol in tasks table (#207)
* feat: expose task status symbol in tasks table

Adds a 'status' column to the tasks table that contains the raw
checkbox character (e.g. ' ', 'x', '-', '/'). This allows querying
by specific task states beyond just completed/incomplete.

* feat: adding tasks statuses support
2026-03-29 20:31:15 +01:00
Kacper
03dfcd78b2
fix(parser): fixing select keyword parsing outside the SQL queries (#206)
* fix(parser): prevent 'select' keyword in config objects from being parsed as SQL query

* fix: fixing parsing with SELECT keywords outside sql queries

* chore: adding changeset
2026-03-29 11:15:57 +01:00
Kacper
d9cb4d5fea
fix: restore syntax highlighting inside Obsidian callouts (#205)
* fix: restore syntax highlighting inside Obsidian callouts

The callout wrapper adds extra indentation/prefix characters that
shifted the document offsets, causing the editor extension to miss
SQLSeal codeblocks. Updated range detection to account for callout
context so highlighting works correctly inside collapsed and expanded
callouts.

* chore: refactoring code to reuse the same function in tests and app
2026-03-29 10:43:53 +01:00
Kacper
f57e0f5a00
fix: include release version in PR title and commit name (#204) 2026-03-22 23:07:08 +00:00
Kacper
bf085fe896
Migrating SQL Engine to wa-sqlite (#193)
* feat: WIP. Proof of concept of using sqlite-wasm

* chore: few experiments with kysely

* chore: poc of using idb with modern version of sqlite

* feat: reworking project to use wa-sqlite

* feat: making database queries work too

* infra: refactoring database connection and cleaning dependencies

* fix: fixing issue with tests

* chore: adding missing packages

* chore: underlying engine updated to wa-sqlite
2026-03-22 18:01:03 +00:00
github-actions[bot]
bf24096d75
release: Release Next (#192)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2025-09-18 11:21:12 +01:00
Kacper
53ffe93a9c
feat: updating how modules are being defined (using new version of DITY) (#191)
* feat: updating how modules are being defined (using new version of DITY)

* chore: removing deprecated module
2025-09-18 11:18:22 +01:00
github-actions[bot]
5b60f47e65
release: Release Next (#186)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2025-09-08 18:51:02 +01:00
Kacper Kula
0e2280f8cd chore: fixing changeset 2025-09-08 18:48:40 +01:00
Kacper Kula
baa5856041
fix: fixing issue on mobile (#189) 2025-09-08 18:47:29 +01:00
Kacper Kula
6e8b294bea
chore: fixing docs and upgrading to the lastest version (#187) 2025-08-15 15:11:39 +01:00
Kacper Kula
ce1da3f9ce
Variable editor in SQLSeal Explorer (#185)
* feat: variables editor

* chore: fixing code issue
2025-08-15 14:57:27 +01:00
Kacper Kula
c4278c2a9d
feat: added support for .sql and .sqlseal files (#184)
* feat: added support for .sql and .sqlseal files

* chore: adding changeset

* feat: adding ability turn off .sql / .sqlite / .sqlseal / .db file view
2025-08-15 14:39:06 +01:00
github-actions[bot]
10eb87803c
release: Release Next (#175)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2025-08-13 12:32:59 +01:00
Kacper Kula
1fec2bbd47
fix: dark theme improvements (#183)
* fix: dark theme improvements

* chore: fixing icon a bit more
2025-08-13 12:31:29 +01:00
Kacper Kula
d2141f1ef2
chore: typecheck fixes (#182)
* chore: typecheck fixes

* chore: fixing few missing issues
2025-08-13 11:43:30 +01:00
Kacper Kula
346e358863
feat: dependency upgrade (#181) 2025-08-13 11:20:12 +01:00
Kacper Kula
d79dae458e
chore: better sizing on explorer view (#180) 2025-08-12 19:06:07 +01:00
Kacper Kula
3a19175911
chore: nicer styling for AG Grid (#179) 2025-08-12 19:05:48 +01:00
Kacper Kula
1bf5e8eb8a
feat: JSON visualiser (#178)
* feat: improved JSON visualiser to not analyse big files without confirmation

* chore: fixes

* chore: added changeset
2025-08-12 19:05:00 +01:00
Kacper Kula
403e9f3d0c
Interactive SQL Visualiser (#177)
* chore: reworking plugin internals into modules

* feat: settings module is now working, added debug module, enabled new api module

* chore: restoring external API

* feat: refactoring project to use proper inversion of control

* feat: plugins can now be loaded in any order

* chore: final file migration, all typescript is in modules now

* chore: fixing dependencies of cellParser

* feat: csv and json views are only registered when they are not colliding with other plugins

* feat: fixed library behaviour on canvas

* feat: added ability to hide columns from csv files

* feat: adding global tables support (wip)

* feat: global tables full implementation

* feat: sqlite databases can now be previewed in explorer

* feat: improved explorer view

* feat: highlighting code in the copy code modal

* feat: advanced interactive schema visualiser
2025-08-10 10:21:12 +01:00
Kacper Kula
531d486d06
Feat/sql explorer (#174)
* chore: reworking plugin internals into modules

* feat: settings module is now working, added debug module, enabled new api module

* chore: restoring external API

* feat: refactoring project to use proper inversion of control

* feat: plugins can now be loaded in any order

* chore: final file migration, all typescript is in modules now

* chore: fixing dependencies of cellParser

* feat: csv and json views are only registered when they are not colliding with other plugins

* feat: fixed library behaviour on canvas

* feat: added ability to hide columns from csv files

* feat: adding global tables support (wip)

* feat: global tables full implementation

* feat: sqlite databases can now be previewed in explorer

* feat: improved explorer view

* feat: highlighting code in the copy code modal

* chore: fixing typechecks

* chore: adding missing changeset
2025-08-10 10:08:13 +01:00
Kacper Kula
2bfd2060d7
Feat/global tables new (#173)
* chore: reworking plugin internals into modules

* feat: settings module is now working, added debug module, enabled new api module

* chore: restoring external API

* feat: refactoring project to use proper inversion of control

* feat: plugins can now be loaded in any order

* chore: final file migration, all typescript is in modules now

* chore: fixing dependencies of cellParser

* feat: csv and json views are only registered when they are not colliding with other plugins

* feat: fixed library behaviour on canvas

* feat: added ability to hide columns from csv files

* feat: adding global tables support (wip)

* feat: global tables full implementation

* feat: added changeset

* chore: fixing typechecks
2025-08-10 10:01:08 +01:00
Kacper Kula
7095130ea5
Feat/hide csv columns (#176)
* chore: reworking plugin internals into modules

* feat: settings module is now working, added debug module, enabled new api module

* chore: restoring external API

* feat: refactoring project to use proper inversion of control

* feat: plugins can now be loaded in any order

* chore: final file migration, all typescript is in modules now

* chore: fixing dependencies of cellParser

* feat: csv and json views are only registered when they are not colliding with other plugins

* feat: fixed library behaviour on canvas

* feat: added ability to hide columns from csv files
2025-08-10 09:49:56 +01:00
Kacper Kula
285684dfc4
Refactoring Project to use proper Inversion of Control (#171)
* chore: reworking plugin internals into modules

* feat: settings module is now working, added debug module, enabled new api module

* chore: restoring external API

* feat: refactoring project to use proper inversion of control

* feat: plugins can now be loaded in any order

* chore: final file migration, all typescript is in modules now

* chore: fixing dependencies of cellParser

* feat: csv and json views are only registered when they are not colliding with other plugins

* feat: fixed library behaviour on canvas
2025-08-10 09:34:54 +01:00
Kacper Kula
dfdad63476 chore: fixing documentation pages 2025-06-04 16:21:29 +01:00
Kacper Kula
c70ec3553d
docs: added documentation for charts (#165) 2025-06-04 16:16:56 +01:00
github-actions[bot]
c8e2c8321f
release: Release Next (#162)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2025-06-03 15:24:46 +01:00
Kacper Kula
c705af3a83
fix: fixing issue with grid not displaying properly (#161) 2025-06-03 15:12:22 +01:00
github-actions[bot]
0ef2b8d478
release: Release Next (#159)
Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
2025-05-28 16:16:30 +01:00
Kacper Kula
77ab515121 chore: trying something new with changeset 2025-05-22 15:28:02 +01:00
Kacper Kula
9f7561a1b1 chore: adding version to the title of the pr 2025-05-22 15:24:08 +01:00
Kacper Kula
b17536ecb8 chore: fixing release 2025-05-22 15:20:40 +01:00
Kacper Kula
f2df5a6494
Merge pull request #155 from h-sphere/chore/scss-split
chore: splitting styles into separate SCSS files
2025-05-22 16:14:14 +02:00
Kacper Kula
8e1a879624 chore: added changelog 2025-05-22 15:09:04 +01:00
Kacper Kula
cdcdb0e3d0
Merge pull request #157 from mAAdhaTTah/fix-filename-with-commas
Fix parsing of filename with commas in it
2025-05-22 16:07:49 +02:00
Kacper Kula
1d2fba65d5 chore: adding changeset 2025-05-22 14:56:19 +01:00
Kacper Kula
672e0fdba6 Merge branch 'main' into chore/scss-split 2025-05-22 14:53:29 +01:00
Kacper Kula
1c5c1a66b7 fixing changelog format 2025-05-22 14:49:45 +01:00
Kacper Kula
6d0af3aa95 chore: enabling setting up github user 2025-05-22 14:44:25 +01:00
Kacper Kula
d765fb7f7f
Merge pull request #97 from h-sphere/feat/define-type
feat: Ability to manually define types for columns
2025-05-22 15:42:28 +02:00
Kacper Kula
e3a24cd3b7 chore: added changelog 2025-05-22 14:40:12 +01:00