Wednesday, April 19, 2023

Show HN: Database for analyzing US companies, visualize using Apache SuperSet https://ift.tt/JyGfNkl

Show HN: Database for analyzing US companies, visualize using Apache SuperSet My main motivation was that I wanted to be able to drill down and filter across all the available stocks, look at the data for myself, and narrow down on the stocks I am interested based on my own sets of criteria, and make data-driven analysis for my personal investment strategies. I used PostgreSQL as the backend database for ELT data pipelines, and used Citus Data cstore_fdw for columnar compression for the final dataset. All financial data is coming from SEC Edgar, https://ift.tt/gd7hXlJ . I used Python for downloading most of the data. I also run the data load development locally on my home Ubuntu server that I built 5 years ago. I bought 4TB of M2 disks for best database performance, with PRIME B360M-A motherboard and Intel Chip Coffee Lake S. I built the website simply using WordPress, and I run Apache Superset using gunicorn via Apache Webserver reverse proxy. The registration form I had to build myself with PHP and some JavaScript, because it needed to automatically create a SuperSet user upon registration. Otherwise, I would need to input everyone manually. I used Python again for the data integration. Please don't use the database directly as an investment tool, as its in Beta, and the data still needs to undergo heavy data quality checks, please confirm all the numbers yourself, as I provide a link for every company to the SEC filings. https://ift.tt/RAWzv3u April 19, 2023 at 02:46AM

Show HN: AI Playground by Vercel Labs https://ift.tt/dFKaGBJ

Show HN: AI Playground by Vercel Labs Hey, Jared Palmer (creator of this playground) here. Really excited to ship this. I’ve been building this over the past few weeks to compare LLMs from different providers like OpenAI, Anthropic, Cohere, etc. At Vercel, I manage our Frameworks division (including Next.js, Svelte, and Turbo) and wanted to also dogfood some of the latest features in a slightly larger application. This playground takes a lot of inspiration from https://nat.dev and is built on Tailwind, ui.shadcn.com, and some upcoming Vercel products we’re announcing soon. We’re going to continue adding models to compare and add other frameworks to generate code snippets from. https://play.vercel.ai April 19, 2023 at 04:08AM

There’s a Community Shuttle Coming to the Bayview

There’s a Community Shuttle Coming to the Bayview
By

Several individuals with masks huddle for a group photo in front of a colorful mural backdrop in an our setting.

A new shuttle to serve Bayview’s diverse communities

A new community shuttle is coming to Bayview-Hunters Point in January of 2024, and we need your help designing it! The SFMTA is partnering with the California Air Resources Board and nine community-based organizations to launch a dynamic service community shuttle that truly meets your needs. A community shuttle has been a long-desired service for this geographically isolated community, and was identified as a top priority in the Bayview Community Based Transportation Plan. This program builds off of previous community shuttle efforts like the Bayview Moves program. To share your voice, take our survey now or attend one of our upcoming community partner events.

A “dynamic service” shuttle is one that doesn’t have a fixed route like a bus line, but instead operates in a “service area.” The shuttle will pick up and drop off riders anywhere within the Bayview area and connect them to hard-to-reach destinations like community centers, regional transit and grocery stores. Combined with Muni service, this program will help Bayview-Hunters Point residents get around more easily while reducing car trips and improving air quality.

A Community Shuttle only works if it is accessible, feels welcoming and gets people where they need to go. That’s why the SFMTA will be working with residents through the summer and fall of 2023 to build a service plan that works for the community.

This is where you come in. We want to know how you might use a shuttle like this. Would you use it during commute hours or on nights and weekends? Would you ride within your immediate neighborhood or to destinations like the 24th Street BART station and SF General Hospital? How long would you wait for a shuttle to arrive? Would you walk to the corner or a block away for a pickup? Answers to these questions will help us build a shuttle that meets your needs.

We want to establish shuttle service that effectively serves the people living in Bayview-Hunters Point today, and the more feedback we get, the better. You can get involved in the following ways:

This program also includes job training, a Community Congress that will provide project oversight, and a Third Street storefront for transit information and services. You can find more information on our Fact Sheet.



Published April 19, 2023 at 02:42AM
https://ift.tt/w4HbNqr

Show HN: Offsuit – Casual Poker, Redesigned https://ift.tt/vBQlhFf

Show HN: Offsuit – Casual Poker, Redesigned For the past year my friend and I have been building a dead simple offline poker app that we actually wanted to spend time in. No constant pop-ups. No account needed. No waiting for tables. No fake felt or neon. Just free poker against intelligent AI opponents with helpful in-game stats. We’ve started offline, but are working towards online-multiplayer, tutorials for new players, and more in-game stats. Would love your feedback! https://offsuit.app/ April 18, 2023 at 07:37PM

Show HN: tokmon – CLI to monitor your program's OpenAI token costs https://ift.tt/G4COBxn

Show HN: tokmon – CLI to monitor your program's OpenAI token costs https://ift.tt/A9xsjOh April 18, 2023 at 10:45PM

Tuesday, April 18, 2023

Show HN: Cyte – A visual, searchable knowledge base of your screen time https://ift.tt/n3tyiUI

Show HN: Cyte – A visual, searchable knowledge base of your screen time https://ift.tt/FOAqmTP April 18, 2023 at 07:19AM

Show HN: ThinkGPT: a library to prompt GPT to think, memorize and self-refine https://ift.tt/RdboD1a

Show HN: ThinkGPT: a library to prompt GPT to think, memorize and self-refine https://ift.tt/AdTPq8Z April 18, 2023 at 04:36AM

Show HN: Ciara – Securely deploy any application on any server https://ift.tt/nbETeJq

Show HN: Ciara – Securely deploy any application on any server Hey HN! Coolify and Kamal were "nice" (Kamal docs are pretty bad, a...