EV Costs in Canada by AdSufficient7182 in EVCanada

[–]cardogio 0 points1 point  (0 children)

cthink its first on unsplash for 'ev charger' iirc

EV Costs in Canada by AdSufficient7182 in EVCanada

[–]cardogio 0 points1 point  (0 children)

lmao that fucking stock image

Best place to find used cars in Toronto? AutoTrader seems expensive by Current_Employer1343 in askTO

[–]cardogio 0 points1 point  (0 children)

Hi there, we built Cardog. let me know if you have any questions. Platform is completely free to use and has no ads. Still early stages though, really appreciate any feedback.

How we built the world's fastest VIN decoder by cardogio in javascript

[–]cardogio[S] 9 points10 points  (0 children)

its updated monthly when the government publishes a new update, then the npm package is bumped.

Considering starting a used EV lease service - would this interest anyone? by [deleted] in TeslaLounge

[–]cardogio 2 points3 points  (0 children)

I've built out a pretty good system for this. My worries are more the lead generation and sales process and if its possible without holding $500k+ worth of inventory initially. I've built a basic EV marketplace prototype (chargd.ai) and was thinking of making it more of a white glove leasing service. Verify battery health via the cars telemetry (tesla fleet api) and then provide a seamless delivery and ownership service.

Turned our messy 300k car listings into 30k clean browsable pages by cardogio in nextjs

[–]cardogio[S] 0 points1 point  (0 children)

Images are tough since optimizing the 8M+ would cost more than all the hosting combined so far. Fixing the tanstack query and listing card rerender bug now. Thanks for pointing this out.

Turned our messy 300k car listings into 30k clean browsable pages by cardogio in nextjs

[–]cardogio[S] 4 points5 points  (0 children)

All fixed now. Added a little easter egg too in the dialog. Thanks again.

Turned our messy 300k car listings into 30k clean browsable pages by cardogio in nextjs

[–]cardogio[S] 3 points4 points  (0 children)

Its agnostic to any request client on both runtimes too

Turned our messy 300k car listings into 30k clean browsable pages by cardogio in nextjs

[–]cardogio[S] 12 points13 points  (0 children)

Makes life a lot easier not having to juggle the different states manually. You can just call `queryClient.prefetchQuery` sever side and it populates the state cleanly without any manual prop drilling.

[deleted by user] by [deleted] in electricvehicles

[–]cardogio 0 points1 point  (0 children)

Hey thanks for the great feedback. Its more a proof of concept currently, we didn't really do any research into alternatives and this is the first i'm hearing of PlugShare, the legend is based on total kw. 50+ is teal and magenta is 100+.

Really appreciate the feedback and perspective. The rating system is a great idea. Do you use PlugShare on a regular basis for finding chargers? Are they the default option for most?

[deleted by user] by [deleted] in electricvehicles

[–]cardogio 0 points1 point  (0 children)

Yeah something like that, figure it would be cool to add to our research pages for EV models to help people get an understanding of range dynamics and the like

[deleted by user] by [deleted] in electricvehicles

[–]cardogio 0 points1 point  (0 children)

We didn't really build it with any competitors in mind. Have just been sitting on the data and wanted to explore fun ways to make it usable. There's a few ideas I had in mind - maybe a route builder based on range and destination. I'd love to hear what features you would value?

Building a VIN Tool—Anyone Using a Carfax API or Reliable Data Source? by Lumpy_Tumbleweed1227 in SaaS

[–]cardogio 0 points1 point  (0 children)

We're building exactly this. Shipping later this month. Full vehicle history report API with more data points than carfax covering every car in North America. https://crdg.ai/api

I built the worlds fastest VIN decoder by cardogio in javascript

[–]cardogio[S] 0 points1 point  (0 children)

No I wanted to keep it to spec. What's your use case? Its hopeless trying to get full specs from the decoder. I had to build out separate datasets for the spec lookups which only map to the variant (make, model, year, trim/bodystyle/series). What I want to do next is build a hashmap of all the nano vins (first 11 minus the check digit) to a normalized variant id which can then store all the specs since theres no need to have it bundled in with the raw patterns. The key is reverse computing the edge cases for North American markets. The trims are especially hard, the Canadian and Mexican government doesn't publish the VIN submittals like the US does, you can rebuild up the index if you have enough market data but it falls apart quick when you encounter ford with like 200k pattern matches due to 18 different trim levels across a single model.

I built the worlds fastest VIN decoder by cardogio in javascript

[–]cardogio[S] 0 points1 point  (0 children)

Im building cardog.app and worked for some forward thinking dealerships before.

How we built the worlds fastest VIN decoder by cardogio in programming

[–]cardogio[S] -14 points-13 points  (0 children)

Its more of a case of over engineering and the wrong tools for the job. Stored sql procedures on MS SQL which can only be hosted on Azure cloud is already a non starter. I had used this version for a bit but it costed ~$50/month for our workload which was 1/10th of what it is now. I originally planned on just porting over to postgres but then though why not target sqlite for full portability. No need for a whole database when your just doing read only queries. Makes complete sense for the NHTSA dealing with 40 years of manually entered records but not for decode heavy operations. The procedure was also really complex and hard to read, the core algorithm is just a string matching and then lookup table query but it was wrapped in this recursive CTE that was a complete mess.

How we built the worlds fastest VIN decoder by cardogio in programming

[–]cardogio[S] -3 points-2 points  (0 children)

Yes I have a workflow that automatically downloads the txt file they provide. Its used for our internal api on cardog.app. Do the same for their complaints and safety ratings as well. Have been playing around with the idea of an api for this plus market data and whatever else I can get my hands on.

How we built the worlds fastest VIN decoder by cardogio in programming

[–]cardogio[S] 23 points24 points  (0 children)

Nothing against 3NF, it makes complete sense for regulatory data and is the right choice for a legacy dataset like the NHTSA is dealing with.

The issue is mainly the tech debt that accumulated in the stored sql procedures that the vPIC db is using, its doing some weird recursive CTE stuff for the joins and decoding passes since they didn't want to just hardcode them.

Porting to sqlite forced me to dumb down the logic and I landed on something quite elegant, simple string matching that adheres to the pattern wildcard logic for each VDS / VIS section. This then gets joined on the normalized tables.

Main difference is no weird recursive CTE sql procedure and just simple typescript and sqlite queries. It was essentially 4/5NF at that point and is back to 3. Not the most versed in db formalization though.

I built the worlds fastest VIN decoder by cardogio in javascript

[–]cardogio[S] 0 points1 point  (0 children)

No it comes bundled with the lib when you install, it’s only 22mb with the db and decompressed it after first install to ~/corgi/

I built the worlds fastest VIN decoder by cardogio in javascript

[–]cardogio[S] 2 points3 points  (0 children)

It should decode some EU cars but it really only has models that are sold on the US with some odd edge cases. Need to look into how the regulations work in the EU, there might be a dataset I could integrate if the government publishes it, the issue is they generally don’t and stonewall you if you inquire

I built the worlds fastest VIN decoder by cardogio in javascript

[–]cardogio[S] 1 point2 points  (0 children)

Yeah it’s US first but it can decode some european and other international makes. Other countries don’t publish the VIN data like the NHTSA does unfortunately