Monazita, F# library for working with PostgreSQL

Hacker News

I'm happy to share an F# library to interact with a postgresql database in a railway oriented programming style[3] and writing SQL queries. It is available at https://gitlab.com/monazita/monazita/ with documentation at https://monazita.gitlab.io/monazita/ It was developed for a web application [1] requiring the use of specific SQL queries (using the table_func[2] plugin for crosstab queries) which prevented the use of more traditional ORM-style libraries. As I was also using the development of that application to dive into functional programming, I decided to try a fully functional approach[4]. It proved itself a very useful approach, to the point I thought it was worth to share it as a Nuget library [6]. I particularly like the fact that I can * write normal sql with parameter substitutions using printf placeholders. If you don't want to write SQL, this library is clearly not for you :-) * define the queries and data manipulations without worrying about the connection to the database. This allowed me to define all queries and data manipulations in a library [5] where I'm not concerned about handling connection issues, which is done in the app code using that library. The library is released under the LGPL license, and is published as an alpha stage project because it still needs some cleanup after its extraction from the web app it originated from. But I'm following the "release early, release often" approach here, also to gauge interest. This library only supports postgresql for the moment, but in the mid-term I'd like to support other databases, starting with sqlite. 0: https://monazita.gitlab.io/monazita/ 1: http://www.myowndb.com 2: https://www.postgresql.org/docs/current/tablefunc.html 3: https://fsharpforfunandprofit.com/rop/ 4: https://fsharpforfunandprofit.com/posts/elevated-world-6/#re... 5: https://gitlab.com/myowndb/myowndb/-/tree/master/lib This library defines all data retrieval, insertions, updates, transformations, etc without ever handling a database connection. 6: https://www.nuget.org/packages/Monazita

Visit product View on Hacker NewsFeb 22, 2024

Share card

Actual performance

4points

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Indie HackersFits the IH revenue-focused audience · Strong signals: supports, para · Missing: reddit linkedin, podcasting, created

73%73% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released

66%66% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

46%46% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Product HuntUnlikely to reach the leaderboard · Strong signals: using, code · Missing: mac, agents, macos

44%44% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Strong signals: way, para · Missing: mobile apps, ios, personal

39%39% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Strong signals: profit · Missing: arr, mrr, revenue

13%13% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Incorrect prediction on native model

Similar products

Spans 1.0, a Pythonic library for working with intervals51%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Spans 1.0, a Pythonic library for working with intervals

Hacker News4

Versionparser – Java library for working with versioning schemes43%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Versionparser – Java library for working with versioning schemes

Hacker News2

Kafka FDW for PostgreSQL65%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Kafka FDW for PostgreSQL

Hacker News2

es2postgres – ElasticSearch to PostgreSQL Loader71%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

es2postgres – ElasticSearch to PostgreSQL Loader

Hacker News3

Metagration: PostgreSQL Migrator in PostgreSQL56%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Metagration: PostgreSQL Migrator in PostgreSQL

Hacker News1

PRQL in PostgreSQL73%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PRQL in PostgreSQL

Hacker News267

Quickgres.js, 430 LoC pipelined PostgreSQL client library61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Quickgres.js, 430 LoC pipelined PostgreSQL client library

Hacker News6

Queries, a pythonic PostgreSQL client library56%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Queries, a pythonic PostgreSQL client library

Hacker News1

PGLite – PostgreSQL in the Browser72%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PGLite – PostgreSQL in the Browser

Hacker News4

HackerBracket – What are you working on?48%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

HackerBracket – What are you working on?

Hacker News60

Browse all products Analyze your launch