News for hackers. Stuff that matters.

svenklemm

svenklemm on Hacker News

Show HN: Pgspot – Find vulnerabilities in Postgres SQL scripts

Posted by svenklemm on Thursday November 21, 2024 @10:19AM
from the show-hn dept.

https://github.com/timescale/pgspot

Hi HN!My name is Sven, I am an engineer at Timescale and this is my fun side project. The main purpose of pgspot is to check postgres extension sql scripts for vulnerabilities but it can also be used to check functions outside of extension context e.g. security definer functions.I've started working on this after finding vulnerabilities in timescaledb to ensure similar vulnerabilities don't...

( Read More... | no comments | 8 points | on HN )
Re:Grafana 7.0 on Monday May 18, 2020 @08:43PM (#23230100)
To get graphs for this week and the last 3 weeks in the same panel you could use something like this:

  SELECT i::text as metric, l1.*
    FROM 
    (SELECT
    g1 AS i,
    g1 * '1week'::interval AS interval,
   '1 week'::interval AS span,
    now() AS start
  FROM generate_series(0,3) g1) g1
  JOIN LATERAL (
    SELECT
   time + interval AS time,
   value
  FROM metrics
  WHERE time > start - (span+interval) AND time < start - 
  interval
  ) l1 ON TRUE
  ORDER BY time;
Re:Exploring TimescaleDB as a replacement for Graphite on Tuesday September 11, 2018 @11:28AM (#17960589)
There is a patch for telegraf to support writing to postgres (https://github.com/influxdata/telegraf/pull/3428). Grafana 5.3 (currently in beta) has support for filling in previous values for postgres datasource.
Re:Ask HN: What do GitHub stars mean to you when evaluating a project,... on Thursday June 07, 2018 @12:42PM (#17257546)
I use stars as bookmarks, but i also use the watch feature to keep track of stuff i find interesting.
Re:Python startup time: milliseconds matter on Wednesday May 02, 2018 @02:37PM (#16979909)
Does nuitka build a static executable or do you still need to supply shared libraries with the executable?