5 votes

Fortnightly Programming Q&A Thread

Automatically posted
Tags: programming, recurring.biweekly

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes: 

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

1 comment

  1. FluffyKittens
    (edited )
    Link
    Looking to build/find a minimalist logging service for server management. Ideally something that lets me just send a POST request to a VPS via curl, and logs the source IP and message body to a...

    Looking to build/find a minimalist logging service for server management. Ideally something that lets me just send a POST request to a VPS via curl, and logs the source IP and message body to a plaintext file that I can then read remotely. Preferably secured with basicauth or a token system.

    Examples of where I’d want to use this:

    • Add a line to my .loginrcs to serve as a barebones IDS.
    • Remotely log whenever one of my systemd services restarts.
    • Log when a VPS gets rebooted.
    • Log the failure of an automated backup script.

    Most SaaS-type logging services seem to be oriented towards high-volume, ephemeral logs coming from hundreds+ of devices… which I get, because that’s where the big money is. However, that business model is the opposite of what I’m looking for, and is crowding out my search results. Not to mention search results these days are just getting plain terrible. (E: Papertrail seems like the best fit out of the paid options I’ve checked so far, but the price point + search restrictions make it less desirable than self-hosted… plus f— Solarwinds.)

    Anyone got pointers or know of a better solution before I go cobble together something with netcat and Caddy?

    1 vote