2025/02/11

Newest at the top

2025-02-11 17:47:01 +0100merijn(~merijn@77.242.116.146) (Ping timeout: 244 seconds)
2025-02-11 17:46:40 +0100rvalue(~rvalue@user/rvalue) (Ping timeout: 252 seconds)
2025-02-11 17:46:15 +0100rvalue-(~rvalue@user/rvalue) rvalue
2025-02-11 17:45:26 +0100prasad(~Thunderbi@2601:243:c001:3f07::5c)
2025-02-11 17:44:30 +0100 <kuribas> kaol: It reads the information schema of the given database.
2025-02-11 17:44:12 +0100 <kaol> Schema? As in from pg_dump output or some other representation?
2025-02-11 17:44:08 +0100 <kuribas> kaol: this way you don't need access to a DB to compile the code.
2025-02-11 17:43:54 +0100 <kuribas> well, export to a haskell value.
2025-02-11 17:43:39 +0100 <kuribas> kaol: in my library you export the schema to a haskell type, then feed it to TH to get your types.
2025-02-11 17:43:08 +0100euphores(~SASL_euph@user/euphores) (Quit: Leaving.)
2025-02-11 17:43:05 +0100 <kaol> Feed the schema dump to TH to get types.
2025-02-11 17:43:00 +0100 <euouae> kaol: so from your perspective the best benefit is to learn postgresql/sql as best as one can
2025-02-11 17:43:00 +0100gmg(~user@user/gehmehgeh) gehmehgeh
2025-02-11 17:42:55 +0100ft(~ft@p4fc2a610.dip0.t-ipconnect.de) ft
2025-02-11 17:42:46 +0100 <kuribas> kaol: you cannot check against the schema without including it as types...
2025-02-11 17:42:37 +0100 <kaol> My dream is something I can just give pg_dump -s and it'd use it for everything.
2025-02-11 17:42:15 +0100gmg(~user@user/gehmehgeh) (Remote host closed the connection)
2025-02-11 17:42:03 +0100 <kaol> Or duplicate the schema.
2025-02-11 17:42:02 +0100 <tomsmeding> (please don't make me run a database to compile your code)
2025-02-11 17:41:40 +0100 <kaol> Or type safety. It doesn't even solve the whole problem unless you access the DB schema to check it against it too.
2025-02-11 17:41:26 +0100vanishingideal(~vanishing@user/vanishingideal) vanishingideal
2025-02-11 17:41:24 +0100 <kuribas> Yeah, my library is meant for when you want to compose dynamic queries. If you just need a static query, then *-simple is the easiest way.
2025-02-11 17:41:00 +0100 <kaol> Composable is kind of no op if you write the query only once.
2025-02-11 17:40:44 +0100 <kaol> If I'd have a use case for constructing queries dynamically routinely I might consider some other library.
2025-02-11 17:39:47 +0100 <kuribas> opaleye?
2025-02-11 17:39:45 +0100vanishingideal(~vanishing@user/vanishingideal) (Ping timeout: 248 seconds)
2025-02-11 17:39:32 +0100 <kaol> Queries as profunctors is as natural as I've ever seen anything to be.
2025-02-11 17:39:28 +0100 <kuribas> my library tries to be as close as possible to SQL, but remaining composable and type safe.
2025-02-11 17:38:51 +0100 <kaol> I think much better by writing and thinking in SQL than trying to play ship bottle building game with some other abstraction.
2025-02-11 17:38:34 +0100 <kuribas> no PostgreSQL yet though...
2025-02-11 17:38:22 +0100 <kuribas> euouae: shameless plug, my sql generator library https://hackage.haskell.org/package/hasqlator-mysql-0.2.1
2025-02-11 17:37:50 +0100 <euouae> I do use PostgreSQL so it's nice that hasql uses it too
2025-02-11 17:36:57 +0100 <euouae> kaol: ORM in general or just that aspect?
2025-02-11 17:36:27 +0100 <kaol> hasql is my default choice. Anything that tries to model anything by duplicating table definitions in the source is sure to raise my blood pressure.
2025-02-11 17:36:24 +0100 <euouae> how about db migrations? by hand?
2025-02-11 17:35:04 +0100 <EvanR> keeping it simple
2025-02-11 17:34:56 +0100 <EvanR> I've used sqlite-simple and postgres-simple
2025-02-11 17:34:26 +0100 <euouae> including their relationships
2025-02-11 17:34:20 +0100 <euouae> I was using SQLAlchemy on Python and it works nicely, I was able to declaratively put together all the tables of the schema
2025-02-11 17:34:00 +0100alfiee(~alfiee@user/alfiee) (Ping timeout: 276 seconds)
2025-02-11 17:33:44 +0100 <euouae> library
2025-02-11 17:33:42 +0100 <euouae> does haskell have a good sql (or otherwise) database
2025-02-11 17:33:18 +0100 <tomsmeding> nor is :m or :set
2025-02-11 17:32:53 +0100 <tomsmeding> :def is unsupported in multi-mode, lol
2025-02-11 17:29:21 +0100alfiee(~alfiee@user/alfiee) alfiee
2025-02-11 17:28:50 +0100JeremyB99(~JeremyB99@2607:ac80:407:7:b132:8d6d:8d5:36a3)
2025-02-11 17:28:43 +0100JeremyB99(~JeremyB99@2607:ac80:407:7:b132:8d6d:8d5:36a3) (Remote host closed the connection)
2025-02-11 17:26:13 +0100CalimeroTeknik(~calimero@user/calimeroteknik) CalimeroTeknik
2025-02-11 17:26:13 +0100CalimeroTeknik(~calimero@ctkarch.org) (Changing host)
2025-02-11 17:25:23 +0100 <haskellbridge> <alexfmpe> Still a bit rough around the edges but mostly works