jpiech

6 ms·

1.
Show HN: GS-Base – A multifunctional database tool with Python integration(citadel5.com)
2 points by jpiech 1y ago|0 comments
2.
by jpiech 1y ago
Lyme carditis - antibiotic instead of pacemaker https://pmc.ncbi.nlm.nih.gov/articles/PMC9125511/ https://journals.viamedica.pl/folia_cardiologica/article/vie...
3.
by jpiech 1y ago
Thank you. The current integration is described in the online HTML GS-Calc help. Any suggestions would be highly appreciated.
4.
by jpiech 1y ago
Yep, the website is being kept simple, in fact too simple and will have to be eventually redesigned. It seems the classic (and actually up to date) WinAPI GUI shouldn't imply the software is being "slow". One could have it bo
5.
by jpiech 1y ago
This is a potentially interesting feature - it probably could be relatively easily extended to the shared environment in GS-Calc as there are already separate passwords to protect files, the sheet/view structures and cell ranges and op
6.
by jpiech 1y ago
Thanks. Yes, that was put off a bit too long, but there are plans to come up with the multiplatform version this year.
7.
by jpiech 1y ago
Thanks. This is just a set of features that offer better (sometimes significantly better) performance and make it possible to work with large data sets in some predictable way, that is, knowing what the performance is with 100K formulas, y
8.
by jpiech 1y ago
Fully adaptable to every database need, ranging from a household list to the personnel or inventory records of a large corporation. You can analyze, query, perform calculations, merges and joins with up to 256 million rows, 16K columns and
9.
Show HN: GS-Calc – A modern spreadsheet with Python integration(citadel5.com)
112 points by jpiech 1y ago|21 comments
10.
Show HN: GS-Calc: a spreadsheet with Python (UDF) integration(citadel5.com)
2 points by jpiech 1y ago|1 comments
11.
by jpiech 1y ago
GS-Calc can be helpful, for example, to: * process large (e.g. 4GB+) data sets in a spreadsheet; * load GB/32 million-row files in seconds and use them without any crashes; * load/edit in-place/split/merge/clean CSV
12.
Show HN: A spreadsheet-like program to handle any data and files of any size(citadel5.com)
5 points by jpiech 3y ago|0 comments
13.
Show HN: A Database and an ETL Tool(citadel5.com)
2 points by jpiech 3y ago|0 comments
14.
Show HN: GS-Calc – a spreadsheet with 12 million rows(citadel5.com)
2 points by jpiech 3y ago|0 comments
15.
Show HN: GS-Base – a database with spreadsheet functions and up to 256M records(citadel5.com)
3 points by jpiech 3y ago|1 comments
16.
by jpiech 3y ago
With GS-Base you can perform virtually any data (especially text/CSV files) transformations, making the most of your hardware. [+] Up to 256 million records in one table. [+] Text, Numeric, Long Text / Memo fields, Image/File
17.
by jpiech 3y ago
BTW, data tables exceeding 12 million rows can be handled by a companion database program GS-Base ( https://citadel5.com/gs-base.htm ). It's a database with spreadsheet functions. Uses up to 256 million records/ro
18.
by jpiech 3y ago
Thanks. Actually, it's easy to overlook this at first but splitting views also maximizes the working area, e.g.: (1) click the table toolbar and chose to hide it, (2) right click a given split view and hide row and/or column headi
19.
by jpiech 3y ago
As a matter of fact, if someone owns the system, competing on equal terms (or at all) is impossible. Re: the Linux, it's tempting for a couple of reasons, but potential user base seems to be a problem (at the moment).
20.
by jpiech 3y ago
Unfortunately, even for fast NVMe SSDs random access to cells (which determines the performance) can't compare to RAM. In the example above these 0.5 billion cells can still be fully loaded to 16GB RAM, but adding further such workshee
21.
by jpiech 3y ago
For various internal indexing purposes, it's more convenient to use powers of 2 or their multiplicities. While "no limits" is doable it would have some impact on the performance and would require a bit more complex UI for the
22.
by jpiech 3y ago
Thanks. It's C++, mostly with custom template classes instead of the STL.
23.
Show HN: GS-Calc – a spreadsheet with 12M rows(citadel5.com)
12 points by jpiech 3y ago|11 comments