A small lathe built in a Japanese prison camp (1949)
525 by CommieBobDole | 144 comments on Hacker News.
ads
New best story on Hacker News: Show HN: PostgreSQL index advisor
Show HN: PostgreSQL index advisor
399 by kiwicopple | 95 comments on Hacker News.
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an excellent extension to determine if PostgreSQL will use a given index without spending resources to create them. [0] pg_stat_statements: https://ift.tt/jDySqtr... [1] https://ift.tt/ZEUh0qk
399 by kiwicopple | 95 comments on Hacker News.
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an excellent extension to determine if PostgreSQL will use a given index without spending resources to create them. [0] pg_stat_statements: https://ift.tt/jDySqtr... [1] https://ift.tt/ZEUh0qk
New best story on Hacker News: Show HN: Sonauto – A more controllable AI music creator
Show HN: Sonauto – A more controllable AI music creator
441 by zaptrem | 230 comments on Hacker News.
Hey HN, My cofounder and I trained an AI music generation model and after a month of testing we're launching 1.0 today. Ours is interesting because it's a latent diffusion model instead of a language model, which makes it more controllable: https://sonauto.ai/ Others do music generation by training a Vector Quantized Variational Autoencoder like Descript Audio Codec ( https://ift.tt/0DPgaO9 ) to turn music into tokens, then training an LLM on those tokens. Instead, we ripped the tokenization part off and replaced it with a normal variational autoencoder bottleneck (along with some other important changes to enable insane compression ratios). This gave us a nice, normally distributed latent space on which to train a diffusion transformer (like Sora). Our diffusion model is also particularly interesting because it is the first audio diffusion model to generate coherent lyrics! We like diffusion models for music generation because they have some interesting properties that make controlling them easier (so you can make your own music instead of just taking what the machine gives you). For example, we have a rhythm control mode where you can upload your own percussion line or set a BPM. Very soon you'll also be able to generate proper variations of an uploaded or previously generated song (e.g., you could even sing into Voice Memos for a minute and upload that!). @Musicians of HN, try uploading your songs and using Rhythm Control/let us know what you think! Our goal is to enable more of you, not replace you. For example, we turned this drum line ( https://ift.tt/EaDjBSg ) into this full song ( https://ift.tt/EPSiZDB skip to 1:05 if impatient) or this other song I like better ( https://ift.tt/XztpqxP - we accidentally compressed it with AAC instead of Opus which hurt quality, though) We also like diffusion models because while they're expensive to train, they're cheap to serve. We built our own efficient inference infrastructure instead of using those expensive inference as a service startups that are all the rage. That's why we're making generations on our site free and unlimited for as long as possible. We'd love to answer your questions. Let us know what you think of our first model! https://sonauto.ai/
441 by zaptrem | 230 comments on Hacker News.
Hey HN, My cofounder and I trained an AI music generation model and after a month of testing we're launching 1.0 today. Ours is interesting because it's a latent diffusion model instead of a language model, which makes it more controllable: https://sonauto.ai/ Others do music generation by training a Vector Quantized Variational Autoencoder like Descript Audio Codec ( https://ift.tt/0DPgaO9 ) to turn music into tokens, then training an LLM on those tokens. Instead, we ripped the tokenization part off and replaced it with a normal variational autoencoder bottleneck (along with some other important changes to enable insane compression ratios). This gave us a nice, normally distributed latent space on which to train a diffusion transformer (like Sora). Our diffusion model is also particularly interesting because it is the first audio diffusion model to generate coherent lyrics! We like diffusion models for music generation because they have some interesting properties that make controlling them easier (so you can make your own music instead of just taking what the machine gives you). For example, we have a rhythm control mode where you can upload your own percussion line or set a BPM. Very soon you'll also be able to generate proper variations of an uploaded or previously generated song (e.g., you could even sing into Voice Memos for a minute and upload that!). @Musicians of HN, try uploading your songs and using Rhythm Control/let us know what you think! Our goal is to enable more of you, not replace you. For example, we turned this drum line ( https://ift.tt/EaDjBSg ) into this full song ( https://ift.tt/EPSiZDB skip to 1:05 if impatient) or this other song I like better ( https://ift.tt/XztpqxP - we accidentally compressed it with AAC instead of Opus which hurt quality, though) We also like diffusion models because while they're expensive to train, they're cheap to serve. We built our own efficient inference infrastructure instead of using those expensive inference as a service startups that are all the rage. That's why we're making generations on our site free and unlimited for as long as possible. We'd love to answer your questions. Let us know what you think of our first model! https://sonauto.ai/
New best story on Hacker News: Show HN: We built PriceLevel to find out what companies pay for SaaS
Show HN: We built PriceLevel to find out what companies pay for SaaS
451 by cluo21 | 126 comments on Hacker News.
Hey HN! Christine and Steven here. As a PM and engineer, we’ve both evaluated and purchased a lot of software. One of the biggest frustrations was figuring out how much it would cost us without having to go through the sales process. When we did have a quote, we had no idea if we were getting a good deal or ripped off. We built a site where you can see what other companies are actually paying for SaaS and enterprise software. Buyers contribute prices via quotes, pricing proposals, and other documentation to ensure quality. We unlocked Talkdesk for Show HN users so that you can use the product without needing to sign in or upgrade. Check it out at https://ift.tt/Ko9DdAm . Would love to hear any feedback, thank you!
451 by cluo21 | 126 comments on Hacker News.
Hey HN! Christine and Steven here. As a PM and engineer, we’ve both evaluated and purchased a lot of software. One of the biggest frustrations was figuring out how much it would cost us without having to go through the sales process. When we did have a quote, we had no idea if we were getting a good deal or ripped off. We built a site where you can see what other companies are actually paying for SaaS and enterprise software. Buyers contribute prices via quotes, pricing proposals, and other documentation to ensure quality. We unlocked Talkdesk for Show HN users so that you can use the product without needing to sign in or upgrade. Check it out at https://ift.tt/Ko9DdAm . Would love to hear any feedback, thank you!
New best story on Hacker News: Ask HN: What is the most useless project you have worked on?
Ask HN: What is the most useless project you have worked on?
581 by panqueca | 637 comments on Hacker News.
If you're feeling useless, remember that I exist. Let me give you some context. I work in the pipeline automation department of a company. Last month, our team decided to deprecate an internal tool due to several maintenance issues. So we created a pipeline that automates the implementation of this legacy tool, in case other teams needed to use it. (WHAT???) This month, a guy in my team found some improvement scenarios in the automation. So I was chosen to implement this changes in this legacy internal tool. The thing is, after I finished the adjustments, my pull requests are not getting approved due to adjustments meticulously requested by this guy in my team. Adjustments to make the pipeline automation even more resilient in complete unlikely scenarios. But this same week, my TL sent notices to all the other teams informing them that this internal tool has been deprecated and they should no longer use it. So what sense does it make to have a pipeline automation that implements the use of the deprecated tool? And if it has been deprecated, why would I need to make an adjustment for the automation to be even resilient if no one should be able to use it anymore? So why am I being allocated to work on in such waste of time like it? (WTF???) This makes me wonder, how many people have to work on something that they see no sense in doing at all. So once again, if you're feeling useless, remember that I exist.
581 by panqueca | 637 comments on Hacker News.
If you're feeling useless, remember that I exist. Let me give you some context. I work in the pipeline automation department of a company. Last month, our team decided to deprecate an internal tool due to several maintenance issues. So we created a pipeline that automates the implementation of this legacy tool, in case other teams needed to use it. (WHAT???) This month, a guy in my team found some improvement scenarios in the automation. So I was chosen to implement this changes in this legacy internal tool. The thing is, after I finished the adjustments, my pull requests are not getting approved due to adjustments meticulously requested by this guy in my team. Adjustments to make the pipeline automation even more resilient in complete unlikely scenarios. But this same week, my TL sent notices to all the other teams informing them that this internal tool has been deprecated and they should no longer use it. So what sense does it make to have a pipeline automation that implements the use of the deprecated tool? And if it has been deprecated, why would I need to make an adjustment for the automation to be even resilient if no one should be able to use it anymore? So why am I being allocated to work on in such waste of time like it? (WTF???) This makes me wonder, how many people have to work on something that they see no sense in doing at all. So once again, if you're feeling useless, remember that I exist.
New best story on Hacker News: Show HN: I've built a locally running Perplexity clone
Show HN: I've built a locally running Perplexity clone
482 by nilsherzig | 99 comments on Hacker News.
The video demo runs a 7b Model on a normal gaming GPU. I think it already works quite well (accounting for the limited hardware power). :)
482 by nilsherzig | 99 comments on Hacker News.
The video demo runs a 7b Model on a normal gaming GPU. I think it already works quite well (accounting for the limited hardware power). :)
Subscribe to:
Posts (Atom)