| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> i do embedded C++
<1> strtok, yea. you're in the minority.
<0> well, to a certain degree
<2> strtok: you are outcast
<0> :D
<1> there are SOME c++ embedded jobs. i know. i worked at a company that had some.
<0> but the rules we have oin performance limit a lot of things C++ was designed for
<3> OrngeTide, I never saw anything on indices on that site, but I'm probalby going to stick with what I have, since it normalizes the data a bit cleaner and makes it easier to search for things.
<0> but i've since heard google has similar rules
<3> OrngeTide, but it's not really decided yet
<1> Gambit-, it's way easier to search for things my way:P
<0> like the big one: no copy!
<4> OrngeTide: There's probably more embedded development in your neck of the woods.
<5> Seems I have mild attack of nickchangingobia
<3> OrngeTide, Not really, because everything will have to be blobs, since some parameters will be long compiled script strings and others will be ints.
<1> yea. there are a lot of companies in silicon valley that do "appliances" and stuff like that.
<5> again
<1> HashMish, i dunno what's up with your nickmania. this has been going on for about a week now.
<3> HashMish, nickchangeophilia, actually.
<5> nickmania is good term
<1> Gambit-, yea. you can store them in the VARCHARs if they are ascii safe.
<1> you can use BLOBs but they aren't very portable between SQLs.
<3> well they may not be, but the end result is a widely varying column width, which isn't very clean
<6> BLOB's are terribly slow too, no matter the db.
<1> Gambit-, why not?
<6> so be careful.
<1> i use variable column widths all the time. like i said. the size of a varchar is just a recommendation to the engine on how to store the data, it is not a limit.
<3> OrngeTide, because you're basically giving up the 'ordered' aspect of the database in exchange for quick lookups and such. If I was going to do that, I'd probably just license berkdb or do a flat file.
<1> well i'm using the relational properties still. that's the part that is actually important.
<6> tht's what's great about postgresql. varchar's can hold thousands of characters if need be
<3> you can't draw any conclusions about the data in a given column, which means you can't validate it.
<6> and you don't have to resort to TEXT
<1> Gambit-, if you say so. :P
<6> no, he's right.
<1> i think you can. just at a lower level.
<6> validating data on the database side is a long and tedious task, which is why most developers validate on the front-end
<6> like PHP or the GUI
<6> you really want to write triggers all day?
<1> feti, well he's using this for a product which will be generating all the data itself anyways. not from user input.
<6> oh, really.
<6> well then he has no choice
<4> Triggers are safer.
<6> it's triggers or no validation
<1> i'd go with no validation.
<6> and obviously the former is a better decision ;P
<3> hehe :)
<1> and implement the software correctly
<6> dude ya
<6> use postgresql and write your procedures/triggers in C
<6> and validate like that
<6> easy as pie
<1> like actually use transactions when updating interdepedent tables.
<3> I can't guarantee a lot of validation, but at least if I order the data it will give me a lot more control over it. Plus, to get an objects properties I only have to deal with one record instead of N records.
<1> feti, i usually use sqlite.
<6> oh, he's doing an embedded db?
<6> that'd work great
<3> feti, OrngeTide's really smart, but I don't use his design elements very often :)
<1> Gambit-, N records are faster than BLOBs :(
<3> No, I'm not doing an embedded db
<3> OrngeTide, I'm not touching blobs :)
<1> most people hate my designs.
<6> gambit: so you're accessing a remote database. and you have the db already picked or are up for advice?
<3> feti, postgresql, natch
<6> good
<1> Gambit-, i just chose something that would be flexible enough to store lua objects.
<6> so write triggers in C and you're set ;D
<3> yup
<6> wow you have the best of both worlds
<1> bah. i like sqlite better
<1> remote databases aren't really valuable if you only have one application accessing them ever anyways
<6> *laugh*
<6> or if you handle about 400 people a second
<3> OrngeTide, Right, but if I break it out into multiple column tables, I can have a column that is a blob_id that references the blobs which will be tucked away out of the normal system and only loaded on request.
<3> OrngeTide, I'm not planning on having only one application accessing it.
<6> sqlite stores in XML right? or is that a diff db?
<4> Setzer uses sqlite. He says it's very good and easy to use.
<6> maybe i'm thinking of hsql or something
<1> Gambit-, actually i did something like this. but it was file_id and it refered to a disk file. but it was for a webserver. it's way faster to send a disk file than a blob.
<1> feti, sqlite is it's own db. it's kind of a cross between a filesystem and a b+tree
<3> OrngeTide, Yeah, that's a definitely option as well.
<3> er, definite.
<1> sqlite is pretty fast. but it treats things as strings in a lot of cases.
<6> how much data are you going to be storing gambit
<5> jigabytes
<1> less than 200mb I'm guessing.
<5> 1.21 jugabytes
<6> oh if it's that tiny i wouldn't worry about pgsql eitehr
<6> either.
<6> don't even stress over it
<4> 200 MB...as I said...just store it in memory. :P
<1> the biggest advantage of sqlite is you don't need root access to set it up:)
<6> hehe
<1> Teckla, i think sqlite can mmap :)
<6> yeah it can
<6> :memory:
<6> when you specify it
<4> Oooh that's elite.
<1> feti, thanks:)
<6> np
<4> I'm with OT on dynamic design + sqlite.
<7> OrngeTide: i know :-/ what was i thinking with clues rather than outright answers :(
<1> Vratha, this is what happens when you use the socratic method on people who don't really care.
<7> yeah :-/
<1> blame the public education system
<4> socratic method?
<1> Teckla, yea. it's a method of teaching by only asking questions.
<4> That's weird.
<5> 'i thought it's when you walk about with students, putting yuor hand on their ***es
<1> it's good for things that are logical.
<1> Teckla, it is probably the best way to teach the natural sciences.
<8> students make terrible hand puppets
<1> you can teach programming that way too, because it makes people RTFM
<1> HashMish, i think you're thinking of plato.
<5> hmm probably
<1> anyways. i gotta go to work.
<5> some greek guy walked with them about
<1> Teckla, btw. i'm glad you agree with me. but still nobody uses my designs :)
<5> OT: how about publishing your Orange Book of OT design patterns ?
<4> OrngeTide: Ah well :)
<7> OrngeTide: the big problem with him is that he's a math education major that just doesn't get this stuff... and he's taking linear algebra again in the fall b/c he failed the first time or something
<7> i have this bad feeling he's going to screw up some youngster's math career
<5> Vratha: does he happen to ask weird questions about modulo ?
<7> HashMish: yeah, last week he did :)
<8> how could you fail linear algebra!
<3> feti, probably a fair bit more then 200mb, and it's going to be replicated around a fair bit :)
<5> Gambit;: you gonna need flux capacitor
<5> wow what teeth i have
<5> i can crush unpopped corns
<6> the only bad thing about pgsql is there are no real good enterprise-ready replication options
<6> even mysql has a couple good ones ;(
<6> and i'm only a pgsql fan to be honest
<6> it's a shame :(
<3> well slone's not too bad
<7> jeffloc: hell, i really really don't know... it's freakin' linear algebra!
<5> what's pgsql
<3> pretty robust, from what I hear.
<6> i'll definitely have to look into that
<8> :)
<6> we just ordered a dualcore dual opt for our members db server and we'll wan tit replicated, even though it's raided
<6> but up to this point i couldn't find anything good or worthy of even testing
<6> and i'm jealous about mysql's replication ;P
<6> bitter too
<6> haha
<3> yeah, slone's the way to go. YOu need something else to handle the actual failover behaviors, mind.
<6> erm
<6> can it do multiple server replication?
Return to
#c
or
Go to some related
logs:
liberatianism + free will
#hardware
thicke's ethnicity
#beginner
#gentoo
3dsmax city square
ssh rhel time out
#computers
evms gentoo mdstat
jingofin
|
|