I wanted to love DuckDB but it was so crashy I had to give up.
I had this too until I lowered it's memory limit. In ~/.duckdbrc `set max_memory='1GB';` or even less
A DuckDB-based metabase alternative
41–42 of 42 posts
Re: A DuckDB-based metabase alternative
#42This is really nice, specially the pdf report generation. I feel very moronic making a dashboard for any products now. Enterprise customers prefer you integrate into their ERPs anyway. I think we lost the plot as an industry, I've always advocated for having a read only database connection to be available for your customers to make their own visualisations. This should've been the standard 10 years ago and it's case…
> I've always advocated for having a read only database connection to be available for your customers to make their own visualisations. Roughly three decades ago, that *was* the norm. One of the more popular tools for achieving that was Crystal Reports[1]. In the late 90s, it was almost routine for software vendors to bundle Crystal Reports with their software (very similar to how the MSSQL installer gets invoked by…
This brings me back! My first job was at the Norwegian ERP Agresso, now part of Unit4. I started as a support technician, which was a experience since around the time, '97-'98, everyone was moving from Sybase/Ingres/Informix etc, to either MSSQL or Oracle. I got to interact with those older database systems and install and export/import data to systems running on eg Oracle across parallel Solaris servers at SAAB Areospace and Windows NT running on DEC Alpha at Ericsson, among other more vanilla deployments.
I was a developer albeit not professionally, and my boss gave me the opportunity to develop the integration between Agresso and Crystal Reports, my first professional development project, for which I am still grateful. It was a DLL written in C++ and I imagine they shipped that for quite a while after I left for greener pastures.
I was already a free software and Linux enthusiast, so I did a vain skunkworks attempt at getting Agresso to run with MySQL, which failed, but my Linux server in the office came in handy when I needed some extra software in the field--I asked a colleague to put a CD in the server so I could download it to the client site some 500 km away, and deliver on the migration.