Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon.

Pages: 1-

wow databases

Name: Anonymous 2009-08-03 16:25

why use dbs when I can just store info in text files? is this windows or what

Name: Anonymous 2009-08-03 16:28

like totally right I mean oh my god like no way

Name: Anonymous 2009-08-03 16:36

why use computers when I can use magic and achieve the same things?

Name: Anonymous 2009-08-03 16:59

why use lisp when I can just store code in perl files? is this 6.001 or what

Name: Anonymous 2009-08-03 17:01

no seriously what are the advantages?

Name: Anonymous 2009-08-03 17:41

>>1,5
Can you you move to a random record in under O(n) with a text file?

Name: Anonymous 2009-08-03 17:44

Can you do complex queries with fairly small access costs?

Name: Anonymous 2009-08-03 17:52

Using a database is the closest you'll ever come to having a relationship.

Name: Anonymous 2009-08-03 17:54

>>6
If the records have fixed size (padding can be used) it's 1, otherwise at most n.

Name: Anonymous 2009-08-03 18:31

ok, whats a good mysql learning book? like sicp, not some for dummies bullshit

Name: Anonymous 2009-08-03 18:33

Name: Anonymous 2009-08-03 18:35

>>10
SICP

Name: Anonymous 2009-08-03 18:48

wow a dolphin ow gay, is mysql for faggots or what?

Name: Anonymous 2009-08-03 19:39

Okay, seeing as this thread is worthless and shares the topic with my potential thread, I'll take over from here;

I'm learning PHP and MySQL and I have this:

sqlite> select * from foo;
1|foo|bar
2|baz|quux
3|hma|quux
4|HAX|bar


And this:

   $sqldb = sqlite_open("dbase.db");
   $result = sqlite_query($sqldb, "select * from foo where title = 'bar'");
   $res = sqlite_column($result, "name");
   var_dump($res);


And the result is string(3) "foo" . Why am I not getting some array of the first and fourth record? How do I extract all matching records, not just the first?

Name: Anonymous 2009-08-03 19:40

>>13
cool story bro

Name: Anonymous 2009-08-03 19:50

>>14
Why am I not getting some array of the first and fourth record?
$res = sqlite_column
( `ー´)

Name: Anonymous 2009-08-03 20:17

>>16
Ugh.
I mean, of course, an array of the `title' fields of the first and fourth rows. The sqlite_query should narrow the database down to the first and fourth rows, and then the title column should be extracted, yes?

Name: Anonymous 2009-08-03 20:21

Okay, did that using sqlite_next. Is it the proper way or just a haxaround?

Name: Anonymous 2009-08-03 21:31

>>18
My friend, you are using PHP. There is no proper way.

Name: Anonymous 2009-08-03 23:16

Databases are just plain text files with a bunch of bloat slathered all over it to make look innovative.

Name: Anonymous 2009-08-04 1:47

Databases are just plain text files with a bunch of bloat slathered all over it to make look innovative.

Name: Anonymous 2009-08-04 2:14

>>20
structured data is just data reorganized around a bunch of other data
trees are just arrays with a bunch of references slathered all over to make it look innovative.

HURR DURR

Name: Anonymous 2009-08-04 7:41

>>22
fag

Name: Anonymous 2009-08-04 9:23

Wow what's with the insurgence of retards here?

>>21,22
THBT, PL

Name: Anonymous 2009-08-04 9:37

>>24
oh look at him so smart .
listen here not everyone knows everything and you were a newb too once so dont be a jerk okay?

Name: Anonymous 2009-08-04 9:47

>>25
You are wrong. Everyone here does know everything. Then summer came.

Name: Anonymous 2009-08-04 9:51

>>25
listen here not everyone knows everything
This is what people who haven't reached Satori actually believe.

Name: Anonymous 2011-02-03 7:26

Don't change these.
Name: Email:
Entire Thread Thread List