freenode/#lisp - IRC Chatlog
Search
15:22:55
fivo
I pushed some path into asdf:*central-registry* and did an asdf:load-system then started with a new image again.
15:23:33
fivo
Now asdf still tries to load the system from that path even though asdf:*central-registry* only contains the quicklisp path.
16:06:15
dim
phoe: I also have a list of new features to add to pgloader, as per https://pgloader.io/roadmap/ ; one of the things I'd like to work on someday is an ABCL release were we would only use JDBC rather than specific database driver APIs as we do now, it would also help solving some issues with SSL and things
16:07:13
dim
I mean the ASDF dependency list would be different when using ABCL, because to be fair some of them are included in the JVM already, so we would just use them rather than load even pure-CL code (such as Postmodern), or some external libs (such as SQLite)
16:08:24
dim
the only reason why I avoided a fundraiser up to now is that I don't want people to invest their own personal money into this project, it's an enterprise thing, nobody would use that in their free time, I guess
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