Master's thesis research in cybersecurity - Asking for DB access

[Selim Decamps]

Hello,

I'm a computer science student from Belgium currently working on a master's thesis related to microservice security and would like to request a direct access to crt.sh database for research purposes. Of course, I can provide more details on my research in private conversations and will happily credit your help in my work. 

Thank you in advance.

Kind regards,

Selim D.

[r...@sectigo.com]

Hi Selim.  Anyone can connect to a read-only replica of the crt.sh database.  Please see https://groups.google.com/g/crtsh/c/sUmV0mBz8bQ/m/K-6Vymd_AAAJ for details.

[Selim Decamps]

Thank you very much for your answer. Is there any rate limiting on this access ?

[r...@sectigo.com]

Currently crt.sh:5432 allows up to 5 concurrent connections from any given IP address.

[Craig Ringer]

You'll also find that the replicas are behind a pgbouncer in statement-pooling mode, with very short statement and idle connection timeouts.

So you can't use anything transaction or session scoped like SET, SET LOCAL, prepared statements, etc. Protocol-level bind parameters will still work for clients that use those, though.