jbcaprell

I think many of the sorts of people who frequent r/webdev are familiar with Josh W Comeau and his CSS for JavaScript Developers course, which exists for me as more-or-less the gold standard of online courses for web developers.

Does anything remotely similar exist for Figma? I feel like a couple of the Piccalilli courses are almost there, but I think I have the mechanics more in mind here, where both of those courses feel more about the soft skills of communicating around-about design than about actually using Figma.

This post contains content not supported on old Reddit. Click here to view the full post

The book contains, amongst others, chapters focused on justice in the Hebrew Bible as well as the New Testament, and I was curious if anyone here had read it before and had thoughts or comments!

I actually don’t think we would have watched it but for its setting being local to us,but my wife popped it on the other day on a lark and it had the best first episode I’d seen in a crime drama since, at least, Broadchurch.

I would like to write as descriptive an error as possible when raising an exception to attempts to change the value of a given column after initial insertion. The best I have been able to come up with is:

CREATE OR REPLACE FUNCTION invalidate_change() RETURNS TRIGGER AS $$
    BEGIN
        IF NEW <> OLD THEN
        RAISE EXCEPTION 'value in column % of relation % cannot be updated',
            TG_ARGV[0],
            TG_TABLE_NAME;
        END IF;
    END;
$$ LANGUAGE plpgsql;

CREATE TABLE IF NOT EXISTS foo (
    bar text
);

CREATE TRIGGER foo_bar_invalidate_change
    BEFORE UPDATE OF bar ON foo
    FOR EACH ROW

I have two tables, "Contacts" and "Groups." Each has a field, "ID," which serves as a record’s primary key, and a field "Name," which serves as a human-readable name for that record.

The two tables have a many-to-many relationship with one another, through the join table "Memberships." The join table has two fields, "Contact ID" and "Group ID," foreign keys pointing to their respective IDs in the Contacts and Groups tables.

I have created a Layout based upon Contacts with three objects: an edit box for ::Name, a portal to the table Groups, and an edit box for Groups::Name nested within that portal.

I have created two records in Contacts, with the name "John Smith" and "Jane Smith," res