how to sql

how to sql

sqlite3 prog.db "select * from posts where body like '%Xarn%';"

>>1
Very gingerly.

http://img192.imageshack.us/img192/3618/sql.png

what now

please it's imperative

what am i doing oh god

i am 12 and what is this

please it's functional

SELECT YourMom FROM MyAnus WHERE NiggerNiggerNigger

http://en.wikipedia.org/wiki/SQL
Typing discipline: Static

any questions?

It's actually quite interesting, that SQL, the language based on declarative paradigm could gain popularity. It's different from imperative or object oriented, but people liked it. Now take a look at functional programing, it's also different, but people are mostly afraid of it. It's also interesting, that Prolog, the langage, that also based on this didin't gain popularity and failed into oblivion. Is this only about people mindset? Can non-mainstream paradigms gain popularity? Do we need new ones or should we study existing paradigms and focus on theirs similarities?

>>11
Aspect-oriented paradigm is non-mainstream but appears to be gaining a foothold...

>>11
Wut? SQL isn't a language. Just a few functions for storing and retrieving data. No more declarative than your `map` and `fold`.

>>12 you right
>>13 Yes, it's (specialized) language, it's declarative because you don't create algorithm, that retrieves data, you just indicate, what conditions data must fulfill if it will to extracted.

>>11
Why do you care so much about popularity? Just be happy if a language has good enough implementations and that they are well-maintained and documented.

>>14
I indicate at my `reduce` function with `from-end` and `intial-value` keywords. Lisp is fucking declartive!

>>16

(im-an-faggot
 select car as x
        from '(1 2 3)
 select caar as key
        cdar as value
        from '((x . 1) (y . 2) (z . 3) (w . 4) (a . 5) (b . 6))
        where (even? value)
 mapping (cons key (+ value x)))

guys now i have more trouble

i got the database working but now how do i get this to work


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CSharp_SQL
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cs = new SqlConnection("Data Source=TEMP-3E4F550D63\\SQLEXPRESS");
            cs.Open();
        }
    }
}

>>18

it throws an exception saying the login failed

don't worry guys i got it

and now i'm using sql injection on my own database it's pretty tight

>>13

Functional programming *is* declarative. Also: http://maxgontar-code.blogspot.com/2010/01/fun-with-sql-games-painting-puzzles.html for some examples of SQL usage beyond just SELECT * from mylittletable.