Tags

Fix SQLite database locking issue

In some busy workloads various SQLite operations would fail due to
"locked tables"; most of this is related to the session code:

- On every pageview a new session is either read (OK) or written (LOCK!)
- At the same time, the cron may be writing data to the db (LOCK!)

On smaller instances this isn't much of an issue since everything is
fast enough to not lock for too long, but on longer instances this can
be a problem.

Setting SetMaxOpenConns(1) solves this by limiting the connections
writing to the database.

Also set the default journal mode to WAL, which should give better
performance. Both of this is done in the zgo.at/zdb update.

Add "goatcounter help db" to document database usage a bit better.

v1.3.0

Note: this release contains quite a few database migrations; they make take a
minute to run (depending on your table size), and you may want to run a `VACUUM`
afterwards.

- Remove email auth, replace `-auth` with `-email-from` (#263, #270)

  As mentioned in the 1.2 release the email authentication is now removed. You
  can still reset the password for old accounts.

  Since the email auth no longer exists the `-auth` parameter no longer makes
  sense. It's now replaced with `-email-from`, which can be set to just an email
  address.

  **Action required**: if you set the email address with `-auth` you'll have to
  change it to `-email-from`.

- Add OS stats, improve accuracy of browser stats (#261)

  GoatCounter now tracks the OS/platform in addition to just the browser, and
  the accuracy of the browser stats should be improved.

  **Action required**: you'll need to populate the `system_stats` table:

      $ goatcounter reindex -table system_stats

  If you want to process all browser stats with the new logic too, then use this
  instead:

      $ goatcounter reindex -table system_stats,browser_stats

- Improve performance (#265, #273, #274)

  Increase performance by quite a bit on large sites and time ranges.

- Remove the per-path scaling (#267)

  Previously GoatCounter would scale the Y-axis different for every path in the
  dashboard, but this was more confusing than helpful. It's now always scaled to
  the maximum of all paths in the selected date range and filter, with a field
  to scale it lower on-demand if desired.

- Add totals overview (#271)

  Add chart with totals for the selected date range and filter.

- Add `goatcounter.url()`, `goatcounter.filter()` (#272, #253)

  Adds two new methods to the `count.js` script so it's easier to use write own
  implementation. In addition the script will now issue a `console.warn()` if a
  request isn't being counted for some reason.

Release v1.1.2

Fix small issue with the domain not showing correct in the site code 😅

Release 1.1.1

- Small bugfix release which fixes some small issues and improves a few small
  documentation issues. List of changes:
  https://github.com/zgoat/goatcounter/compare/v1.1.0...v1.1.1

- The biggest change is that the `saas` command no longer works (and is no
  longer documented). It was only ever useful for hosting goatcounter.com, and
  has a number of assumptions and hard-coded values.

  If you're using `saas`, then you can migrate to `serve` by setting a custom
  domain (`sites.cname`) for all the sites. The `serve` command should work
  after that.

Release v1.1.0

Changes:

- **Incompatible** Improve CLI UX (#154, #173, #175, #181)

  The entire CLI has been redone; the original wasn't very user-friendly for
  self-hosting. See `goatcounter help` for the full docs, but in brief:

      o Use "goatcounter serve" instead of just "goatcounter".
      o Create new sites with "goatcounter create".
      o Good support for TLS hosting and ACME certificates (see -tls flag).
      o Invert -prod to -dev (i.e. just drop -prod for production services, add -dev for development).
      o -smtp flag is no longer required.
      o -dbconnect                 →  -db
      o -pgsql                     →  -db postgresql://...
      o -staticdomain              →  no longer needed, but if you really want it you can
                                      append to domain: -domain example.com,static.example.com
      o -emailerrors               →  -errors mailto:...
      o goatcounter -migrate       →  goatcounter migrate
      o goatcounter -migrate auto  →  goatcounter serve -automigrate

- **Action required** Show top referrals (#192)

  To populate the ref_stats and size_stats tables for older data, update first
  and then run:

      $ goatcounter reindex -confirm -table ref_stats
      $ goatcounter reindex -confirm -table size_stats

- Charts are displayed in local timezone (#155)

- Add "IgnoreIPs" setting to ignore your own views (#128)

- Link to paths by adding a new domain setting (#138)

- Add configurable data retention (#134)

- Allow configuring the thousands separator (#132)

- Allow filtering pages in the dashboard (#106)

- Improve the integration code (#122)

- Allow sending emails without a relay (#184)

- Add get_query() to count.js to get query parameter (#199)

- Allow viewing the charts by day, instead of only by hour (#169)

Initial stable release