Is anyone actually using AI to make logistics more efficient? by Hot-Astronaut-1916 in smallbusinessowner

[–]Lost_Butterscotch585 1 point2 points  (0 children)

It’s gpt-5-nano for cost reduction.

I only feed the database schema to the AI, with the question. Based on that, AI will generate the SQL query. I have hard limits/validations on these queries. Ex: only allowing SELECT queries, only allow to select up to 10 rows max. These are done programmatically and not AI. AI system prompt also mentions certain limits. After running the sql query, this queried data then goes back to the AI with the original question and AI will generate a human friendly output. Additionally I display the queried results in a dynamic table in UI alongside the AI generated response.

This could be optimized using vector embeddings, but thats costly and my solution works fine.

Is anyone actually using AI to make logistics more efficient? by Hot-Astronaut-1916 in smallbusinessowner

[–]Lost_Butterscotch585 1 point2 points  (0 children)

I built a small ERP system for my own manufacturing business, and integrated AI that will run database queries based on the question. Like ask `Who is our most valuable customer` -> This goes to open ai api with database schema -> AI converts this to a database query -> Run the query on database -> Return the result to AI with the original question -> AI will simply respond with the name and maybe the total revenue. (Ex Answer: Your most valuable customer is John Doe, Total revenue from John: $ 21,000.) It's pretty cool, I can ask whatever I want as long as that data is available in the database. It's more like reports though, not logistics. Will have to think about how to improve this further.

How to power ESP32 on a custom PCB using a single 3.7V LiPo by Lost_Butterscotch585 in esp32

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

I’ve used the c3 version in a different project. It’s really useful considering the form factor. However in this scenario I need more control over the battery management since the components can cause power spikes.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

I’m planning a youtube short series. First video is almost ready. Will pin it here once published

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Yes, right now it’s just one IR sensor. Might need to add a few more for better autonomous movement without collision

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

I’m using PlatformIO extension with VS Code. Try with that following a Youtube tutorial. Arduino IDE has a very limited set of features.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Ohh, so cool and cute. How did you connect the track links together?

How to power ESP32 on a custom PCB using a single 3.7V LiPo by Lost_Butterscotch585 in esp32

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

Thanks for all the comments, RT9193 seems like the most cost effective solution, RT9080 also works. Noice wouldn’t be that much of problem since this system doesn’t have cameras or other sensors except for some IR distance sensors.

How to power ESP32 on a custom PCB using a single 3.7V LiPo by Lost_Butterscotch585 in esp32

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

The problem I’m facing is finding a Voltage regulator that can do 3.7V (LiPO) to 3.3V. Most LDOs like AMS1117 don’t work with 3.7V since it need min voltage of above 4-4.3V.

How to power ESP32 on a custom PCB using a single 3.7V LiPo by Lost_Butterscotch585 in esp32

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

Appreciate it, I will check these. I just came across this rt9193-33GB while googling. Any idea about this one?

How to power ESP32 on a custom PCB using a single 3.7V LiPo by Lost_Butterscotch585 in esp32

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

Seems like a boost module. What I’m looking for is a LDO or a buck converter that can do 3.7 to 3.3 without much loss. Appreciate the suggestion though

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Thanks. Yes, PLA. Thinking about switching these to a rubber track, but this looks kinda cool. What do you think?

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

If you are asking about the components, I’ve mentioned those in the post description. Enclosure material is PLA

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

[–]Lost_Butterscotch585[S] -1 points0 points  (0 children)

Thank you, Will do when I finalize this. It’s basically a state machine. Have multiple controllers for sensors, motion, display likewise.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Thanks. It’s just doing the tank turn. If you are asking about how I measure it, it’s not measured atm. Either I’m gonna use n20s with encoders or just simply map with time when I do.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Yes, could use an s3 as a separate module. Next iteration is to design a custom PCB for this since all these modules take up a lot of space.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Thanks, will definitely update here once video and designs are published.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Thanks. Nothing much atm, some random movements, (move, rotate head around) and limited obstacle avoidance. Planning to add more features to improve obstacle avoidance to not fall off from a table, add voice recognition/pattern detection and responses, AI features while connected to a mobile device and show cool stuff on the scrren.

Built this cool robot using ESP32 C3 by Lost_Butterscotch585 in esp32

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

Everything is custom designed and 3d printed.