Beta

Slashdot: News for Nerds

×

Welcome to the Slashdot Beta site -- learn more here. Use the link in the footer or click here to return to the Classic version of Slashdot.

Thank you!

Before you choose to head back to the Classic look of the site, we'd appreciate it if you share your thoughts on the Beta; your feedback is what drives our ongoing development.

Beta is different and we value you taking the time to try it out. Please take a look at the changes we've made in Beta and  learn more about it. Thanks for reading, and for making the site better!

SQL on Rails Launched

CowboyNeal posted more than 8 years ago | from the web-three-point-oh dept.

117

Daniel writes "Developers have created a new Rails framework for SQL, SQL on Rails. Check out the screen cast that shows you how to develop an internet search engine with three lines of code. Version 4.1 of the SQL on Rails framework is available for download on the site, and the O'Reilly title is expected to hit shelves next month." ZOMG L@@K at the kitten site it powers!@#!11

cancel ×

117 comments

really insightful (4, Informative)

Zugot (17501) | more than 8 years ago | (#15042390)

this has to be one of the best put together april fools jokes i have seen in a long time. i'm impressed.

It was (1)

technoextreme (885694) | more than 8 years ago | (#15042424)

this has to be one of the best put together april fools jokes i have seen in a long time. i'm impressed.
It was until their sever was slashdoted.

Re:It was (2, Funny)

whoop (194) | more than 8 years ago | (#15042445)

'Tis sad that we must wait until April 2 to be fooled.

Ponies ruul!!

Re:really insightful (1)

choongiri (840652) | more than 8 years ago | (#15043118)

Firefox can't find the server at www2.sqlonrails.orgscreencast.
OMFG!!! like, i mean, LIKE even PONIES know to put the trailing slash at the end of their apache redirects when getting /.ed!!! n000bi3s!!!!LOL!

Shut The Fuck Up (-1, Troll)

Anonymous Coward | more than 8 years ago | (#15042392)

All of you

I wouldn't have thought, but... (4, Funny)

msmercenary (837876) | more than 8 years ago | (#15042394)

... there are days when it's actually a good thing to be among the 6% of males that are color-blind. Today is one such day.

Re:I wouldn't have thought, but... (1)

billster0808 (739783) | more than 8 years ago | (#15042418)

I'd say any day you come to /. is a good day to be color blind.

Re:I wouldn't have thought, but... (1)

Zedrick (764028) | more than 8 years ago | (#15043163)

Most of us (6%) are Red-green color blind. Unfortunately that doesn't prevent us from seeing pink (or red/green - Red-green color blindness doesn't really matter in real life. And yes, I can see both Red and Green despite the so-called Red-green color blindness).

It's getting old (-1, Troll)

EnronHaliburton2004 (815366) | more than 8 years ago | (#15042395)

April fools gets old after the first joke.

IT'S GETTING TIIIIRED!

Re:It's getting old (1)

Xichekolas (908635) | more than 8 years ago | (#15042423)

Blasphemy! You are in time out Mister! Go sit in the corner and think about what you've done! I for one welcome our Pink Pony Overlords...

Re:It's getting old (1)

ejdmoo (193585) | more than 8 years ago | (#15042433)

It's tradition!

Fix (0)

Anonymous Coward | more than 8 years ago | (#15042396)

Fix the second link

Re:Fix (1)

mrshoe (697123) | more than 8 years ago | (#15042481)

The screencast link in the story doesn't work, but if you follow the first link to sqlonrails.org, then click the screencast link, you can get to the screencast.

Pi nk Test (0)

Anonymous Coward | more than 8 years ago | (#15042398)

Testing the pink.

Who else thinks... (1)

Red Samurai (893134) | more than 8 years ago | (#15042400)

This is going a bit TOO far now? It's not even funny anymore.

Re:Who else thinks... (1)

toriver (11308) | more than 8 years ago | (#15042781)

This is Slashdot in normal mode: Now they are linking to other sites' stories (as they usually do), except the stories are April Fool's articles.

(Personally I am waiting for QBasic on Rails.)

Yes, but... (1)

smudge8 (812705) | more than 8 years ago | (#15042401)

Damn it, I can't think of anything funny to say. I'm all April Fools'ed out.

Re:Yes, but... (1)

ScytheBlade1 (772156) | more than 8 years ago | (#15042439)

You think this year is bad?

You ought to take a look at last years [slashdot.org] April Fools. (Note the page length, number of stores, and content [slashdot.org] , or lack thereof.)


We haven't seen ANYTHING yet.

Re:Yes, but... (1)

idonthack (883680) | more than 8 years ago | (#15042544)

Rotors: S L A
Stecker-board: SH DO TX
stcfi lvbpr ypupz keful kcjds vfkjb dvmar rgopd johax lwzzm eoddu ztcqk

Re:Yes, but... (2, Funny)

vdboor (827057) | more than 8 years ago | (#15042882)

The download even has a Makefile and configure. :-)

From the INSTALL documentation in the download:

You don't need to be root because the SQL On Rails installer will just use the appropriate priviledge escalation method for your OS version.

ghehe..

Ahh what's with the link? (0)

Anonymous Coward | more than 8 years ago | (#15042409)

It's like a phantom broken link, it looks fine, but when I click on it it's broken!!!

Awesome, but can it run on an Intel Mac? (4, Funny)

Kelson (129150) | more than 8 years ago | (#15042410)

I've been trying to set up a new web server running in a VMWare instance of Fedora Core 5 on Windows XP Home booting on an Intel Mac. Anyone know if SQL on Rails is compatible with this setup?

Re:Awesome, but can it run on an Intel Mac? (1)

Geoffreyerffoeg (729040) | more than 8 years ago | (#15042470)

I've been trying to set up a new web server running in a VMWare instance of Fedora Core 5 on Windows XP Home booting on an Intel Mac. Anyone know if SQL on Rails is compatible with this setup?

Yes. Actually, it's good that you have all this, 'cause SQL on Rails, according to the screencast, only runs on OS X PPC. Now Rosetta has only been out for a couple of months, and it's non-Free, so we can't be sure it works. Within your FC5 on VMWare, launch PearPC (which is thankfully OSS) and get it to run OS X PPC. Then Rails should install immediately. And because you're running on an Intel, you'll probably get more performance than a real PPC would give you - that's why Apple switched.

Re:Awesome, but can it run on an Intel Mac? (0)

Anonymous Coward | more than 8 years ago | (#15042500)

What you actually want is PoniesOnRails.

They are much more efficient than plain Ponies, as robust as a locomotive, faster than a speeding bullet, and don't wear underwear outside of their pants.

They also don't attract bumsexuals, which is a bonus.

Re:Awesome, but can it run on an Intel Mac? (4, Funny)

tb3 (313150) | more than 8 years ago | (#15042622)

Geez! Are you the guy that keeps asking this same question every 5 minutes on #sqlonrails? RTMFM already!

Re:Awesome, but can it run on an Intel Mac? (1)

m50d (797211) | more than 8 years ago | (#15042776)

I think you'll need to use wine.

Great April (0)

Anonymous Coward | more than 8 years ago | (#15042412)

HAHAHA you guys are really going overboard with april fools this year with the colourscheme, the cute overload tie-up and several top-notch jokes. Congratulations, this Anonymous Cowards hat is off!

Wow! (0)

Anonymous Coward | more than 8 years ago | (#15042416)

I'd like to sink my dink in that pink.

3 magic words == very good article (0, Redundant)

ickeicke (927264) | more than 8 years ago | (#15042421)

Kitten + Rails + Power => \o/

Correct version (0)

Anonymous Coward | more than 8 years ago | (#15042569)

Kitten + Rails + Power = PETA "visit"

time until normality: (0)

Anonymous Coward | more than 8 years ago | (#15042422)

5 hours and 49 minutes until the pink goes off

ZOMG (0)

Anonymous Coward | more than 8 years ago | (#15042434)

Cowboy Neal speaks french!

to all whiners (0)

Anonymous Coward | more than 8 years ago | (#15042436)

For all you folks whining about how tired you are of Aprils Fools Days stuff, get over it. Its going to go on ALL DAY! yeee haw!!

Stop Visiting SQLonRails.org (4, Funny)

dduardo (592868) | more than 8 years ago | (#15042438)

I'm trying to download the development files and you're all slowing me down.

Re:Stop Visiting SQLonRails.org (0)

Anonymous Coward | more than 8 years ago | (#15042523)

You should have used the .torrent.

The only SQL you really need (3, Funny)

ThatGeek (874983) | more than 8 years ago | (#15042442)

select story from queue where april_fools_day_joke != 'crap;

Re:The only SQL you really need (4, Funny)

Xavic (826170) | more than 8 years ago | (#15042465)

You have an error in your sql near ';'

Re:The only SQL you really need (1)

Senzei (791599) | more than 8 years ago | (#15043602)

You have an error in your sql near ';'

More evidence that at least half of the commentary on slashdot is actually handled by bots. That said it does make for a good code checking system.

Re:The only SQL you really need (1)

technoextreme (885694) | more than 8 years ago | (#15042467)

select story from queue where april_fools_day_joke != 'crap;
Yeah the editors kept on trying that but all they got was error messages.

Re:The only SQL you really need (1)

ptomblin (1378) | more than 8 years ago | (#15042483)

0 rows returned

It would be awesome (1)

scwizard (941758) | more than 8 years ago | (#15042448)

It would be awesome if during April fools all of this stuff turned out to be true.
Then at midnight everything went back to normal.

Woe is me (2, Funny)

mattpointblank (936343) | more than 8 years ago | (#15042462)

I feel like a total n00b. I spent all last summer learning php/MySQL to redesign my site, and I only now realise it's pronounced 'Sequel' as opposed to "S-Q-L" as I'd been mentally calling it. Similarly, it took me a Java course at university to learn how to say C#.. the issues of being a lonely geek without others to converse with (in real life) and learn proper pronunciations.

Re:Woe is me (1)

Nicholas Evans (731773) | more than 8 years ago | (#15042478)

Too bad it is pronounced S-Q-L.

Re:Woe is me (1)

redalien (711170) | more than 8 years ago | (#15042487)

Well, neither in a computer science department or commercial firms have I ever heard it called sequel, I think it's not in common use in the U.K..

Re:Woe is me (1)

blincoln (592401) | more than 8 years ago | (#15042610)

Well, neither in a computer science department or commercial firms have I ever heard it called sequel, I think it's not in common use in the U.K.

That may be. However, I'm in the US, and every DBA I've worked with has pronounced it "sequel." I think it sounds a lot better than another TLA too.

Re:Woe is me (1)

Mark_Hopkins (171974) | more than 8 years ago | (#15042635)

That may be. However, I'm in the US, and every DBA I've worked with has pronounced it "sequel." I think it sounds a lot better than another TLA too.

I call it "squeal" just to piss off my DBA.

OLE or Olay? (1)

Latent Heat (558884) | more than 8 years ago | (#15043983)

Back when it was cool to know about OLE in Windows, I would call it oh-el-ee, even when corrected to call it oley (as in ole with the accent on the e as what people chant at the bull fight). I was a noob to call it oh-el-ee, but I was just not going to dignify the Microsoft Offering de Jour by calling it oley.

Re:OLE or Olay? (1)

CheeseTroll (696413) | more than 8 years ago | (#15044063)

I'd never heard of it as anything but O-L-E, but I apparently I wasn't hanging around with the cool programmers. :-)

A couple of years ago, I was working with a guy who insisted on referring to D-L-L's as "dills". That made me chuckle every time.

Re:Woe is me (1)

stevey (64018) | more than 8 years ago | (#15043087)

I work in a database shop in Edinburgh and I've heard it called S-Q-L and Sequel pretty much interchangably.

The most grating pronunciation I've ever heard was one manage who used to read HTML as "H-tim-el".

I always wondered who Tim was...

Re:Woe is me (1)

redalien (711170) | more than 8 years ago | (#15043389)

I'd guess TBL [w3.org] .

Re:Woe is me (1)

j79 (875929) | more than 8 years ago | (#15042489)

Woe is me, err, us. I, too, mentally call it "S-Q-L". Now I'm afraid that PHP may be something like, "FFIIPP", and XML "XEMUL"??

Re:Woe is me (1)

SillySnake (727102) | more than 8 years ago | (#15042514)

Wow you really got suckered in by that part of the April Fools joke :)

Re:Woe is me (1)

Fez (468752) | more than 8 years ago | (#15042668)

What, you mean it's not pronounced SQuirreL?!

Re:Woe is me (1)

the_womble (580291) | more than 8 years ago | (#15042670)

it took me a Java course at university to learn how to say C#


So how do you pronounce it? Is it "see octothorpe [wiktionary.org] or "see hash"?


Its not just MS either, "guh-nome [n0i.net] " is just as bad.

Re:Woe is me (1)

glesga_kiss (596639) | more than 8 years ago | (#15043406)

So how do you pronounce it? Is it "see octothorpe or "see hash"?

I'm guessing you've never played a musical instrument then? This one time, at band camp, we called it "c sharp".

Re:Woe is me (1)

mattpointblank (936343) | more than 8 years ago | (#15043603)

Haha, good point, I guess it never occured to me that it might be some kind of musical annotation, even though I am actually a longtime musician. Doh..

Re:Woe is me (0)

Anonymous Coward | more than 8 years ago | (#15043905)

Hmm, I always thought that C# was just about the pitch of the sound coming out of someones ass when they had bad beans (Java or otherwise) for breakfast...but who am I?

Re:Woe is me (0)

Anonymous Coward | more than 8 years ago | (#15042706)

And here I've always used "sequel" and laughed at people who say "S-Q-L".

Though I realized recently I'm in the minority when I pronounce Counterstrike's "awp" as "A-W-P".

Re:Woe is me (1)

MrP- (45616) | more than 8 years ago | (#15042710)

When someone calls it Sequel I slap them.. Sure its a common way of saying it but fuck everyone I still say S-Q-L.

well, you are just SO wrong!! LOL (0)

Anonymous Coward | more than 8 years ago | (#15042727)

It's pronounced "skewel". So there, smarty shorts!

Re:Woe is me (1)

rbarreira (836272) | more than 8 years ago | (#15042724)

Where I work everyone calls it Sequel. I find it really stupid but I'm getting used to say it too, since I don't want to explain what I mean by S-Q-L everytime I say it...

Re:Woe is me (1)

slazzy (864185) | more than 8 years ago | (#15043291)

I still call it structured query language every time, but then I'm a real geek.

Re:Woe is me (1)

slazzy (864185) | more than 8 years ago | (#15043305)

I take that back, a real geek can speak in SQL.

Re:Woe is me (1)

mikiN (75494) | more than 8 years ago | (#15043962)

So real geese can squeal? I think you're stating the obvious here.
Oh, you meant geeks! Well, what's the difference if all they do is discuss 'drop'ping water 'table's and rant about the latest phishing exploit?

Here's the source code for Google.com! (1)

theurge14 (820596) | more than 8 years ago | (#15042466)

SELECT * FROM interweb WHERE results LIKE %i'm feeling lucky!!!!!`11`%;

That's it. SQL on rails is awesome.

Re:Here's the source code for Google.com! (1)

Tablizer (95088) | more than 8 years ago | (#15042692)

Okay, but when I hit the monkey, I got "Error: Access to table 'monkey_brains' denied. 'white-house' domain is read-only."

Actually, SQL needs to be on rails. (3, Funny)

AtariDatacenter (31657) | more than 8 years ago | (#15042472)

Traditionally with SQL, a user is capable of perfoming one or more unrestrained queries, which can bring a traditional database to its knees. What SQL has been lacking, up until this point, is stability and restraint. This is why rails are necessary for SQL.

Rails help to keep SQL on the tracks and to prevent queries from running unrestrained against a database. With rails, you don't have to worry about unsafe queries against your database. Everything is tightly controlled, and you can have a simple three line search engine without a great deal of overhead that normally goes into all of that normalization, checking, deadlock prevention, etc etc.

Finally! I'm waiting for HTML on Rails next!

Re:Actually, SQL needs to be on rails. (1)

mikiN (75494) | more than 8 years ago | (#15043992)

Finally! I'm waiting for HTML on Rails next!

Just post on Slashdot and extract the HTML for the posting. That and the Lameness Filter will get you back on track lickety---quick!
Who needs images, frames, <BLINK> tags and all that when all you need are text, links and a few very basic decorations?
Hail the CERN text-mode browser! Ho! Ho!

Neat, but necessary? (1)

wetfeetl33t (935949) | more than 8 years ago | (#15042497)

So SQL on rails is supposed to be "taking the VC out of MVC"
Seems handy, but stuff like this really shouldn't be oversimplified. Since when has the "view" and "controller" been considered unimportant?

Re:Neat, but necessary? (2, Funny)

Anonymous Coward | more than 8 years ago | (#15042549)

You're kind of an idiot, aren't you.

Re:Neat, but necessary? (1)

SIWaters (181004) | more than 8 years ago | (#15043149)

And I thought the "VC" stood for venture capital. Silly me.

Re:Neat, but necessary? (0)

Anonymous Coward | more than 8 years ago | (#15044067)

Oh, I see. I was thinking that it took the Version Consistency out of Multi Version Consistency. It makes much more sense now.

MS-DOS terminal (2)

yroJJory (559141) | more than 8 years ago | (#15042501)

OMG!!! I love the MS-DOS 3.2 Terminal window under Mac OS X. :):):)

Re:MS-DOS terminal (1)

tjr (908724) | more than 8 years ago | (#15042526)

Me too!

CAN IT DO PICKLES!!! (0)

DAldredge (2353) | more than 8 years ago | (#15042509)

mod me up +5!!!!

love pickles! LOL!!!

Pickles! (0, Offtopic)

themusicgod1 (241799) | more than 8 years ago | (#15042647)

OMG Pickles!
TEE HEE! :DDDDD

Re:CAN IT DO PICKLES!!! (0)

Anonymous Coward | more than 8 years ago | (#15042824)

Those better be kosher dills you love you anti-semetic shit, or else you are in trouble.

Re:CAN IT DO PICKLES!!! (0)

Anonymous Coward | more than 8 years ago | (#15042961)

Yes, we all know Darren Wilson Aldredge, age 31, of Gladewater, Texas, is a redneck little shit, and anti-Semitism would perfectly fit his profile. But where's the evidence? Link, please, for future reference.

Re:CAN IT DO PICKLES!!! (0)

Anonymous Coward | more than 8 years ago | (#15043197)

Well since the "link please" bullshit is Dshitredge's favorite thing to post after his anti-semitic crap I don't think I should have to point this out since you are probably the anti-semite himself but, HERE YOU GO! [slashdot.org]

Re:CAN IT DO PICKLES!!! (0)

Anonymous Coward | more than 8 years ago | (#15043296)

Thanks for the link, even though I'm slightly insulted you'd mistake me for our friend Darren. Does my writing really come across to you as illiterate?

EAT MON FUCK (-1, Troll)

Anonymous Coward | more than 8 years ago | (#15042524)

Taco slides his razor thin member into cowboyneals fat roll. Unfortunatley, taco slid in too far and got lost in the abyss that is cowboyneals fat slabs. eat my dick and suck my ass homos

Please make the hurting stop. (1)

stampsc (924332) | more than 8 years ago | (#15042577)

If I see the word kittens one more time I'm going to . . .probably . . umm . . .wait until tomorrow to believe slashdot stories . . .never mind . . .

Re:Please make the hurting stop. (1)

VJ42 (860241) | more than 8 years ago | (#15042853)

kittens.

3 lines of code is bloatware! (1)

locnar42 (591631) | more than 8 years ago | (#15042613)

Search engine in 1 line of code:

print "Results not found";

Re:3 lines of code is bloatware! (1)

SmurfButcher Bob (313810) | more than 8 years ago | (#15042760)

You mean,

print "KITTENS! [goatse.cx] "

Re:3 lines of code is bloatware! (1)

Kelson (129150) | more than 8 years ago | (#15043005)

You may laugh, but I've actually written a search engine that way.

Admittedly, the site in question went into operation exactly one year ago...

OMG RAILS iS TEh SUK (4, Funny)

bitt3n (941736) | more than 8 years ago | (#15042672)

I hate rails. Rails caused the demise of the Pony Express!1

hahaha (0, Redundant)

Abstract (12510) | more than 8 years ago | (#15042693)

nice job! very funny stuff.

Learn SQL First! (1)

LABob (870126) | more than 8 years ago | (#15042753)

To get the full benifit of SQL on Rails, noobs should seriously consider learning a bit about SQL first!

Anyone See Family Guy Last Sunday? (0, Offtopic)

jwbrown77 (526512) | more than 8 years ago | (#15042946)

These April Fools jokes make me laugh like Stewie laughs at BC comic strips.

Screencast contains a virus? (0)

Anonymous Coward | more than 8 years ago | (#15042947)

I'm not joking, I'm not april fooling, or anything like that; I was running the screencast in realplayer, and suddenly literally everything crashes and my firewall gets taken down.

Then I try playing it in Quicktime and I get a "buffer overrun detected" on screen.

Anyone else get this?

I'm all for laughing at jokes and such, but fucking with people's system's is a little too serious for me.

Re:Screencast contains a virus? (1)

clm100 (758897) | more than 8 years ago | (#15044107)

Virus? I don't think so. The file is quicktime, it probably just doesn't work right in real player.

Plus, based on the actual video it was made on a mac. Everyone knows they can't get viruses ;) And shouldn't you be more worried about the privilege escalation in the download?

4.1? (1)

Loconut1389 (455297) | more than 8 years ago | (#15043273)

Did anybody else notice version 4.1 (4/1 eg April 1), or was it just too obvious to write about?

Re:4.1? (1)

jamwt (220439) | more than 8 years ago | (#15043540)

Did anybody else notice version 4.1 (4/1 eg April 1), or was it just too obvious to write about?

Check out the mtimes of the file in the tarball. :-)

Re:4.1? (1)

Loconut1389 (455297) | more than 8 years ago | (#15043741)

Didn't even notice there was a download. Funny!

APRIL FOOLS! (1)

Eideteker (641508) | more than 8 years ago | (#15043275)

APRIL FOOLS!

This isn't exactly a joke... (4, Informative)

Anonymous Coward | more than 8 years ago | (#15043348)

I've written and supported giant applications for years using SQL on Rails -- except we called it Oracle Web Server, Oracle Application Server and Oracle WebDB. Just like in the Rails screencast, you had one giant file that contained all your HTML, SQL, and dynamic code. To run the app you just imported the massive SQL file into the database, which looked like this:

CREATE OR REPLACE PROCEDURE hello_world IS
begin
      htp.print('<html>');
      htp.print('<head>');
      htp.print('<title>HTP.PRINT Example...</title>');
      htp.print('</head>');
      htp.print('<body>');
      htp.print('<h1>Hello, World!<h1>');
      htp.print('</body>');
      htp.print('</html>');
end;

This technology was sold as the premier way to write web apps for many years. Universities taught CS students to code with this, consultants in dark suits charged $150+ an hour to develop with it, and corporate clients paid tens of thousands of dollars per instance. I sincerely wish I was joking.

The screencast was funny (2, Informative)

HvitRavn (813950) | more than 8 years ago | (#15043788)

The screencast is probably the funniest thing I've seen all day. It has lots of amusing little details that made me smile. This mirror seems pretty fast: http://screencast17.sqlonrails.org/video/screencas t2_lq.mov [sqlonrails.org]

Re:The screencast was funny (0)

Anonymous Coward | more than 8 years ago | (#15044090)

I noticed a lot of the funny things as well. Here a few people might want to look for if they watch it again.

The other projects this guy has. The xeyes dependency. The whole environment setting. Infinite loop in the sed script. Whenever they stop the server it "Patches memory leaks." When they add the new query page there's a "SQLMagicHelperConnect" function. The file sizes and page summaries on the search results. The o'reilly book (also on the site). And of course the taco bashing.
Load More Comments
Slashdot Account

Need an Account?

Forgot your password?

Don't worry, we never post anything without your permission.

Submission Text Formatting Tips

We support a small subset of HTML, namely these tags:

  • b
  • i
  • p
  • br
  • a
  • ol
  • ul
  • li
  • dl
  • dt
  • dd
  • em
  • strong
  • tt
  • blockquote
  • div
  • quote
  • ecode

"ecode" can be used for code snippets, for example:

<ecode>    while(1) { do_something(); } </ecode>
Create a Slashdot Account

Loading...