News for hackers. Stuff that matters.
Re:Listen to your to PostgreSQL database in realtime via Web... by karambahh on Friday April 30, 2021 @11:41AM (#26994890)
For some reason I understood the title as an audio rendering of changes on your pg db

The actual purpose is actually way cooler, looks like a great tool

Re:Listen to your to PostgreSQL database in realtime via Web... by yokto on Friday April 30, 2021 @01:49PM (#26996833)
This reminds me of a project I did a few years ago:

"Stockify is a live music service that follows the mood of the stock markets. It plays happy music only when the stock is going up and sad music when it’s going down." https://vimeo.com/310372406

(it's of course a parody, but I made a functional prototype)

Re:Listen to your to PostgreSQL database in realtime via Web... by dkersten on Friday April 30, 2021 @03:11PM (#26997930)
I know someone who uses tones as an easy way of knowing if there's a market move on some cryptocurrencies. Basically, there's different tones for a trade that traded higher than previous and for a trade that traded lower than the previous. Possibly pitch or volume or something was used to indicate the volume of the trade, I don't quite remember. Either way, he could quickly hear if there was a major market move or something just by the amount and tone of the beeps. He used this as a way to know then he should look at the chart or whatever.
Re:Listen to your to PostgreSQL database in realtime via Web... by krrrh on Friday April 30, 2021 @04:14PM (#26998709)
We spend a lot of time training digital computers to deal with analog information that has been converted into digital forms, and I wonder how much we could also gain by finding better ways to convert digital information into analog forms that our brains (as analog computers) can better parse.
Re:Listen to your to PostgreSQL database in realtime via Web... by recuter on Friday April 30, 2021 @05:02PM (#26999292)
Oh you're also friends with Gilfoyle? https://www.youtube.com/watch?v=uS1KcjkWdoU
Re:Listen to your to PostgreSQL database in realtime via Web... by dkersten on Saturday May 01, 2021 @06:07AM (#27004956)
Hahaha I forgot about this
Re:Listen to your to PostgreSQL database in realtime via Web... by shrimpx on Friday April 30, 2021 @03:41PM (#26998305)
I had a related idea, to make a running program produce an audible hum like a car engine would. And the hum would vary depending on what paths of the program are executing, so you get an idea what/how your code is "doing" by listening in.
Re:Listen to your to PostgreSQL database in realtime via Web... by grumblestumble on Friday April 30, 2021 @06:08PM (#27000045)
This is what NPR does on the market segment (Kai Rysdal?) The background music reflects the changes in the market over the day.

Also, if you haven't read Douglas Adam's "Dirk Gently's Holistic Detective Agency", there's a good subplot around this exact idea.

Re:Listen to your to PostgreSQL database in realtime via Web... by jmull on Friday April 30, 2021 @12:17PM (#26995420)
That's what I thought too.

I guess someone needs to do it now, hm...

(But: I think live db-activity rendered to music as a kind of monitoring mechanism is potentially way cooler than just getting db updates over a web socket.)

Re:Listen to your to PostgreSQL database in realtime via Web... by rzzzt on Friday April 30, 2021 @02:06PM (#26997082)
You can listen to GitHub commits: https://github.audio/
Re:Listen to your to PostgreSQL database in realtime via Web... by Ombudsman on Friday April 30, 2021 @04:48PM (#26999112)
This is usually how I fall asleep.
Re:Listen to your to PostgreSQL database in realtime via Web... by arthurcolle on Friday April 30, 2021 @10:33PM (#27002417)
This is how you guarantee your child will become an ace coder. The fractal audio will transform key centers in the developing brain, and give them subliminal knowledge of all major repos of note
Re:Listen to your to PostgreSQL database in realtime via Web... by m_mueller on Friday April 30, 2021 @11:53AM (#26995071)
Same here. App idea geared at DevOps: ambient sound scape generator based on monitoring events, e.g. from Datadog.
Re:Listen to your to PostgreSQL database in realtime via Web... by jrockway on Friday April 30, 2021 @12:19PM (#26995456)
We have this in New York City to monitor the flow of traffic on quiet residential streets. If the flow rate is OK, it's nice and quiet. If the flow rate gets too low (or a traffic light turns red) then a chorus of very angry car horns erupts, and you are jolted out of your train of thought, wishing you had the guts / tolerance for prison time to run outside and smash every single one of the cars with a crowbar.

I think a recording of this is actually built into Pagerduty to use as a sound when you're getting paged. I went with the "golf ball hit into a flock of geese" one, though. Every time that goes off my first thought is "OH GOD I'M DYING HELP" but then I look and it's just GCP down again. Ironically therapeutic.

Re:Listen to your to PostgreSQL database in realtime via Web... by tetha on Friday April 30, 2021 @12:59PM (#26996064)
There is an implementation and a paper called peep, the network auralizer. I've been thinking of building something like this in rust or go as a learning project, but audio streaming and mixing is harder than I thought. If someone has good libraries or tutorials there, I'd be grateful.

http://peep.sourceforge.net/intro.html https://www.usenix.org/legacy/publications/library/proceedin...

Re:Listen to your to PostgreSQL database in realtime via Web... by jensneuse on Friday April 30, 2021 @11:55AM (#26995096)
Techno livestream. BPM increases when your website gets high traffic.
Re:Listen to your to PostgreSQL database in realtime via Web... by mark-wagner on Friday April 30, 2021 @01:24PM (#26996431)
Similar: Solaris's snoop (tcpdump equivalent) with the -a option:

Listen to packets on /dev/audio (warning: can be noisy).

https://docs.oracle.com/cd/E23823_01/html/816-5166/snoop-1m....

Re:Listen to your to PostgreSQL database in realtime via Web... by krrrh on Friday April 30, 2021 @04:18PM (#26998751)
You’ve got to throw in some uncompressed pcm audio streams just to keep it interesting.

When we were learning Linux a friend and I used to pipe /dev/hda into /dev/dsp for fun and when we hit some fragments of uncompressed piano recordings we joked that we must have hit the kernel source code. Good times.

Re:Listen to your to PostgreSQL database in realtime via Web... by domoritz on Friday April 30, 2021 @01:24PM (#26996437)
Same here and I am slightly disappointed it's not what I thought it was.
Re:Listen to your to PostgreSQL database in realtime via Web... by SamBam on Friday April 30, 2021 @01:50PM (#26996845)
Same. Figured pop-pop-poppop-pop could be the background noise when we go back to the office...