seektable

Here you can analyze the data with pivot tables: http://stackoverflow.seektable.com/cube/4b8d18bfa62b4204a46e...

> 2. Go sell it to someone and have them pay you to build it.

This sounds good, but unfortunately this approach doesn't work for may kinds of products - especially if you idea is not niche B2B service.

I started https://www.seektable.com as a side project 2 years ago - originally this was demo of technology (totally free tool). Last 9 months I'm trying to convert it into profitable SaaS app; have first paid customers however MRR is still low.

Depending on your SaaS app niche and your marketing capabilities it might take some time to get stable and good-enough cash flow.

there was a startup that addresses exactly this (findo.io) but it is dead now - I guess they didn't get enough traction.

The idea to have 'personal google' is good, however it fails as cloud/proprietary solution. If I give access to my gmail/drives/messangers I want to be sure that this data will not be tracked/used by 3rd parties (even as 'telemetry') - this is possible only with open source self-hosted software.

hey you can create pivot tables by BigQuery without paid GSuite subscription at all, this is possible with SeekTable (this is free BI tool): https://www.seektable.com/help/bigquery-pivot-table

well, for >10k rows most likely it is better to use more specialized tools to create pivot tables. Google Sheets as browser app just not intended to do this.

what do you mean with 'edit options'?

We have a tool similar to metabase - this is seektable.com - which also can be used for as 'database viewer' where end-user can define custom HTML formatting for each value in the table; there are no values editing yet so it is interesting to hear maybe we can add something to make this possible.

another way how you can explore prev-year results online: http://stackoverflow.seektable.com/cube/6c6ca671f6984e98b6b6...

Try our free BI tool https://www.seektable.com It has PostgreSql connector; with 'flat table' report type you can easily filter/sort records without need to write SQL, and pivot tables/charts are good for summary reports (under the hood GROUP BY queries are generated)

BTW, SeekTable can connect to ElasticSearch so it may be used with this data source too.

Almost any modern BI tool supports formulas; if you're interested exactly in n-dimensional data model try https://www.seektable.com

> I find them lacking when I just want to browse and see my logs in context.

Does this mean that you don't need charts - only usual datagrid for your Elastic index where you can easily filter/sort documents?.. My product SeekTable can do that. In addition to that, it can build pivot tables by ElasticSearch (say, you may get summary by log entry type, or group by date parts).

Your suggestion makes sense, and docker images + docker compose config maybe simplest way to provide self-hosted option for web app that is already exist as cloud service. We used this approach to enable self-hosted option for our BI tool (SeekTable), and it works perfect for us.

Have you checked Apache Mahout recommendation framework ( https://mahout.apache.org/docs/latest/algorithms/recommender... )? For 'small data' it can be used as Java library (algorithms for single-machine); if you prefer .NET C# port is also present: https://github.com/nreco/recommender . If you're new to collaborative filtering 'Apache Mahout in Action' book will help a much.

Also tried with several CSV files (2MB and 123kb) and nothing happens. Here is a link to small CSV: https://www.seektable.com/demo/sales.csv

(btw our tool also can create pivot tables/charts by CSV up to 500mb or databases)

you can try https://www.seektable.com which has 'flat table' reports for data browsing and postgresql connector; however this is cloud tool and your DB should be accessible by tool's server. BTW, CSV files are also supported.

No need to reinvent the wheel: take a look to the Apache Mahout collaborative filtering engine - it can be used for both 'small' and 'big' data. If you have one-machine dataset (millions of items) I may recommend to use non-Hadoop algorithms implementation that can be used as usual java lib (in case of .NET C# port is available: https://github.com/nreco/recommender ).

Also you can check 'Mahout in Action' book - part 1 is about recommendations and it explains everything that you need to know for building your own recommendation engine.

seektable.com with .net core

Take a look to Yandex ClickHouse, this is open-source append-only analytical database. It offers ultimate performance of OLAP queries and data like events log, and its SQL dialect includes a lot of specialized functions for metrics calculation.