programming_languages.sql

programming_languages.sql

/* Programming languages
  Collected by: https://www.khanacademy.org/profile/trekcelt/programs
 */
CREATE TABLE languages(
    id INTEGER PRIMARY KEY,
    name TEXT,
    primary_developer TEXT,
    launched INTEGER,
    oop INTEGER /* Whether or not they're Object-oriented */
);

INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Squirrel", "Alberto Demichelis", 2003, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("SQL", "Donald D. Chamberlin", 1974, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Rust", "Graydon Hoare", 2010, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Eiffel", "Bertrand Meyer", 1986, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Scheme", "Guy Steele", 1975, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Prolog", "Alain Colmerauer", 1972, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("SPARK", "Altran Core", 2004, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("R", "Ross Ihaka", 1993, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Genie", "Jamie McCracken", 2008, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Ada", "Jean Ichbiah", 1980, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("CoffeeScript", "Jeremy Ashkenas", 2009, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Self", "David Ungar", 1987, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Falcon", "Giancarlo Niccolai", 2003, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Scala", "Martin Odersky", 2003, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Snap!", "Jens Mönig", 2011, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("PHP", "Rasmus Lerdorf", 1995, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Pascal", "Niklaus Wirth", 1970, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Erlang", "Joe Armstrong", 1986, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("UnrealScript", "Tim Sweeney", 1998, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Dart", "Lars Bak", 2013, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("VBScript", "Alan Cooper", 1996, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("AWK", "Alfred Aho", 1977, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Ruby", "Yukihiro Matsumoto", 1995, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("TypeScript", "Anders Hejlsberg", 2012, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Io", "Steve Dekorte", 2002, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Tcl", "John Ousterhout", 1988, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("SmallBasic", "Microsoft", 2011, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Perl", "Larry Wall", 1987, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Common Lisp", "Scott Fahlman", 1984, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("SmallTalk", "Alan Kay", 1972, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("JavaScript", "Brendan Eich", 1995, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Fortran", "John Backus", 1900, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Python", "Guido van Rossum", 1990, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("C++", "Bjarne Stroustrup", 1983, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("C", "Dennis Ritchie", 1972, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("C#", "Anders Hejlsberg", 2000, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Java", "James Gosling", 1995, 1);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("QB64", "Galleon", 2007, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("Post-Script", "John Warnock", 1982, 0);
INSERT INTO languages (name, primary_developer, launched, oop)
VALUES ("COBOL", "Howard Bromberg", 1959, 1);