Any advice for dealing with very big tables in IHP? Product page here has gotten so dreadfully slow even when paginated and client-side loaded:
https://dill.network/Products
There is 2 million products in the DB, so big, but I guess it'…
Has anyone done nested comments in IHP in a clean-ish way yet?
I get the feeling that comment_id / parent_id inside the comments table is not a a good idea, but would be nice if I could just do that :)
I'm a bit skeptical to nested sets…
Happy New Year everyone!
I think I have overheard some different techniques for DB diffing to the IHP fixtures on Slack, so hope someone has some input.
Does anyone know of a good way to import the database in production and hydrate the loc…
My understanding of the collectionFetchRelated method is that if I query for 100 posts, they will be returned in one query, and then if I want their comments the >>= collectionFetchRelated will then run 100 more queries to return each…
I set up a websocket connection using this example
https://ihp.digitallyinduced.com/Guide/websockets.html
Would it be possible to track certain DB tables here as well? Like AutoRefresh is doing for actions. I want to push something over WS…
If I load and run a /Main/Test.hs module to ghci from an IHP app and run the test suite one I get expected behaviour. But if a test fails and then I try to run main again from ghci prompt I get a:
# PENDING: exception in beforeAll-hook …
We are a mid-tier Web development company. All our clients already use MySQL and it is nearly impossible to make them consider anything else. I may be wrong, but in my experience everyone in this market uses MySQL, it is ubiquitous (though …
Hey y'all,
Just posted this question to stackoverflow regarding modeling a one-to-zero-or-one relationship.
Any suggestions (here or there) are welcome.
Hopefully the answers can serve as a reference for folks needing to setup this sort…
So, the necessary backstory is I have a big internal application I happen to support which is built on MSSQL, and it's at best infeasible to migrate it to PgSQL. I really would love to move away from the hodgepodge it is today, but rewr…
I've seen previously that it isn't possible (from about 4-5 months ago), but I'm looking to see if it's on the roadmap. I've been doing quite a bit of devcontainer development these days, and like to keep my db in a sepa…
I'm trying to model a many-to-many relationship with containers containing items which can belong to multiple containers with the help of a container_items table defined like so:
CREATE TABLE container_items (
container_id UUID NOT …
I'm just starting to play with this and so far I like what I see, but is there a way to connect to an existing db? I'm not 100% through all the docs yet, so I may have missed it.
…