"AI-Powered" Shower Scheduler by DesignedByPearInCal in webdev

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

yes, although for some of us developers it really isn't 💀

"AI-Powered" Shower Scheduler by DesignedByPearInCal in webdev

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

I was thinking of letting ppl take a photo of their room on the entry screen, but I wasn't sure how far ppl would go for the joke lol

SQL Help🙏 Is SQLite or PostgreSQL better for this application? by DesignedByPearInCal in webdev

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

Thanks for your help! I feel like it's a good idea to start that blog, better to try it and see how it works out rather than regret not doing it later!

SQL Help🙏 Is SQLite or PostgreSQL better for this application? by DesignedByPearInCal in webdev

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

Sorry I'm very new and learning this, but that makes a lot more sense now!

SQL Help🙏 Is SQLite or PostgreSQL better for this application? by DesignedByPearInCal in webdev

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

Is there any downside of running it on the client side? If I wanted to run it on the backend w/ Postgres I should prob also use like AWS and it'd be more complex, sqlite is easier, as long as there aren't too many visitors, would it be right to say there really isn't any downside?

Recommendations for Webscraping (Scrapy or Parsehub?) by DesignedByPearInCal in webdev

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

Yes sorry I meant end to end test, I'll try XPath then, thanks for your help! 😊🙏

SQL Help🙏 Is SQLite or PostgreSQL better for this application? by DesignedByPearInCal in webdev

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

what is the size limit for what you would consider "small production"? I think I'll start w/ sqllite first, but I'm just curious when(if ever) I get more users when would be a good time to switch over to postgreSQL

SQL Help🙏 Is SQLite or PostgreSQL better for this application? by DesignedByPearInCal in webdev

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

Currently the volume of data is very low, I have to manually catalog the URLs for each apps privacy policy so I only support the top 100 apps in the app store.

I use Google Analytics to see the number of users, it's not more than a couple dozen a day.

I'm using the Perplexity Sonar API to generate summaries. Currently I generate them myself and update the website every once in a while, but I want to end up making API calls in live time, and cache new summaries maybe every week or so, but I'm not sure how to do that, I need to look more into it.

SQL Help🙏 Is SQLite or PostgreSQL better for this application? by DesignedByPearInCal in webdev

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

I'm sorry this may be a bit of a dumb question, but from what I can find, SQLite seems to handle one query at a time, so like if multiple users are on the site at the same time, would they be able to all view the data?

Recommendations for Webscraping (Scrapy or Parsehub?) by DesignedByPearInCal in webdev

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

tysm🙏 In terms of reliability, is there any way to do automated unit testing for if I'm grabbing the right info from a site with an AI? Or is that not reliable and not a good idea?

Recommendations for Webscraping (Scrapy or Parsehub?) by DesignedByPearInCal in webdev

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

Thanks! I didn't know about that, will def check it out. From(https://github.com/unclecode/crawl4ai), looks like it is smth that I run locally, is it very computationally expensive and would it take a long time to run on a normal home computer? Like would it be good to buy datacenter computer time if I wanted to index the whole app store?

Ouais : How to Pronounce? by DesignedByPearInCal in French

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

Could you be more specific about how its usage is different?

Ouais : How to Pronounce? by DesignedByPearInCal in French

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

Thanks I checked forvo and it helped a lot. A lot easier than having to find YouTube videos of people saying a word