u/drewc

Seconded. Gerbil is my favourite on all platforms and I worked hard on making it Mac friendly.

That's a strange one! Can you go to https://github.com/mighty-gerbils/gerbil/issues and post an issue outlining this with slightly more detail? What platform, C compiler, libc version etc.

I've got an i5 with that amount of RAM so can try to narrow it down. Ideally, fresh checkout to /tmp, make sure ~/.gerbil is non-existent , and we'll go from there.

Cheers!

That's not how ORDER BY works.

I'm not sure what you want to do but a quick c/p to put things in the correct place I think. Untested.

SELECT
CASE WHEN col1=2 THEN 0
WHEN col1=1 THEN 1
WHEN col1=4 THEN 2
WHEN col1=3 THEN 3
END AS odrby,
*
FROM table ORDER BY odrby, col2 ASC ;

Try here for more info

What have you covered in green paint? From a brief look you are trying a shell command inside psql? That's incorrect.

My first live-aboard was a 29' sloop. I lived on her with my Girlfriend, her daughter, three ferrets and a lovebird. We had a full quarter-berth free for storage, and could have stashed 9 months worth of goods to survive.

But, at the same time, it was a monohull. Yet, we were landlubbers. I could almost do the same packing job on my Cal-20, though 9 months would be a stretch and no ferrets, birds or kids :).

On my 45' cutter I could store a few years worth really. But, that may be because I'm a sailor now and, after more than a decade living onboard sailing vessels I know how to use space :D.

But, they were all monohulls. I do know how much interior space a catamaran is lacking, and how much extra a slip costs for one, so tend to stay away from such things :P

Most people who own boats do not live on them.

You do not need one no matter what they way. From experience.

Wait till I tell you what your momma told me!

I don't think a fast picture of the top of a shack counts as a houseboat. :)

Us stoners know our schools :)

I'm not sure what you are asking for, so I'll simply close with: Ask your father, or Karen.

Onterrible ... Ryerson?

I'm not at all sure why you are asking or what the relevance is to my recommendation.

Can recommend Doom.

I am willing to bet your text book explains it. If you are not reading a simple SQL text book, try that!

Rule #1: NO YELLING!

NO YELLING!

Downvoted? lol :)

Why do you turn off added privacy and encryption when using private encrypted services?

It is encrypted before it ever leaves your computer. Doing it publicly leaves logs IE: Your internet service provider (and hackers who have busted into their system which is easy) has a log of every single IP you visit.

A VPN logs 1 ip. Without it, everything is logged. The hacker knows when you are at home.

If you do not think your VPN is safe, use another VPN :)

From a brief glance, if they are including batteries it's a total rip off and stay clear. Otherwise do some research and make sure. Surplus for marine solar makes little sense given how reasonably priced and more efficient brand new panels and controllers are.

Are they a marine surplus joint? If not, throw away all the wire and prepare for survey and insurance woes. Marine cable is stranded. and solid copper wire that last for 100 +years on land is good for about a year onboard.

You learn about batteries quickly. Lived aboard in the Salish Sea for 12 years now. Rebuilding my bank using lifepo4's now where 1 kWh cost around $15,000 and is very very worth it.

"Plug and Play" on a boat is never a good idea. You need to repair and fix holes, not plug them. You keep water outside the boat, don't let it in.

Yes, adding "Marine" to something adds 10x to the price. Welcome to the club :)

Awesome! Personally I've been using Gambit Scheme + Gerbil Scheme for the last few years which has a JS compiler. That's become my preference simply because I am used to that language and the javascript backend is quite good.

Can you tell me details of your lips interpreter versus other JS schemes like, say, BiwaScheme? Is there anything that goes above and beyond another scheme compiled to Web Assembly like, say, Chibi-Scheme and https://emscripten.org/?

Here's my go-to: https://feeley.github.io/gambit-in-the-browser/ . This is Gambit's 31st year (did it start off in PROLOG lol?) so though it may not be based off of an implementation bootstrapped from ECMAScript, well, JS was originally written in Common Lisp and meant to be a scheme-like language... so you can claim a big bootstrap from ANSI CL!

:D

He's got our cap, and '86 was a long time ago. No matter what we'll be playing in he 2026 World Cup. If this continues, well, 8 years from now I'll tell you whose name will be printed on the back of my red kit!

Allez Allez Les Rouge Allez!!

As far as I know, Sharpsign Equal-Sign and Sharpsign Sharpsign are not a part of Scheme syntax. I may be wrong, so if you could point me to where such a thing is documented and specified, that may help :)... or re-reading, that is what you are asking for? Dammit lol ... I know of no such thing.

Beyond that, Sharpsign Equal-Sign is, in CL, a reader. Not a run time syntactic abstraction, not a syntax object, but a specified reader macro based off a dispatching macro character.

Such things do not exist in Scheme. Implementations differ, of course, but there is not, yet, a "Common Scheme" because we don't work that way any more, and "Common Lisp" actually did include major influences from Scheme (which is a lisp that became common ... lexical anyone?) but at the same time is very very very different from Scheme and RnRS's and SRFI's.

SRFI's are, somewhat, A Common Scheme. If you want a circular list, try SRFI 1.
https://srfi.schemers.org/srfi-1/srfi-1.html#circular-list

This is Gerbil Scheme, which compiles to Gambit:

> (circular-list 1 2 3)
#0=(1 2 3 . #0#)

But, hey, what is that it returns? http://www.iro.umontreal.ca/~gambit/doc/gambit.html#Lexical-syntax-and-readtables

It's a reader macro, just like CL! Note that there is no cons in the reader macro. It's not a run-time thing, there is no cons needed.
Which of course means that this works.

> (begin
   #1=(define (fn x) (+ x x))
   (define code '#1#))
> code
(define (fn x) (+ x x))

Notice the quote before the '#1#? That's somewhat important. What happens if I type a circular expression at the REPL?

> #0=(1 2 3 . #0#)
OOM ERROR: NO FREE SPACE

I added the OOM error message myself, my OS just kept filling until I hit C-z :)

That's not a bug with the implementation whatsoever, it's just doing exactly what I said to do. It could possibly be fixed by checking every read, eval, and print at all times... and even then only work part of the time. There are only so many atoms in this universe.

There are Quantum Computers programmed in a CL variant! Try them :).

What is wrong, to you, with this subreddit?

One of the things about PostgreSQL, and software development in general is: Read the documentation.

Even if it's shitty, it may have the information you are looking for. If it doesn't, well, you've read the entire documentation and know why it doesn't.

PG has really really good docs. Been a professional PostgreSQL developer and administrator for about 2 decades now :)