Hacker Search

should i use drizzle or prisma?

share

Summary of results

GPT-5.2
Warning: quote links might not work while streaming
1.

You should consider the similar reasons why you chose Kysely over Prisma. Prisma has far broader adoption. https://npmtrends.com/drizzle-orm-vs-kysely-vs-prisma

2.

I substantially regret using Prisma in production for this and very many other reasons.

At least the underlying data is well modeled, just need to rip out the JS library and replace it… but with what?

3.

Love Prisma. Been using this for a few side projects as well as on my company projects, and it worked out really well for us.

4.

> There’s no one go-to

I thought Prisma.js was the most popular by far? It's the one I've always seen used in docs and examples.

5.

I went with Prisma + Nexus + Pal.js + Apollo, which was probably at least two layers too complex.

I'm looking, still, for an all-in-one solution to this, though I do need more control over my queries/mutations than what Hasura would give me.

6.

Can DRIZZLE help to achieve higher resolution? Though with hundreds of photos this will imply a lot of work:

https://en.wikipedia.org/wiki/Drizzle_(image_processing)

11.

The use of Prussian blue is rampant in most painting programs. The reason is that you are essentially getting two paints for the price of one. When applied thinly, it is light and saturated. When applied thickly it is almost black. Contrast that with cobalt blue, which looks the same pretty much however you use it.

Alizarin crimson behaves similarly.

Painting with either of these pigments it is relatively easy to get superficially impressive effects.

As a painter and also a digital artist, I am always amazed by such physical dimensions of oil paint. Another example is the huge difference between zinc white (low in coverage, good for transparency, slightly cold), and titanium white (high in coverage, good with mixing with other pigments, more neutral).

12.

PragmataPro looks great, thanks for the tip!

I didn't necessarily select the one closest to what I currently use in the game, but more looking at the shapes of different characters to see what looked the "nicest".

14.

Indirectly I use Mistral daily: I like Proton’s Lumo private chat and that runs on Mistral technology. Something like Lumo is very much good enough to replace search and general information browsing and for me is very practical.

What is not so practical is my paying for Gemini Ultra, which has some practicality but is something I pay for because it is fun using strong AIs like Claude and Gemini Pro in AntiGravity. It feels funny to admit paying a lot of money just to have fun with something.

I wish Mistral good luck, and I like their deployed forward engineers approach to business. Seems practical.

15.

I've tried both Chroma and Qdrant. I don't think Chroma lacks that much. Definitely newer, but is also a great product. I think cloud support coming Q3 2023

17.

I've been using Mistral Medium 3 last couple of days, and I'm honestly surprised at how good it is. Highly recommend giving it a try if you haven't, especially if you are trying to reduce costs. I've basically switched from Claude to Mistral and honestly prefer it even if costs were equal.

18.

Oh, wow, thanks! I've only been using Midjourney but the other models you showcase really do adhere much better to the details of the prompt. Do you know how I can get them to adhere to style suggestions better? They seem to be biased toward photorealism but that's not the vibe I'm going for. (I tried both Gemini 3.0 Pro and Seedream.)

22.

I think I prefer the results from the other approaches listed in the examples, e.g. material blending: https://orikmcfly.artstation.com/projects/9zRna

24.

Dall.e is much better at understanding what you want. And sometimes stable diffusion feels a bit overfitted on some prompt (especially with cars).

But Dall.e is often behind in terms of image quality. They are nice looking from far, but a bit more blurry or weird than stable diffusion if you look closely.

However you can use boths together. These days I tend to use stable diffusion first, but when a prompt is not going well I copy paste it in dall.e and get what I meant much easily. And then I import the dall.e generated image in stable diffusion to work it a bit more and get something a bit better looking.

25.

How does PragmataPro vs Iosevka compare?

I use Iosevka, but am curious about PragmataPro

26.

Tossing this one in here as it's a combination of Isoveska & PragmataPro: https://github.com/shytikov/pragmasevka

Been using it for a bit and I've really fallen in love with it.

27.

I've had better luck with Stable Diffusion using impressionist/surrealist/etc. styles because you don't really expect the results to be "right" in a literal sense.

31.

How do these techniques handle transparent, translucent, mesh/gauge/hair like objects that interact with background.

Splashing water or Orange juice, spraying snow from skis, rain and snowfall, foliage, fences and meshes, veils etc.

33.

As someone who teaches both oil painting and digital painting, I find this project fascinating. They have certainly identified two of the key difference between digital and real paint:

- RYB mixing (e.g. yellow painting plus blue paint = green). I tested it on a mix of alizarin crimson plus hansa yellow to produce a cold orange (e.g. blood orange).

- Relative behavior of specific pigments. For example, a Prussian blue is almost black when applied thickly, but very chromatic when applied as thinly over white. A cerulean blue is pretty much the same in those two states. I tested this on a Prussian and the app performed well.

The app seems to make the assumption that the artist will always want the paint to mix. In a glaze, a thin transparent layer of paint is applied over dry paint. Effectively the result is a filter (the result will always be darker). To a degree, this can be faked using paint applied in a layer the blend mode of which has been set to multiply. It might be nice to add a drying brush to the tool set which selectively dries the paint to prevent mixing. Maybe also a mode switch to selectively different modes of physical application such as glazing, scumbling and dry brushing. While we are at it, why not add a Tonk mode using which thick paint can be lifted off the surface without smudging.

