Fork me on GitHub
#clojure-uk
<
2017-06-02
>
yogidevbear07:06:57

@dominicm, if you're still looking to do the REPL project, I'd probably suggest trying to support atom/electron too simple_smile

dominicm07:06:02

yogidevbear: how do you mean? Anything I build will be open to use anywhere. Nrepl is open that way :)

dominicm07:06:08

Perhaps tangentially, I did consider using the proto repl visualization tools. But I'm unsure.

thomas07:06:03

morning 😼 mogge

thomas08:06:13

what do people graphical user interface do people use for Databases? I use something called Squirrel at the moment...but each time I start it the fans in my laptop start spinning up.... ✈️

thomas08:06:46

and PgAdmin isn't useful either... as it seems to ignore my mouse input 😠

peterwestmacott08:06:20

I mostly just use a REPL

glenjamin08:06:53

depends on the DB

glenjamin08:06:29

i like “SequelPro” for MySQL, and “SQLPro for MSSQL” has been ok on the current project

thomas08:06:22

This is a java project 😞 and my SQL isn't fluent enough to use a repl...

thomas08:06:39

I got DBvisualizer now... that seems to do the trick.

mccraigmccraig08:06:04

what dyu get from a sql GUI over a repl ?

glenjamin08:06:40

easy exploration

maleghast08:06:39

Morning All... Re DB GUIs, if you are using postgresql and Mac, I can recommend Postico. As per @glenjamin I reckon that Sequel Pro is the best MySQL GUI on a Mac.

maleghast08:06:08

I have to admit that I try to not use them as much as possible, but there are times when a quick visual check is invaluable.

mccraigmccraig08:06:59

still not getting it - visual check of the output of describe table || \dt ?

maleghast08:06:08

@dominicm - Your REPL stuff ^^ is fascinating but daunting - I'm with @peterwestmacott, I really don't understand a LOT of that stuff nearly half well enough.

benedek08:06:15

does emacs qualify as gui? if it does than sql-mode

dominicm08:06:30

@maleghast what isn't to understand?

maleghast08:06:40

@mccraigmccraig - I hear you, but it's not the friendliest output

mccraigmccraig08:06:45

now that i can get behind @benedek 🙂

maleghast08:06:11

@dominicm - I don't have the first clue as to how various REPLs work, or how they interact with editors etc. Emacs + CIDER is a "magic box" for me. I've never spent the time to really grok it.

glenjamin08:06:16

I like REPLs, but GUIs are quicker for some tasks

dominicm08:06:25

From a UI perspective of avg user, I expect workflow like this: - Open browser → type code → see graphs Bonus will be: - Open emacs → jack-in → open browser → evaluate code in emacs → see graphs

glenjamin08:06:21

the GUI I find most useful for browsing and editing schemas, for doing queries its about the same as a good repl that has tab completion

maleghast08:06:20

@glenjamin - Yeah, particularly in development phase I find it quicker / easier to delete data, drop tables and indices etc. in a GUI too.

maleghast08:06:35

I know the commands, but click->done is low friction.

mccraigmccraig08:06:36

i tend to do all my schema editing in repl, so i can then copy/paste into a migration file... gui would mess that up

glenjamin08:06:01

i’ll often play around in the gui, then grab the SQL out of it and add into a migration file

mccraigmccraig08:06:14

ah, yeah, execution history in the gui would sort that workflow

glenjamin08:06:02

this particular gui put the SQL it had generated in the confirmation dialog when i deleted things, which was nice

glenjamin08:06:13

Sequel Pro the MySQL one had a full history feature

benedek08:06:38

nice demo gif btw @glenjamin

benedek08:06:15

yeah i am using it too

glenjamin08:06:24

on an unrelated note, does anyone else ever spell out words when using fake hashes in example tests?

glenjamin08:06:39

deadbeeffaceddeaffadeddad

peterwestmacott08:06:17

I was on the cusp of doing that yesterday

peterwestmacott08:06:56

but I just numbered them in the end

peterwestmacott09:06:05

also with REPL db access there’s no impedance mismatch when I switch from exploring the db to manipulating data with sexps

glenjamin09:06:48

until you copy-paste the data into excel tho, amirite?

peterwestmacott09:06:39

why would I ever use excel?

glenjamin09:06:25

because excel is great!

glenjamin09:06:43

visual dataflow programming system widely used throughout all industries

peterwestmacott09:06:47

sorry, was semi-trolling - but I try to avoid MS products these days

glenjamin09:06:58

I do mostly use google sheets for spreadsheety things these days, not that Google is much better than MS anymore

thomas09:06:23

@mccraigmccraig I just want to click in this case and press cmd-r to refresh. and yes a repl could do that as well.

otfrom10:06:24

at least both can be scripted with clojurescript. Excel can be scripted with clojure too

otfrom10:06:31

(well .net clojure)