sheshbabu/freshlytics

Open source privacy-friendly analytics

freshlytics's Issues

Reduce image size by using multistage builds

Stage 1

• copy
• npm install
• npm build

Stage 2

• node dist/index.js

Reduce bundle size of Semantic UI

Currently, the whole Semantic UI JS and CSS is bundled with the app. Use https://github.com/skleeschulte/babel-plugin-transform-semantic-ui-react-imports to modify the import paths so only the used JS and CSS is bundled.

This requires changes to Webpack config:

• Replace typescript loader with babel loader - https://github.com/Microsoft/TypeScript-Babel-Starter

Add support for vscode debugging

Add DigitalOcean 1-click installer

https://marketplace.digitalocean.com

Migrations/seeds doesn't work in Docker and production

Because src/server/migrations isn't included at all and not ts-node and required directories either.
Could be fixed by using a npm run migrate:prod for example. If I find some time in the coming days I'll put up a PR!

Not Updating

I've been running Freshlytics for a couple days now. I have the tracker code snippet in 2 websites but I'm not getting info on either one. There are no obvious errors in the docker-compose logs. Is there something else I should be doing?

Great Express model management for PostgreSQL

Thanks for the great example to help me learning pg + express.
Where could I contact you to ask more questions in future? Such as email, twitter ...etc.

For now, I'd just put my question here. ^_^

It seems you only use a small part of node-pg-migrate to run SQL file:
"migrate": "node-pg-migrate -m ./src/server/migrations -j sql up",

for -j sql , from document, https://salsita.github.io/node-pg-migrate/#/cli?id=configuration
migration-file-language (j) - Language of the migration file to create (js or ts)
it only support js or ts, not SQL.

Could I write a simple function run all SQL files in migrations folder order by SQL file name timestamp(s) ?

Fyi,
I got here from this reddit link: https://www.reddit.com/r/node/comments/da3stw/sequelize_vs_nodepostgres_nodepgmigration/f1vgy65/?utm_source=reddit&utm_medium=web2x&context=3

You were added to awesome-humane-tech

This is just a FYI issue to notify that you were added to the curated awesome-humane-tech in the 'Analytics' category, and - if you like that - are now entitled to wear our badge:

By adding this to the README:

[![Awesome Humane Tech](https://raw.githubusercontent.com/humanetech-community/awesome-humane-tech/main/humane-tech-badge.svg?sanitize=true)](https://github.com/humanetech-community/awesome-humane-tech)

https://github.com/humanetech-community/awesome-humane-tech

Add automated security vulnerability scanner

Hey there,

Would be nice/good to have an automated vulnerability scanner to find any issues with npm packages, etc.

I'm partial to using Snyk (which is free for open-source projects and is available on the Github Marketplace), but if you're used to or more comfortable with any others (like Dependabot) that would be cool too!

Add support for unit testing - jest

Use referrer-spam-blacklist?

https://github.com/matomo-org/referrer-spam-blacklist

Google Analytics

Hiya,

Since your project is well thought out in terms of privacy, perhaps we could work together to remove Google Analytics from the documentation?

Hey, we could use Freshlytics. 😉

External Database

I am unable to connect to an external database from freshlytics

version: "3"

networks:
  web:
    external: true

services:
  freshlytics:
    image: freshlytics/freshlytics
    command: npm start
    container_name: Analytics
    networks:
      - web
    ports:
      - "80:3001"
    environment:
      - DATABASE_URL=postgresql://dbuser:dbuser-password@dbhost:dbportnum/frshlytics?sslmode=require
      - NODE_ENV=production

Log:

Starting Analytics ... done
Attaching to Analytics
Analytics      | 
Analytics      | > [email protected] start /app
Analytics      | > node ./dist
Analytics      | 
Analytics      | Failed to prune sessions: no pg_hba.conf entry for host "x.x.x.x", user "dbuser", database "dbname", SSL off

Add optional .png tracker instead of .js tracker for blockers

One of the first things I noticed when visiting my website after putting the freshlytics script in the page is that uBlock:Origin immediately blocked it (which I disabled shortly after for my site).

Because of this, I was wondering if it would be possible for freshlytics to "generate" a 1px by 1px invisible png file with the same filename as the ID token for the script that, when loaded, counts as a pageview. I would imagine that no actual .png would exist on the hard-drive anywhere, but when a request is put in for the freshlytics server, it would just return the data required for a png and tell the client requesting it that it exists, etc. etc.

The real hat-trick would be to make it so that you can embed both in your page, but it only counts it once if either-or-both load in the same go, in case javascript is being blocked.

If this isn't feasible or is outside the scope of the project, feel free to close this issue.

Self host Lato font

Instead of loading it from Google fonts

Requires modification to the way Semantic UI is consumed