When I paint digitally, I mix the incredible nuance of real paint... even its smell. When I paint with oils I miss the incredible flexibility of the digital process (blend modes, compositing, even the humble undo). Never the twain...

34.

The starting colors are actually identical. Try painting a 100% opaque color pool and then switch between Mixbox and Normal. You'll see that the colors are the same. The difference is their behavior in thinner layers - when the brush opacity is lower.

When you spread dark pigments over a white canvas, they usually turn very radiant, saturated colors. Phthalo Blue turns from dark purplish blue into turquoise for example. RGB mixing doesn't handle those saturation gains and that's why a brush stroke made in the 'Normal' mode looks way more dull than the brush stroke made in 'Mixbox' mode with the identical starting color.

This is actually an important point of pigment mixing. The saturation gains and hue shifts when pigments get spread or mixed with white are beautiful. RGB linear mixing (the 'normal' mode) doesn't capture them.

35.

I have just been working with photoprism. Ente looks nice but going to stay with photoprism as I like the go binary and can build features I want.

37.

I suspect you're thinking of Craiyon (formerly DALL-E Mini) which is a derivative (but distinct) project, and consistently does the beige swirls. DALL-E 2 proper is much higher fidelity, and seems much more reliable at generating passable (if imperfect) faces from what I've seen.

38.

Curious what you're using for film grain imitation?

39.

The method in this paper is different than most existing RDT applications since achieving the best results requires much more water than anyone was previously suggesting. The heuristic that James Hoffman has espoused is 3-4 spritzes of water per 18g of coffee. Obviously this depends on the spritzer you use, but it’s much more water than people have used before so questions about that effect are valid. The paper addresses these concerns somewhat by measuring humidity in the grind chamber, and they found that it dropped to ambient on the order of a minute after grinding finished.

41.

They always use shear-thickening fluids because they're so counterintuitive, but shear-thinning fluids are a fun example of a mixed blessing — the same property that keeps paint from dripping off a brush/roller until you apply it is also what makes it so hard to pour the right amount of ketchup.

42.

What are the blurry sparkler firework type smears?

43.

I've used Dall-e, midjourney, and stable diffusion, and given my total inability to draw anything properly its like competing in a 100m sprint in a drag racer.

44.

> And then of course you get into inks.

Shimmering inks (inks with glitter suspended in them). You will probably need to use dip pens (I like glass ones), but the results are stunning. Not something you'd ever expect to see out of a pen.

Plus, you an also use thinned acrylic paints with dip pens...

45.

No drips.

No cleanup.

No need for figuring out what to do with the canvases.

Any color of paint you want, possibly including ones like "polka dots" or "tiled faces of Nic Cage" or "color-cycling rainbow".

And your brush strokes can be 3d contours of virtual paint hanging in the air instead of marks on a flat canvas.

46.

I heard if you use immersion type method like the Hario switch it is very forgiving and consistent even if you screwup grind size and temperature. Vs percolation (flow) v60 you have to deal with a lot more issues such as time/flow rate, channeling etc.

47.

Depends what you want.

Dalle 3 is super good, but lacks the creative control controlnets and ip-adapter provide. So for instance afaik there is no way to perform style transfers, or ’paint a van gogh portrait over my pencil sketch’.

Both are good currently but at different things.

”Prompt engineering” is and will be total bs. Dalle3/chatgpt provides the actual workflow we want where we describe to the intelligent agent (chatpgt) what we want and it worries over the accidental-complexity-intricasies of the clip model itself.

48.

How did you decide what 3 colors to paint them with for the test?

49.

Interesting they both do.

Does Qdrant look like a winning horse then?

Was about to use Weaviate for a project today and this gives me pause. Anyone have some strong opinions? pg_vector also been on my radar recently. Qdrant vs Weaviate I know is partially a rust vs go topic.

50.

It's just a completely different paradigm of rendering and it's not clear which one will be dominant in the future. Gaussian splats are usually dependent on initialisation from point cloud, which makes whole process much more compliacated.

51.

Inpainting/guiding from a sketch is how I've always used diffusion models. I thought everyone did that, or at least everyone who wasn't just trying to get some arbitrary filler material without much care of what the output looked like.

52.

Could you give me an example? I'd love to know more about the watercolour paint mixing.

If you meant the "live tip" settings of Photoshop, you can do all that in Krita too, using the "texture", and "mask tip" features. RGBA seems to definitely be something Krita has over Photoshop, but I could well be wrong!

by the way, there are other softwares like Rebelle that try to truly simulate traditional mediums - bordering on a whole-ass physics engine that works completely different in the backend from PSD/Krita. Unfortunately its a paid software so yeah :s

53.
54.

Depends what you're after but Krita seem to do pretty well

55.

I just compared and evaluated Hatch, Flit, Poetry and Pdm and found Pdm to be most robust and slimmest. Hatch was a good second option, and Poetry and Hatch are easy to use, but have too much bloat and magic.

56.

This is great. I paint miniatures and once you get past the basics and start using glazes for filters/blends software isn't great for prototyping your paint schemes.


Terms & Privacy Policy | This site is not affiliated with or sponsored by Hacker News or Y Combinator
Built by @jnnnthnn