Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Murphy Randle
    @mrmurphy
    and. usually if there's a sql error an error will be thrown
    Gregg Hernandez
    @gregghz
    right, you should get exceptions from the driver
    Murphy Randle
    @mrmurphy
    does Relate do any kind of query manipulation?
    or is this for sure the raw query that gets sent to the server?
    Gregg Hernandez
    @gregghz
    it does not. It’s pretty pure in terms of not messing with writes like this (it sometimes tries to be smart about reading data)
    Murphy Randle
    @mrmurphy
    I wish I could somehow debug the query and have it print out what the interpolation values will be as well
    :+1:
    Gregg Hernandez
    @gregghz
    yeah, that’s something I’ve wanted in the past too.
    Murphy Randle
    @mrmurphy
    if I copy the query into my client and paste, then write in the key by hand the delete always works as expected
    Gregg Hernandez
    @gregghz
    you could probably get logs from postgres though
    Murphy Randle
    @mrmurphy
    oh good idea
    Gregg Hernandez
    @gregghz
    it would be interesting to see what query is actually running
    you could also write the query using jdbc directly to see if you get the same issue
    if it works with raw jdbc, that points to a relate bug. If it is also sketchy with jdbc then that points to a driver bug
    fwiw, we never really tested relate a lot with postgres. I don’t work at Lucid anymore, but when I was there, a very small subset of sql was written against some redshift stuff (which is approximately Postgres)
    Murphy Randle
    @mrmurphy
    oh good to know!
    seems like it'd be pretty equal, if it's just passing SQL through to the JDBC driver, right?
    Gregg Hernandez
    @gregghz
    yeah, any issues like this actually still point to the jdbc driver. Amazon provides a unique one for redshift, it’s not the mainline postgres driver
    there are a couple places in relate that assume mysql, unfortunately. But they are pretty rare. I can’t remember the specifics but it was all for reads. I’ve never seen db implementation issues like this related to writes.
    Murphy Randle
    @mrmurphy
    D'OH
    Logs
    are very helpful
    I think my application layer is deleting and then re-inserting
    Gregg Hernandez
    @gregghz
    that’s good news for me :) it means I didn’t write broken code ;)
    Murphy Randle
    @mrmurphy
    Haha :D
    Thanks for the code, BTW @gregghz
    We're Utah neighbors to Lucid
    Gregg Hernandez
    @gregghz
    haha, don’t thank me too much, @pauldraper and @msiebert also did a ton. Incidentally they’re both no longer at Lucid either :D
    Murphy Randle
    @mrmurphy
    and have friends over there, so it feels good to be using a lucid thing
    well that's just how things go!
    Gregg Hernandez
    @gregghz
    where are you working?
    splode?
    pretty cool that you’re using scala. It seems like it’s gaining a bit of a following in Utah.
    Murphy Randle
    @mrmurphy
    Working at https://dayoneapp.com actually!
    I inherited a Scala codebase
    and I'm not used to the Java ecosystem at all
    but I am enjoying most of the language :D
    Gregg Hernandez
    @gregghz
    haha welcome. It’s a weird confusing and sometimes exciting world :smile:
    Paul Draper
    @pauldraper

    @pauldraper and @msiebert also did a ton. Incidentally they’re both no longer at Lucid either

    Don't forget @matthew-lucidchart .... who is also no longer at Lucid ;)

    Gregg Hernandez
    @gregghz
    Thayne merged a PR in march and Sriraam has some older commits. There’s still hope :D
    kabir idris
    @_binkabir_twitter
    Hi everyone
    just playing around with relate and I like it.
    I have one quick question. having define an implicit Connection object to my queries do I have to explicitly close the connection at the end of my queries ????
    thanks.
    Thayne McCombs
    @tmccombs
    I don't believe relate does any connection management. However, you can use another library, such as scala-arm or scala.util.Using in 2.13, to automatically close the connection when you are done with it. At lucid we also use hikari-cp for connection pooling.
    kabir idris
    @_binkabir_twitter
    ok
    thanks
    scala-arm actually look awesome.
    James Judd
    @jjudd
    scala-arm is most excellent. Highly recommended. Looking forward to 2.13 when we won't need it, but in the meantime it is nice.
    kabir idris
    @_binkabir_twitter
    interesting....what is new in 2.13 ???