Accessing MySql From SBCL

Bycoliveira

This weekend I spent some time to test clsql on sbcl. I tried to do this before on Windows, but I couldn’t get it to work. So I used my trusted Amazon ec2 linux machine to do the job.

Initially, I had to use yum to install sbcl. It is as simple as

yum install sbcl

and watch the packages being downloaded. I also needed to install gcc and mysql-devel (this depends on the distribution).

yum install gcc
yum install mysql-devel

Then, I used asdf to install the required packages, including clsql. These are some of the commands I used:

(require :asdf)
(require :asdf-install)
(asdf-install:install :uffi)
(asdf-install:install :clsql)

There was a lot of complaining from asdf-install, especially related to a missing gpg library. Also, most backends other than mysql failed to compile, which is ok, and I just ignored it selecting one of the options given by the debugger.

Once installed, you can use clsql to make calls to mysql. I created a simple database called carlosdb with the commands (typed on mysql prompt):

create database carlosdb;
use carlosdb;
create table users (
     `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
     `name` VARCHAR(100) NOT NULL);

Then, we can use clsql in the following way:

(require :asdf)
(asdf:operate 'asdf:load-op 'clsql)
(use-package :clsql-user)
(connect `("" "carlosdb" "" "") :database-type :mysql)
(execute-command "use carlosdb");
(query "select * from users")

The two results of the last operation are lists like the following:

((1 "john nash") (2 "james jim") (3 "jon williams"))
("id" "name")

where the first list is composed of sublists, each have as elements the contents of a record. The second list just stores the names of the fields (id and name, in this case).

Some Helpful Resources

Similar Posts:

Similar Posts

How to measure productivity for developers?

Bycoliveira

One of the big concerns of companies that employ software engineers has been how to measure the productivity of these people. From a business standpoint, the idea is that one should find ways to maximize the work done by their employees. However, it is difficult to evaluate how this maximization process would happen if no…

Day 1: Read Other People’s Code

Bycoliveira

This is day one of our series on how to become a better developer in 30 days. During this series, I will discuss during one month 30 ways for anyone to become a better developer. Today, I would like to talk about something that few people do voluntarily: reading other peoples code. Writing good code…

Two Ways in Which Java Didn’t Get It

Bycoliveira

While Java is a very practical language, used nowadays to implement a large array of software applications, it also has its own share of problems. I am not the first and won’t be the last person to touch on the many issues raised by its design, especially in the areas of syntax and support for…

Tips to Read Other People’s Code

Bycoliveira

Reading code is a basic skill that working programmers need to acquire in order to work on development teams. It is really hard to expect that you will work in isolation of other people’s code. Therefore, reading code is a skill that can make you much more productive. Although it not easy to learn this…

