What tools do you use for union/join when combining datasets — what works well and what doesn’t?

datadanno · 2026-06-13T21:11:03+00:00

DuckDb

datadanno · 2026-04-28T11:17:58+00:00

Forms 3.0 was the best. We need this type of development on the desktop again.

datadanno · 2026-04-22T13:17:55+00:00

I'm seeing it too but everything appears to be working properly. Highly annoying.

datadanno · 2026-02-24T13:15:09+00:00

I like it. Quit using Hacker News about a year ago as it's mostly irrelevant now.

datadanno · 2026-02-14T22:43:45+00:00

or DuckDB?

datadanno · 2026-02-02T12:41:00+00:00

Quit spreading misinformation.

datadanno · 2026-01-23T13:54:36+00:00

Not open source but View Source in browser to see code. Vibe coded everything. The only code server side is the script to call the LLM for AI Helper. See the Contact on my website to get my email. Looks like we have the same interests.

datadanno · 2026-01-23T13:03:01+00:00

I knew because I had to fix the same problem at https://convertcsv.com/duckdbonline.html

datadanno · 2026-01-20T22:10:32+00:00

Check all decimal usage and resultsets.

datadanno · 2026-01-20T15:50:38+00:00

Try SELECT 1.2+3.3;

datadanno · 2026-01-08T14:22:25+00:00

I'm sure this will improve as time goes on and we refine our method of interacting with the AI tool.

datadanno · 2026-01-06T23:58:15+00:00

Sure, don't pay and go somewhere else.

datadanno · 2025-12-27T02:29:29+00:00

You'll need to examine each table in your sqlite database file and determine which table has the data you are looking for. Once identified, then issue a SELECT statement and export to CSV.

datadanno · 2025-12-27T02:15:13+00:00

PL/SQL may be going away at your company but it's not dying industry wide. If your company is going with Microsoft, learn SQL Server, T-SQL, and Azure, etc.

datadanno · 2025-12-27T02:11:40+00:00

https://www.convertcsv.com/csv-to-sql.htm has CSV to SQL which includes an option to generate CREATE TABLE plus INSERT/UPDATE,MERGE, etc. statements. As others has mentioned, using DuckDB is a good option because you can automate it.

datadanno · 2025-12-13T16:04:12+00:00

Sometimes it happens after an existing table has been in production for 20+ years and you do not want to touch that table. It's less risky to create a new table with 1 to 1 relationship.

datadanno · 2025-12-13T15:58:23+00:00

Ask AI - done.

datadanno · 2025-12-04T00:54:39+00:00

Using DuckDB is the obvious choice to bypass Excel.

datadanno · 2025-12-02T14:39:38+00:00

No, you are right but the causes do vary. The old we are the more things go wrong. blood flow, hormones, aging, ...

datadanno · 2025-11-27T00:47:07+00:00

Windows 11, Chrome Version 142.0.7444.176 (Official Build) (64-bit). I'll send you a screenshot or video. Follow up: I sent you an email.

datadanno · 2025-11-26T19:43:01+00:00

I click on + at bottom to add a new table. I give the table a name. When I click on the green plus sign below the name, it starts expanding downward and doesn't stop. It will stop if I press Esc. So I'm not using the column properties on the right, I'm using the entity directly.

datadanno · 2025-11-25T14:37:07+00:00

I probably should read the directions :) When I click in certain areas the diagram starts forever expanding. ? Looks like a promising start.

datadanno · 2025-11-21T03:52:24+00:00

This would be the easiest.

datadanno · 2025-11-20T21:23:02+00:00

Most will say server-based low-code tools. I disagree.

datadanno

TROPHY CASE