Log file Viewer

[12:55:58] <kthakore> hello

[13:01:51] <tychoish> hi

[13:41:13] <Mikero> Hi everyone. I'm currently designing a MySQL database and I'm noticing I need to use a lot of "tricks" to actually make some important table contain dynamic fields I.e. actions which each can have extra parameter/fields. So I think I'm actually bending mysql in ways that relational databases are not intended to, might actually MongoDB be a better choice for me?

[17:40:19] <KwikkSilva> morning

[17:41:41] <KwikkSilva> when importing data to mongo - is there a way to ohave a natrual integer key created (aswell as the id field) going from 1 -> n if there is not an integr key in the source data

[17:47:11] <skot> You can write your own import to script to insert a field in a document as a counter.

[18:25:01] <paulswansea> Hi, is there anyone who uses Shanty Mongo in here?

[22:27:19] <dreieins> hi, I figured I have a db that has grown too large and I'm clueless why. It's supposed to be much smaller. How can I find out which db or collection is the culprit?

[22:43:57] <Goopyo> dreieins: yeah the database collection stats should tell you

[22:44:20] <dreieins> Goopyo: I think it's because of space allocation as mentioned here: http://www.mongodb.org/display/DOCS/Excessive+Disk+Space

[22:44:56] <Goopyo> ah yeah

[22:44:58] <dreieins> Goopyo: since it's going from 16 to 256

[22:44:58] <Goopyo> that could do it

[22:45:07] <dreieins> which would make sense

[23:24:45] <Zelest> is it considered bad to use a string as _id?

[23:29:19] <BurtyBB> Zeelot, I hope not

[23:41:47] <Zelest> I plan to store a lot of domains/urls (backend for a crawler sort of) .. is this a proper way of storing the data? http://pastie.org/private/ot3ingi4iunbsdlmfnzjpq

[23:41:58] <Zelest> My main concern is the 16MB limit per document.

[23:47:51] <BurtyBB> Zeelot, looks similar to how I'm storing my domain stuff - if reaching 16MB is a posibiliy you might have to move the "pages" out I guess.

[23:54:37] <toothr> Zelest, you could always just make each url it's own document...

[23:56:07] <Zelest> yeah, but then i need more lookups in the db (to find the domain and the path)