egeria_planning

44 ms·

1.
by egeria_planning 2y ago
Possibly. Open an issue on GitHub and add a link to a sample file.
2.
Show HN: uPhotos, an open source GPU-accelerated photo viewer and organizer(github.com)
3 points by egeria_planning 2y ago|2 comments
3.
by egeria_planning 6y ago
Excel is a nice job-creation measure for freelancers. Re-implementing such sheet in C# was a full time job for several years for me. Modern development tools (in contrast to C or Assembler) help the user to maintain its sanity by preventing
4.
by egeria_planning 6y ago
I don't think you can address the downsides without completely redesigning Excel. There were some attempts to add loops, IFs and so on to the assembly language. Somehow this approach could not compete with Java: https://en.w
5.
by egeria_planning 6y ago
CubeWeaver is a .NET web application. It is available as a SaaS product and as a downloadable Desktop Edition (based on electron.js). Check out the download page: https://cubeweaver.com/download
6.
Spreadsheet is a software development paradigm(medium.com)
199 points by egeria_planning 6y ago|103 comments
7.
by egeria_planning 6y ago
ZigZag seems like something very abstract and mathematical. CubeWeaver is just a spreadsheet with drop-down filters if you like.
8.
by egeria_planning 6y ago
Just watched the video. I think it is a different approach. The spreadsheets in the video seem row-oriented. It goes more in the direction of a relational database. CubeWeaver is multidimensional, so you don't need a group by function.
9.
by egeria_planning 6y ago
The masterdata is stored as JSON to avoid creating/dropping columns and tables as list/columns are added and removed. But an option to have a fully normalized relational structure in an on-premise installation is on my feature lis
10.
by egeria_planning 6y ago
If you choose the on-premise options no data will ever leave your company. Administrators will install the software on a server inside your company and will be responsible for updates, backups and security of the server.
11.
by egeria_planning 6y ago
I don't think AirTable is a competitor in any way. As far as it is something like Sharepoint. I think the logo was created before AirTable was there at all.
12.
by egeria_planning 6y ago
The sausage is 100% free from gluten and web assembly.
13.
by egeria_planning 6y ago
Thank you. It is an Angular 9 SPA frontend with a .NET Core backend and an SQL database (MySQL or SQLITE) as a data store. I use several open source libraries. Handsontable is used to display the grid for example. A complete list is availab
14.
by egeria_planning 6y ago
I would suggest to test the cloud version with some dummy data first, so that you know that the application is ok for you. On premise version is also available, but not for free. You will also need either some Linux know how or my support t
15.
by egeria_planning 6y ago
I don't think a multidimensional spreadsheet (like Lotus Improv) makes sense for a single user. Multidimensionality introduces a lot of complexity and it is only justified by very complex models. Apart from some special cases this comp
16.
by egeria_planning 6y ago
Egeria was just a technology demonstrator. CubeWeaver is a cloud application which can scale over multiple servers, supports user authentication, model sharing and redundant data storage. I also added a lot of features that the pilot users
17.
Show HN: CubeWeaver, a collaborative multidimensional web-based spreadsheet(cubeweaver.com)
122 points by egeria_planning 6y ago|40 comments
18.
by egeria_planning 8y ago
The cost for a typical SOC Type 1 starts at $20,000, and SOC Type 2 starts at $30,000. I will probably have to start without SOC...
19.
by egeria_planning 8y ago
Selecting rows from cache of a database is still 100-1000 times slower than reading numbers from an array. And dumping this array into a KV store is much easier than generating SQL.
20.
by egeria_planning 8y ago
I've got several mails from people who'd like to install the system on their own machines. Installing Egeria is not as easy as a desktop application because it is a web server. I will probably add a download page with installation
21.
by egeria_planning 8y ago
I was surprised that there is no common file standard for interchanging dimensional data. As far is I can see netCDF and Zarr only store values/arrays and not the metadata? I will check if there is an easy way to import one of them.
22.
by egeria_planning 8y ago
Hi, it is: Angular 6, PrimeNG, TypeScript SPA frontend, ASP .NET Core application server (REST API only) and Sqlite as a key value data store
23.
by egeria_planning 8y ago
Egeria is not OLAP in the sense of analytics. It does not aggregate data. It computes formulas. Relational databases do not support this.
24.
by egeria_planning 8y ago
Most of these products are so expensive, that only large companies can afford them. A middle size company has a guy who gets 30-50 Excel reports per e-mail at the end of a month and combines them to a single document manually. I hope Egeria
25.
by egeria_planning 8y ago
Cells are grouped into chunks (similar to Minecraft) and stored in binary form. There is a complex algorithm which decides how the data is partitioned. All the operations are done in memory and the KV store is only used as data storage.
26.
by egeria_planning 8y ago
Egeria is in-memory for performance reasons. Egeria can recompute millions cells per second. To do so cells are grouped into chunks and stored in binary form. Relational databases are much slower. It is possible to have a relational backend
27.
by egeria_planning 8y ago
At the moment I don't. It's a beta test. The commercial version will support two factor authentication. I think a local installation on the client's server/workstation would be the best option for very sensitive data.
28.
by egeria_planning 8y ago
I plan to have a free version with some limitations (like the size of the model) and a paid version. Probably both on-premises and cloud.
29.
by egeria_planning 8y ago
A single view should not get too large. The system will not show more than 60000 cells in one view. You will get an error message. The cube itself can grow very large: 10-100 million filled cells. The trick is to design the dimensions so, t
30.
by egeria_planning 8y ago
That's exactly what I try to understand now. I think that people who work with OLAP now should be able to use the system. But I also hope that some percentage of non database people would also be able to learn it. I don't think th

More ›