freenode/#lisp - IRC Chatlog
Search
19:18:27
defunkydrummer
@dim and decided to log in. I think PGLOADER is perhaps one of the hottest current tools written in CL right now, considering that Postgres is *THE* database.
19:19:13
defunkydrummer
dim: perhaps you should ask for people to collaborate on reddit/r/lisp. I didn't know you needed help with PGLOADER. If i had the spare time, I would.
19:24:22
defunkydrummer
dim: Question: Why does pgsql uses '(mssql sql) systems instead of using databases other than Postgres through CLSQL, which is already integrated with a lot of RDBMS including those two (and ODBC). (Of course, it doesn't have bulk copy operations...).
19:25:34
defunkydrummer
PuercoPop Oi Puercopop, entering IRC from an internet backdoor at *current-company*
19:29:00
defunkydrummer
@dim you wrote: "one of the things I'd like to work on someday is an ABCL release" -- however, it's likely that 95% of Pgloader users don't care (or know) what the underlying Lisp implementation is, and would rather simply download pgloader binary and run it. Mind you, i say this as a HUGE fan of the Right of Arming Bears and of Armed Bear Common L
19:30:13
defunkydrummer
sorry, my 2 cents. I'll keep more quiet now. Again, thank you so much for rewriting Pgloader, now with 100% less Python.
19:52:32
dim
defunkydrummer: I didn't like CLSQL when I had a look the first time, and wanted to have pure-CL drivers when possible, with a map like API to ensure that you don't have to load the whole SELECT result set in memory but instead can work in a streaming fashion
19:53:28
dim
defunkydrummer: ABCL would allow using JDBC, meaning pure-Java drivers for any and every source database system out there, from MS Access to IBM DB2 on OS/390; so that'd be quite a monivation for me and for some users too
19:53:46
dim
and other than that, thanks defunkydrummer for the kind words too, I feel humbled today!
19:54:38
defunkydrummer
@dim thank you for the tool. In fact here i'm steering the team towards moving to PostgreSQL, however we do have a strong need for SQL Server, and I use clsqlODBC
19:54:56
dim
fe[nl]ix: I tried to make it so that pgloader would be usable as a lib, but I'm not sure about it really, I don't have a use-case for that... well the command language parser produces lisp code, so... I kind of have a client
19:55:14
defunkydrummer
clsql+odbc to interface lisp with MSSQL . I didn't know pgloader could connect to mssql server. Today I Learned.
19:56:08
dim
in pgloader we use FreeTDS and a CFFI wrapper around it, it's not the best possible trade-off either, it kind of works usually, and FreeTDS looks well maintained
19:56:37
defunkydrummer
dim: yes, but i can access any and every source database system out there (pun intended). I don't remember what the cslql-odbc driver uses, but it works reliably, no complaints so far. What I need is bulk inserts.
19:57:10
dim
of course if a pure CL driver did exist I would use that, having to fiddle with .so or .dll things is not nice in CL when you ship a binary to end-users who know nothing about CL in general and setting up their .so loader in particular
19:58:54
dim
maybe I should have a look at clsql-odbc for perfs and memory usage characteristics someday, also I would accept contributions that would add support for such a driver in pgloader, maybe using a new source URI (e.g. odbc:mysql://user@host:port/db)
20:08:17
defunkydrummer
dim: having to use .dll files isn't so bad if you can legally bundle them with your system or if you know where to locate them beforehand.
20:11:51
dim
yeah well, debian and Postgres YUM packagers are doing a good job at that, other than that I know nothing about the system where pgloader is going to be invoked
20:12:17
dim
shipping a /usr/bin/pgloader application from a CL build system sometimes feels like being a pioneer, or maybe doing it wrong
20:27:35
defunkydrummer
i understand! Anyways, i need to log out and (invoke-restart #'perform-work)
20:37:04
p_l
dim: an idea that's been following me everytime I see pgloader is of turning it into general (if mostly simple) ETL tool
20:39:43
dim
yeah it's kind of a specialized ETL already, but going generic would turn it into a very different beast, I'm not sure I want to go there. I've done lots of ETL or ELT work in the past, and always with on-purpose tooling hacked around specific needs, never with “general purpose ELT solutions”, I don't believe in those
20:59:01
p_l
dim: well, the only non - general thing from my usage is that pgloader only supports postgres as target
1:04:09
White_Flame
In LOOP, I want a value calculated every iteration, via something like FOR or WITH, so that UNTIL can see it. What's the appropriate keyword to use there?
2:12:37
madmuppet006
I am trying to write a mandelbrot set program .. I can create an image but the image is incorrect .. I have tried reversing list of numbers but still get the same image .. can anyone have a quick look? thanks https://pastebin.com/r0mEgvVq