10 Comments

  1. Wir haben hier einige neue Anbieter für dich gefunden, die einen No Deposit Bonus anbieten. Der Nachteil ist
    allerdings, dass der Titel, für den die Freispiele
    gelten, vom Online Casino ausgewählt wird. Je nachdem handelt es sich um Bonusguthaben oder Freispiele.
    Es gibt verschiedene Bonusarten, die man im Casino ohne Einzahlung
    erhalten kann. Für das Online Casino ist der Bonus ohne Einzahlung eine der vielen Marketing-Optionen, mit denen man versucht, neue Kunden zu gewinnen. Dabei
    kann es sich entweder um Freispiele bei Registrierung ohne Einzahlung oder um Bonusguthaben handeln.
    Live Casino Spiele bieten eine einzigartige und immersive
    Erfahrung in Online Casinos. Die besten Online Casino Plattformen in Deutschland bieten eine Reihe von attraktiven Angeboten und Promotionen. Online Casinos
    in Deutschland bieten Ressourcen für verantwortungsvolles Spielen an. Casinos mit den besten Online Casino Auszahlungsquoten bieten in der Regel eine höhere Rückzahlung an die Spieler.

    References:
    https://online-spielhallen.de/casino-bonus-ohne-einzahlung-2025-gratis-no-deposit-boni/

  2. Jede Transaktion ist durch 256-Bit-SSL-Verschlüsselung geschützt, das gleiche
    Sicherheitsniveau, das von deutschen Banken verwendet wird.
    Wir haben mit führenden deutschen Zahlungsanbietern zusammengearbeitet,
    um vielfältige Ein- und Auszahlungsoptionen anzubieten. Während
    Sie Ihre Lieblingsspiele spielen, sammeln Sie automatisch Crown-Punkte,
    die Sie durch unser Stufensystem aufsteigen lassen. Es ist perfekt für Spieler, die Sportwetten genießen, aber schnellere Ergebnisse und ständige Verfügbarkeit wünschen.
    Unter „Casino“ befinden sich die Spieleautomaten, Tischspiele und auch schnelle Spiele.
    Allen voran der attraktive Willkommensbonus hat für einen sehr guten Start und beste CrownPlay Erfahrungen meinerseits gesorgt!
    Nutzer erhalten mobil denselben Funktionsumfang wie am Desktop – inklusive Ein- und Auszahlungen sowie Spielezugriff.
    Die Plattform überzeugt mit einer breiten Auswahl an Spielen, darunter
    moderne Video-Slots, klassische Tischspiele, Live-Casino-Titel
    sowie temporeiche Crash-Games.

    References:
    https://online-spielhallen.de/stake-casino-deutschland-online-crypto-casino/

  3. Register today, claim your bonus, and level up your gaming experience — where every
    spin brings you closer to a win! It delivers push
    notifications, optimized performance, and instant access to the casino —
    perfect for gaming on the go. The platform uses SSL encryption to protect personal
    data and payments, providing a completely secure gaming
    environment. LevelUp Casino is a fully licensed online casino,
    operating under international gaming regulations to ensure
    fairness and transparency.
    LevelUp Casino is fully optimized for mobile devices, allowing you to enjoy your favourite games anytime, anywhere.

    The minimum deposit amount is generally AU$10, making it accessible
    for a wide range of players. You can chat with the dealer and other players,
    watch every move, and feel just like you’re sitting at a real
    gaming table. For those who prefer a more intellectual and strategic approach to gaming, Level
    Up Casino offers a superb selection of table games. LevelUp Casino rolls
    out the red carpet for new Australian players with a
    fantastic Welcome Package spread across your first four deposits, offering
    up to AU$8000 + 200 Free Spins.
    From lucrative welcome bonuses to ongoing promotions, the casino ensures that
    its customers are rewarded at every turn. Discover the excitement of LevelUp
    Casino, Australia’s premier online gaming destination. The average withdrawal time from the Level Up Casino platform is between one and five hours.

    Have a question about a bonus, have an issue with a deposit or just want to talk
    about the newest pokies? • a photo of a valid identity card;• a
    screenshot of an electronic wallet or a statement from a bank account (in the case of
    deposits in cryptocurrency, this is not required).

    References:
    https://blackcoin.co/minimum-deposit-casino-sites-with-payid/

  4. Enter your registered email and password to access your account.

    With over 1,600 pokies onsite and more than 2,000 online slots,
    The Star Gold Coast is a paradise for reel lovers.
    Plus, with seamless payments (cards, e-wallets, Interac, crypto), you’re always ready to play.

    Players seeking a more intimate or high-stakes experience can access our High Limit Room, featuring premium service and elevated betting thresholds.
    Slots range from low-denomination classics to the newest
    themed video pokies with multi-reel mechanics, bonus rounds,
    and progressive jackpots. With over 1,600 slot machines and 80+
    table games, our casino floor is one of the most vibrant and
    expansive in Australia.
    Alternatively, sign into the Google website and click Gmail to access Gmail from login. If you have a
    Google account, you can access Gmail from login easily.

    Do you need to sign into your Gmail account? Rain shares
    a lifelong passion for writing and gaming and is eager to grow alongside new tech inventions.

  5. You need more ability and strategy to play table games
    than to play slot machines. These games range from classic designs to modern video slots with various
    themes and bonus features. New, fun games are added to this huge library of
    games all the time so that both new and expert gamers
    can enjoy them. Being in the casino gets better as you spend
    more time and money there.
    When you sign up at Stay Casino, you’re in for weekly bonuses, a welcome package, one-time bonuses,
    and loyalty prizes. Enter your bonus code before depositing to unlock rewards like free
    spins, cashback, or reload bonuses. You may log in to your
    account from anywhere, at any time, because the page is mobile-friendly.
    This online casino is made up of people who want to make gamers happy and help them develop
    better. Casino is a new and imaginative online gaming site that is attracting
    both new and experienced gamers.
    The service prioritises urgent queries from AU clients, connecting you directly with friendly support managers who understand local gaming requirements.

    Our progressive jackpots include network-linked games where prize pools grow
    across multiple casinos. Our progressive jackpot
    slots offer life-changing prizes alongside high RTP options for Australian players.
    Stay Casino delivers over 6,000 pokies from premium developers like Pragmatic Play, NetEnt,
    and Microgaming.

    References:
    https://blackcoin.co/no-deposit-free-spins-bonuses-2025/

  6. Expect generous bonuses and promotions designed to enhance your real money gaming journey.
    It is a top choice for real money pokies and diverse game options, including live dealers.
    Casinonic delivers one of the highest payout percentages and
    an excellent range of real money games.
    Ricky Casino’s gaming library is filled with 3,000+ exclusive titles.
    Yes, you can find several types of cryptocurrencies to make deposits and
    withdrawals. The most high-prestige gambling licenses are
    those issued by the Alderney Gambling Control Commission, UK Gambling Commission, Malta Gaming Authority, and others.
    A licensed gambling site in Australia is guaranteed to provide world-class
    service. Speaking about secure system you should pay attention on the gambling license.
    On another hand, it is a kind of practice and improving gaming skills.

    References:
    https://blackcoin.co/vip-casinos-in-canada-2022/

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.