Provide support for different databases? about fathom

[zet4]

+1 for Postgres support

[tboerger]

Meddler still gives you enough power to write performant queries. Everybody got different preferred databases, there are enough people that want to use MySQL/MariaDB or PostgreSQL or MSSQL ;)

[tboerger]

Great to see that integrated

[dannyvankooten]

Hey guys,

Thanks for the suggestions, meddler looks pretty neat. I'd have to take a look at abstracting away the SQL as I am not too sure whether some of queries needed for aggregating data into a more performing format can be abstracted away that easily.

What would be a benefit of PostgreSQL over MySQL? The raw pageviews table in Ana has to be optimized for loads of INSERT statements (and very few reads) and from what I've read, MySQL is much more performant when it comes to that than Postgreq.

[zet4]

I just want postgres support as that's the only DB I use on my server and would rather not install mysql only for ana

[xtwist]

@dannyvankooten take a look on clickhouse https://github.com/yandex/ClickHouse https://clickhouse.yandex/ . It's a good choice for your application, especially for tables heavy on insert (views, user-actions, visits, etc. ) moreover you can benefit by mixin clickhouse with postgres together (for customer related data).
P.S not sure how good subtitles are nowadays, but there are 2 videos that i can recommend you to take a look if you're interested in clickhouse https://www.youtube.com/watch?v=Ho4_dQk7dAg https://www.youtube.com/watch?v=tf38TPvwjJ4 (RU)