some-carpenter-73115
09/28/2023, 7:18 AMhandsome-area-93134
09/28/2023, 1:22 PMbland-thailand-4711
10/02/2023, 9:35 PMusql
versions in package.json
, you can run npm update
to update to the latest versions, and npm i
to install them
Happy sqling!handsome-area-93134
10/03/2023, 9:38 PM• Error and Loading states have been improvedDoes this relate to this case, where the Datatable or Big Value become red for split seconds before the data is loaded? If yes, then how did you solve this? The funny thing I have just recently told Adam I didn't need this issue anymore, since I'm not using USQL, but today this issue cropped up in my case too. Now I'm using the standard Sveltekit's way to work with duckdb through
+page.server.ts
and I managed to find a way to pass dynamic parameters to the load() function through a combination of url.searchParams
, `invalidate`and depends
functionality to re-trigger the load()
reload when parameters change, but now it leads the UI component (DataTable) to fully reload and flash the red empty state. So I wonder how you solved it and if I can adapt it to my case.(second gif). Thankssome-carpenter-73115
10/12/2023, 9:05 AMUnsupported object type: null
I've tried different quotations etc.handsome-area-93134
10/12/2023, 12:07 PMIFNULL()
function form duckdb. https://duckdb.org/docs/sql/functions/utility.html
You could add it the query where you use it and deal with the null
before the JS layer.some-carpenter-73115
10/17/2023, 10:02 AMbland-thailand-4711
10/17/2023, 8:36 PMbuild:sources
now uses cursors / streaming for supported databases, this should make the command faster, and able to support arbitrarily large datasets (the client / network limits still apply though, so be sure to filter your data when you put it on the page!)
• Deploy screen shows the correct environment variables to deploy your project. The next release will have configuration of the sources in the settings panel (instead of needing to do the yaml files yourself)
• Breaking: Environment variables now use __
instead of _
to separate levels, so EVIDENCE_SOURCE_mysource_some_option
needs to become EVIDENCE_SOURCE__mysource__some__option
. Refer to the new deploy section if you are unsure, those will be correct for the new system
• build:sources
has some other ergonomic improvements
• Value
and BigValue
now use loading state as well
If you are using the usql
versions in package.json
, you can run npm update
to update to the latest versions, and npm i
to install them
Happy sqling!alert-motorcycle-41359
11/01/2023, 4:39 PMbitter-rainbow-62357
11/15/2023, 8:29 AM20.0.0-usql.29
I'm getting:
Parquet error: Incorrect number of rows, expected 7832 != 208 rows
when building postgres data source.
Here is my plugins list:
"@evidence-dev/bigquery": "^2.0.0-usql.3",
"@evidence-dev/core-components": "usql",
"@evidence-dev/csv": "^1.0.0-usql.4",
"@evidence-dev/evidence": "20.0.0-usql.29",
"@evidence-dev/faker-datasource": "usql",
"@evidence-dev/mysql": "^1.0.0-usql.4",
"@evidence-dev/postgres": "^1.0.0-usql.3",
"@evidence-dev/sqlite": "^2.0.0-usql.2",
"@evidence-dev/usql-datatable": "^1.0.2",
"mermaid": "^10.4.0"
bland-thailand-4711
11/17/2023, 6:03 PMDropdown
component
◦ This is the first of several input components that are DuckDB backed
• debounce
has been applied to query stores
◦ If a query changes rapidly (e.g. scrolling through a dropdown), it won't fire the updated version until changes stop for 500ms
• Performance Guardrails have been added
◦ Toast / console notifications will let you know if the data volumes you are using are growing beyond a certain point.
◦ These aren't hard rules, just reminders to make sure you are only loading what you need
• A fix for parameterized page pre-rendering has also been added
If you are using the usql
versions in package.json
, you can run npm update
to update to the latest versions, and npm i
to install them
Happy sqling!ancient-glass-70797
11/19/2023, 1:25 PMnext
I’d like to query some parquet
files that I have already created in advance.
The code that I think worked a few weeks ago was:
```listings_details
select
*,
latitude::string as lat,
longitude::string as lon,
from '/abcd/fct_listings_light.parquet'
where id = ${$page.params.listing}
```
But now, I get a ran successfully but no data was returned
.
Is there some specific config under sources
to put in place to be able to query those parquet files?some-carpenter-73115
11/22/2023, 3:08 PM# Headline A
Checkout what we are saying [under C](#Headline C)
## Headline B
## Headline C
• The build breaks in prod mode due to missing links
• We get numbers after our headlines that only show after build, like: #Headline C5
.
• Scrolling down to the headline doesn´t seem to work
Is there a best practice or documentation?bitter-rainbow-62357
12/06/2023, 11:11 AMsome-carpenter-73115
12/07/2023, 3:38 PM"@evidence-dev/bigquery": "^2.0.0-usql.1",
to
"@evidence-dev/bigquery": "^2.0.0-usql.4",
and now the bigquery connector won´t load bus instead gives an error:
[!] "undefined" could not be loaded as a plugin, it is missing a name or main field.
Here are my deps
"@evidence-dev/bigquery": "^2.0.0-usql.4",
"@evidence-dev/core-components": "usql",
"@evidence-dev/csv": "^1.0.0-usql.4",
"@evidence-dev/evidence": "usql",
"@evidence-dev/faker-datasource": "usql",
"@evidence-dev/mysql": "^1.0.0-usql.1",
"@evidence-dev/postgres": "^1.0.0-usql.1",
"@evidence-dev/sqlite": "^2.0.0-usql.2",
"@evidence-dev/usql-datatable": "^1.0.2",
bland-thailand-4711
12/11/2023, 7:56 PMdatabases
field to datasources
instead
• Update any connection.options.yaml
files to have their values base64 encoded. Alternatively; you can update those values in the settings UI and it will be automatically formatted as neededblue-architect-75210
12/13/2023, 5:40 PM[!] /Users/dpage/Projects/Data-Platform/frontend/sources/reports is not a valid source; skipping
ENOENT: no such file or directory, open '/Users/dpage/Projects/Data-Platform/frontend/sources/reports/connection.yaml'
bright-smartphone-11251
bright-smartphone-11251
bright-smartphone-11251
bright-smartphone-11251
lemon-cricket-39335
12/21/2023, 10:54 PMlemon-cricket-39335
12/22/2023, 4:32 AMlemon-cricket-39335
12/23/2023, 6:35 PMsilly-wire-12656
12/27/2023, 10:31 AMname: mydb
type: duckdb
options:
filename: md:?motherduck_token=<token>
it doesn't work. Seems it still expecting duckdb file
Slack Conversationaloof-crowd-97360
12/30/2023, 4:34 PM500:TextInput is not defined
when trying
<TextInput
name=name_of_input
/>
I am able to use the dropdown input as expected though.
I've run npm install @evidence-dev/evidence@latest @evidence-dev/core-components@latest
to ensure I am on the latest version. Hoping I'm missing something obvioussparse-match-46746
01/10/2024, 9:50 AMsparse-match-46746
01/11/2024, 2:57 PMselect "Apple" as pie, 60 as count
union all
select "Blueberry" as pie, 70 as count
union all
select "Cherry" as pie, 40 as count
union all
select "Pecan" as pie, 35 as count
ok
select 'Apple' as pie, 60 as count
union all
select 'Blueberry' as pie, 70 as count
union all
select 'Cherry' as pie, 40 as count
union all
select 'Pecan' as pie, 35 as count
2. The query name in the data parameter does not work.
<ECharts config={
{
tooltip: {
formatter: '{b}: {c} ({d}%)'
},
series: [
{
type: 'pie',
data: pie_data,
}
]
}
}
/>
data: [...pie_data]
or data: pie_data.slice()
worked. I don’t know why. I’m not familiar with Javascript.few-guitar-21982
02/16/2024, 9:39 PMboundless-country-20955
03/15/2024, 7:09 PM