PHPTXTDB

« Return to Article
  • Nagesh 2012-11-19 08:08
    FRIST(Y)For some reason this field must not be empty(Y)posted=yes
  • Anon 2012-11-19 08:08
    split("(.Y.)" "frist?")
  • LoremIpsumDolorSitAmet 2012-11-19 08:08
    "Do you like our new website? Please respond with either yes (Y) or no (N)."

    Why is this not working???
  • Justsomedudette 2012-11-19 08:09
    The real WFT good decision boss? Now that's a frist.
  • DR 2012-11-19 08:13
    And they implemented WordPress and immediately got hacked.
  • Remy Porter 2012-11-19 08:16
    Obviously, Chad was more of a leg man.
  • LoremIpsumDolorSitAmet 2012-11-19 08:18
    Anon:
    split("(.Y.)" "frist?")

    Why would you ever want to split() on (.Y.) ? Personally, I'd rather join() with them.

    Being a registered user is sad because I don't get any funny captchas on which to comment.
  • letatio 2012-11-19 08:18
    (Y) giggity
  • Something 2012-11-19 08:26
    If this had somekind of proper layout, I would not think it would be THAT horrible of a solution to use text files instead of a database.
    The upside is obviously that you are not likely to get SQL injections, and if advanced querying, performance and safety isn't needed this might be OK.

    Yet I cannot seem to wonder that a harder solution was chosen over an easier solution, where you just make a connection and start querying. Having to parse the files manually seems more like feature creep than anything else.

    CAPTCHA comment: praesent, like a present but with an a
  • Smug Unix User 2012-11-19 08:34
    He should have split on the RS character. That is what it there for. Text files are perfectly sensible for when this whole database, internet fad goes away.
  • Nagesh 2012-11-19 08:39
    Something:
    If this had somekind of proper layout, I would not think it would be THAT horrible of a solution to use text files instead of a database.
    The horror was that there was no support at all for updating the database except by manual hacking.

    Yet I cannot seem to wonder that a harder solution was chosen over an easier solution, where you just make a connection and start querying. Having to parse the files manually seems more like feature creep than anything else.
    Opening a database connection is only an easier solution if you already know how to, and know how to set up a database to connect to in the first place. On the other hand, every crappy introduction to any programming language will show you how to do rudimentary text processing, so you don't need to go learn new things in order to do that. Using the tools already in your possession is, if not the easiest path, then certainly the one of least resistance.
  • Nagesh 2012-11-19 08:50
    Smug Unix User:
    He should have split on the RS character. That is what it there for.
    Shouldn't that be something like "Smug TOPS-10 User", then? Unix has always preferred linefeeds and spaces for splitting on.
  • English Man 2012-11-19 08:55
    So Kyle sat there like a dummy, not thinking to suggest a new system himself, until his boss pulled him up for being incompetent?
  • ObiWayneKenobi 2012-11-19 09:02
    English Man:
    So Kyle sat there like a dummy, not thinking to suggest a new system himself, until his boss pulled him up for being incompetent?


    Maybe he figured the boss was like most clueless IT bosses and held on to that old saw "if it's not broke don't fix it" and that he would have been reprimanded/fired for "wasting time" coming up with a new solution instead of getting his work done?

    We don't know how long he was in the position. Maybe he was the "new guy" and didn't want to stir the pot.
  • AGray 2012-11-19 09:07
    The real WTF is that we really get a sad ending, because most WTFs are sad endings and we didn't get one, even though upon seeing something like 'phptxtdb', we were all expecting it.

    public bool IsRealWtf(bool expectation = false)
    
    {
    return expectation == _Ending;
    }
  • @Deprecated 2012-11-19 09:07
    Kyle walked Bill through the process. First, he opened i.phptxtdb. This file stored an image name and a base64-encoded representation of the image.


    No wonder it took so long... base64 encoding images by hand is a real pain!
  • ip-guru 2012-11-19 09:09
    isn't it a bit unfair to pick on chard when this is clearly an Amateur project?
    I though this site only highlighted WFT's from professionals.
  • Captcha:nibh (is that one new?) 2012-11-19 09:10
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?
  • urza9814 2012-11-19 09:11
    I did something like this once for a university club, but only because they didn't let us have database access of any kind. Except my solution simply wrote blog entries straight to an RSS file and then read that back to display them. And my solution had an editor page so you never needed to manually enter into the text file. And my solution was (obviously) XML instead of '(Y)' delimited. And I used an existing PHP library to read back the RSS file.

    OK, so I did something not very similar to this once.
  • Remy Porter 2012-11-19 09:18
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.
  • James 2012-11-19 09:20
    I've done one of those. It started out being database backed, having made the foolish assumption that I might be able to use a database on a server that clearly already had one installed.

    I'm pretty sure the story isn't about mine, though, since it appears to still be running. The last time I had anything to do with it was writing a brief description and apology for the next guy to pick it up. Unless the happy ending was part of the anonymization, of course.
  • Frosh 2012-11-19 09:39
    Smug Unix User:
    Text files are perfectly sensible for when this whole database, internet fad goes away.


    Surely you mean "perfectly cromulent."
  • Pista 2012-11-19 09:49
    ip-guru:
    isn't it a bit unfair to pick on chard when this is clearly an Amateur project?
    I though this site only highlighted WFT's from professionals.


    Being done for a business organization (the college radio), it wasn't an amateur project, but a professional one. This is true even if I'd rather cut my tongue instead of calling that guy a "professional"
  • camelotbob 2012-11-19 09:57
    "College radio stations are small, but highly technical organizations. "


    You smoke what? Seriously, who believes that!??
  • D-Coder 2012-11-19 10:02
    Captcha:nibh (is that one new?):
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?
    "(i|=J7}Y&.`Gb)"? That's amazing - I've got the same combination on my luggage!
  • Cbuttius 2012-11-19 10:32
    I request the radio station to play some Grimbitch, please...

  • Evo 2012-11-19 10:33
    How does one even 'overflow the buffer' in PHP? Or is it supposed to mean exhausting the memory?

    EDIT: Actually, that might be fgets... But that one he could've fixed by simply removing the second parameter.
  • JC 2012-11-19 10:33
    This is all perfectly sensible in a BI enviro.....

    .... oh never mind.
  • xOneca 2012-11-19 10:35
    Captcha:nibh (is that one new?):
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?

    You better not to tempt your fate...
  • foo 2012-11-19 10:41
    LoremIpsumDolorSitAmet:
    Being a registered user is sad because I don't get any funny captchas on which to comment.
    You do. Just look at other's comments. The few CAPTCHAs in use here have all be commented on, many times.

    So please pick one at random and make your funny comment. But be sure it's the same funny comment made dozens of times before, otherwise some of us might never recover from the shock of the unexpected.

    CAPTCHA: wisi - I wisi had a funny remark on that. LOL! ROFL! How funny!
  • Gazpacho 2012-11-19 10:41
    (Y)God(Y)
  • foo 2012-11-19 10:45
    @Deprecated:
    Kyle walked Bill through the process. First, he opened i.phptxtdb. This file stored an image name and a base64-encoded representation of the image.


    No wonder it took so long... base64 encoding images by hand is a real pain!
    If you can do the JPEG encoding by hand, the additional base64 step is a piece of cake.
  • foo 2012-11-19 10:47
    Captcha:nibh (is that one new?):
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?
    If you're the owner of this site, then very likely, since today. :)

    Seriously, random strings (long enough) are fine (see MIME boundaries), unless you need to document them and put the documentation in the "database" itself. Then you have the same escaping problem, whatever you use.
  • Rodnas 2012-11-19 10:49
    ip-guru:
    isn't it a bit unfair to pick on chard when this is clearly an Amateur project?
    I though this site only highlighted WFT's from professionals.


    Yes (Y) professionals like Paula Bean.
  • Zylon 2012-11-19 10:58
    Remy Porter:
    It's not like it's some club that people do on the side- it's a job which people get paid for.

    Dude... lern 2 em dash. Or at least type two hypens.
  • Cbuttius 2012-11-19 11:06
    Remy Porter:
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.


    A very clever program would allow a pre-recorded program other than the request slot whereby it can "dynamically" insert based on what the public has requested.

    Of course you would use some kind of online request list.

    However to make it more interesting you can't just play the popular songs or the producer's own choices. The purpose of a request section should be to get some less-usual music played on the show.

  • Y_F 2012-11-19 11:08
    I wept. Klye, enjoy the programmer's paradise... for all of us!
  • C-Derb 2012-11-19 11:20
    JC:
    This is all perfectly sensible in a BI enviro.....

    .... oh never mind.
    +1 Best comment of the day so far!
  • Paul Neumann 2012-11-19 11:22
    Zylon:
    Remy Porter:
    It's not like it's some club that people do on the side- it's a job which people get paid for.
    Dude... lern 2 em dash. Or at least type two hypens.
    But side-- is center, isn't it?
  • hikari 2012-11-19 11:24
    Smug Unix User:
    He should have split on the RS character. That is what it there for. Text files are perfectly sensible for when this whole database, internet fad goes away.


    I think there are a great number of people who have never looked at an ASCII table, so it doesn't occur to them that there are characters outside the range of ones you normally see.

    Of the ones who do realize this I suspect there is an even smaller proportion who know what the likes of FS, GS, RS, and US are for.

    The last thing I worked with that actually used them was ISO/IEC 8211.
  • ubersoldat 2012-11-19 11:26
    Kyle cut him off. “I would be happy to. I’ll make the time.”


    Yeah, still in college. By the time Kyle learns how the real world TM operates, he would have said something along the line: "yes, it's possible, you just need to allocate the resources for this".

    I love enterprise environments.

    Oh, and Chad maybe read somewhere that ORM's were evil and some how thought that DB's were evil too... for some reason.

    Finally, TRWTF is using a RDBMS for a CMS.
  • just stop it 2012-11-19 11:31
    Nagesh:

    Opening a database connection is only an easier solution if you already know how to, and know how to set up a database to connect to in the first place. On the other hand, every crappy introduction to any programming language will show you how to do rudimentary text processing, so you don't need to go learn new things in order to do that. Using the tools already in your possession is, if not the easiest path, then certainly the one of least resistance.


    It's also the path that eventually leads you to believe your hammer is golden.
  • asd 2012-11-19 11:36
    I've done something similar a long time ago. I was about 14 or 16 back then. Since it was a javascript "app", all the data was initially stored in one big, ugly JS file, like

    stuff[0]["name"] = "foobar";
    stuff[0]["type"] = "something";
    stuff[0]["price"] = "235";

    stuff[1]["name"] = "moo";
    stuff[1]["type"] = "something else";
    stuff[1]["price"] = "42";

    so yes, instead of putting it all in a database, or at least in a JSON or XML file, I made the PHP code explode each line at = first, and then at ][ and ], I think. I had no idea about regex either. Also, the JS file was required to have special comments to mark the area to parse.
  • Ralph 2012-11-19 11:41
    Hey I'd much rather have PHPTXTDB than PHPBINDB because decoding undocumented arbitrarily-formatted binary data structures is even worse! Yes, I'm looking at you, almost-every-proprietary-software-vendor-out-there.
  • (i|=J7}Y&.`Gb) 2012-11-19 12:12
    Captcha:nibh (is that one new?):
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?


    (i|=J7}Y&.`Gb) is my name you insensitive clod.
  • Jeff 2012-11-19 12:18
    (i|=J7}Y&.`Gb):
    Captcha:nibh (is that one new?):
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?

    (i|=J7}Y&.`Gb) is my name you insensitive clod.
    Yes but you're just one person; you don't expect the entire world to redesign its software systems just to accommodate you, do you?
  • Oyo 2012-11-19 12:29
    Chad simply was ahead of his time. Today we call this NoSQL.
  • Some Random Texan 2012-11-19 12:31
    Cbuttius:
    Remy Porter:
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.


    A very clever program would allow a pre-recorded program other than the request slot whereby it can "dynamically" insert based on what the public has requested.

    Of course you would use some kind of online request list.

    However to make it more interesting you can't just play the popular songs or the producer's own choices. The purpose of a request section should be to get some less-usual music played on the show.



    Oh silly me. I thought the request segment was there to let the callers randomize the daily play list, instead of the machine. Expecting people to call in songs that aren't in the top 25 would be madness. After all, people these days think entertainment is supposed to be fed directly to your brain without that harassing superstitious "free will".

    CAPTCHA: ideo - what happens when an idea fades because the thinker can't hold onto original thought for more than a split second.
  • Ryan 2012-11-19 12:36
    “I would be happy to. I’ll make the time.” Is absolutely the right answer
  • not frist at all 2012-11-19 12:39
    Jeff:
    Yes but you're just one person; you don't expect the entire world to redesign its software systems just to accommodate you, do you?
    I didn't even read the responses to this comment and knew it was some fag linking xkcd. It's not clever. It's not funny. The initial comment was all I needed to know that someone would link the cartoon where the parents iteratively one-up each other on how to screw the school system.

    It was funny to read when it came out. It's even funny when clicking on the Random button on the site and seeing it. It's NOT funny when someone links to it from a one-sentence post and thinks they're so fucking clever to have discovered xkcd.

    You probably still use lmgtfy and think you're so damn clever.

    It means in real life, you're an unoriginal hipster doofus.


    Got anything to do with sanitizing inputs to a SQL database, etc.? Link to Bobby Tables. Got a nerd-project slow-ass turing machine? Like a minecraft logic circuit from redstone? Link to the one where it's some guy alone in the world making a computer out of rocks. Got a story about password security or encryption? Link to the one where they beat the password out of the guy with a wrench.

    Fuck off. You're not clever.
  • Jeff 2012-11-19 13:15
    I think your auto-troll script needs some fine tuning in the keyword matching area.
  • El Ka-Ben 2012-11-19 13:40
    I've done stuff like that for simple websites that seldom get updated. I just stuck with Tabs and Returns, though.

    Tab delimited text files are fine for that sort of thing, and easy to manage. If you need "users" to work it they can even open it in Excel. If you're setting up an FAQ section, or a set of items used on a couple of pages.

    As long as it's only a handfull of these files and they're read-only it can be maintainable.
  • Spewin Coffee 2012-11-19 14:22
    TRWTF is the use of WordPress. As a product, it is nearly unusable. Especially if you want to do something sensible like integrate network credentials instead of WP's built-in system, which educational institutions like to do these days. It certainly is not suitable as a CMS. (I manage the technical side of one of the largest WP installs in the world, and as a CMS, it sucks - it is also a terrible blogging platform, but that's a different story).

    However, WP would be a step up from this worse-than-fail scenario. But as a product, the use of WP is a fail. I'd go with the "or something" part of the boss' idea and find a more suitable product.
  • b0b 2012-11-19 14:22
    LoremIpsumDolorSitAmet:
    "Do you like our new website? Please respond with either yes (Y) or no (N)."

    Why is this not working???
    Your comment was caught in the ASCII porn filter. The second one looks kinkier, even a bit scary.
  • b0b 2012-11-19 14:29
    Captcha:nibh (is that one new?):
    The "string split" solution is not actually such a bad method. Sure, you're gonna get a lot of collisions with "(Y)", but how likely do you think that is if you use "(i|=J7}Y&.`Gb)" ?

    You just used it. So you should still check. MIME uses a random string separator for multipart messages. Just put it in the header so the decoder knows what the separator is. If you're going to build a search tree for full-text search anyway, it's easy to find an empty branch.
  • Cap'n Spanky 2012-11-19 14:33
    (Y)

    I don't get it.
    ...wait...we're programmers. none of us do.
  • Wyrm 2012-11-19 14:39
    More than that: it's the first "happy ending" I read with a spontaneous good choice from the boss. According to the story, the dev agreed to the boss' decision, not the other way around, which is mostly the case in the occasional "happy ending" stories.
  • 5urd 2012-11-19 15:22
    TRWTF is that there isn't even a command line tool to update the database. LET ALONE BASE64 THE IMAGES!

    CAPTCHA: luptatum
  • Dann of Thursday 2012-11-19 15:47
    not frist at all:

    Fuck me. I'm not clever.


    I have no idea what I just read....did some nerd write a script to automatically bitch about links to a webcomic and set it loose on a thread where nobody linked to the comic?

    Nerdy nerd nerd nerd. Look at all of that pure nerd rage.
  • Fedaykin 2012-11-19 16:54
    Something:
    If this had somekind of proper layout, I would not think it would be THAT horrible of a solution to use text files instead of a database.
    The upside is obviously that you are not likely to get SQL injections, and if advanced querying, performance and safety isn't needed this might be OK.

    Yet I cannot seem to wonder that a harder solution was chosen over an easier solution, where you just make a connection and start querying. Having to parse the files manually seems more like feature creep than anything else.

    CAPTCHA comment: praesent, like a present but with an a


    Use the right tool for the right job.

    SQL Injection is trivial to avoid.

    CMS is a solved problem.

    Building a frankensystem like that is always, always idiotic.
  • Johnny 2012-11-19 17:12
    [QUOTE user=Article]
    “Mostly. If images exceed a certain size, I think we overflow the buffer, but I haven’t tested it in awhile.”[/QUOTE]When I discover memory issues, I just ignore them. They might go away. I'm never sure though, because I haven't tested whether the issue still exists for a while.
  • Johnny2 2012-11-19 17:41
    Johnny:
    Article:

    “Mostly. If images exceed a certain size, I think we overflow the buffer, but I haven’t tested it in awhile.”
    When I discover memory issues, I just ignore them. They might go away. I'm never sure though, because I haven't tested whether the issue still exists for a while.
    FTFY

    CAPTCHA: distineo (that I have on my feet) is quite itchy
  • Friedrice the Great 2012-11-19 19:26
    Remy Porter:
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.

    I didn't get paid when I worked in a college radio station. And we didn't have any computers in the station at all.

    Guess that makes me old, doesn't it?
  • Matthijs 2012-11-19 20:20
    Pista:
    Being done for a business organization (the college radio), it wasn't an amateur project, but a professional one. This is true even if I'd rather cut my tongue instead of calling that guy a "professional"

    That's a bit black-and-white if you ask me. Yes, it was done for a business organization, but it was clearly not done by someone whose job description said "make websites". If I work as a programmer and my boss asks me to help him put together an IKEA desk, that doesn't suddenly make me a professional carpenter.

    I, too, have been there, when asked to make a simple site on a server that did not host any form of database. And I have also seen this kind of thing being taken much too far, with file-locks, editor interfaces and cobbled-together file indexing scripts to retain some semblance of sanity on the whole mess. It never works. But you only learn that after you try it. There is no shame in writing a system like this, only in maintaining it when you know better.
  • Coyne 2012-11-19 20:39
    My solution to a temporary PHP database was to store the data in .inc files: One page --> one folder --> one .inc.

    Now, unlike Chad, I know that is sub-optimal. Even if it did save a lot of up-front work; and require manual creation of each new .inc. But for an 11-page site, it works fine.

    But I planned ahead. When it comes time for a real database, the .inc design is formal enough to allow me to port the data to a database. Just one dumb little script to loop through all the folders, including each .inc in turn and inserting a row, and I'll be live.

    ...but I bet Kyle's problem will be a bit harder. After all, Chad knew his design was best because it was "invented here".

    At least Kyle's boss made the right decision.
  • bicj 2012-11-19 22:31
    Matthijs:
    Pista:
    Being done for a business organization (the college radio), it wasn't an amateur project, but a professional one. This is true even if I'd rather cut my tongue instead of calling that guy a "professional"

    That's a bit black-and-white if you ask me. Yes, it was done for a business organization, but it was clearly not done by someone whose job description said "make websites". If I work as a programmer and my boss asks me to help him put together an IKEA desk, that doesn't suddenly make me a professional carpenter.

    I, too, have been there, when asked to make a simple site on a server that did not host any form of database. And I have also seen this kind of thing being taken much too far, with file-locks, editor interfaces and cobbled-together file indexing scripts to retain some semblance of sanity on the whole mess. It never works. But you only learn that after you try it. There is no shame in writing a system like this, only in maintaining it when you know better.
    But an IKEA table is something that (theoretically) anyone with an allan key should be able to do.

    OTOH if you agree to cobble together ANYTHING I.T. (Website, min-app, Excel Macro, whatever) that is actually used by your work then when you say "Yeah, I reckon I could do that" you are basically claiming that you are able to produce something near-professional quality. If you're not, then you should point oput it's not your area of expertise.
    In the context, he was creating a (theoretically) useful system (not the boss's cousins third sons website) so if he didn;'t know what he was doing he shouldn't have done it.
    If my boss asked me to rewire the powerpoints in the building I'd be explaining to him that I'm not even remotely qualified to think about touching them.
  • Endurion 2012-11-20 02:18
    And thus Disqus entered the scene and f*cked up commenting...

    ...which delivers several WTFs on its own.
  • Cbuttius 2012-11-20 03:50
    Friedrice the Great:
    Remy Porter:
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.

    I didn't get paid when I worked in a college radio station. And we didn't have any computers in the station at all.

    Guess that makes me old, doesn't it?


    and what sort of bands were you playing at the time?
  • uns 2012-11-20 04:41
    For trolling I'll name my rock band "Y".
  • Fernie Canto 2012-11-20 06:19
    Why don't you write it in your BLAG? Hahaha LOL LOL LOL I'm definitely the best person in the world only because I know xkcd!

    Oh, wait! Wait! I have a better one! PHPTXTDB? Nah, not really into POKEMON! OH MY GOD I'M NEARLY DYING BECAUSE OF HOW AWESOME I AM. I am such a special, perfect angel for being so knowledgeable on all things xkcd, because no one else knows it. I go around all day quoting xkcd, but nobody gets it! OH GOD WHY DOESN'T ANYONE UNDERSTAND ME? They're all SHEEPLE, they are.
  • Martin 2012-11-20 08:00
    I look into sources of Wordpress once and in comparison with it the PHPTXTDB solution is clever thing!

    Wordpress is a nightmare, but it just works :)
  • JimLahey 2012-11-20 08:05
    I love WTFs like this. Not only needlessly reinventing the wheel but also unmitigated shite.
  • Bas 2012-11-20 08:17
    The real WTF is why they kept this system for so long rather than moving sooner.
  • one day late 2012-11-20 09:11
    Jeff:
    Yes but you're just one person; you don't expect the entire world to redesign its software systems just to accommodate you, do you?


    Say that to little Bobby Table.
  • JimLahey 2012-11-20 09:50
    It's because the people who usually have a say over this kind of thing will forgive most diseased piles of wank passed off as quality work so long as the money keeps rolling in.

    "But it works"
  • trtrwtf 2012-11-20 09:52
    Remy Porter:
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.


    Except for the good ones, that is. KRRC 4-evah!
  • Friedrice the Great 2012-11-20 18:27
    Cbuttius:
    Friedrice the Great:
    Remy Porter:
    College radio stations tend to be fairly professional organizations. It's not like it's some club that people do on the side- it's a job which people get paid for.

    I didn't get paid when I worked in a college radio station. And we didn't have any computers in the station at all.

    Guess that makes me old, doesn't it?


    and what sort of bands were you playing at the time?


    Led Zeppelin, Allman Brothers, Jefferson Airplane, Leo Kottke, lots of live recordings, etc. Basically, anything that wasn't Pop 40.
  • Shinobu 2012-11-21 08:17
    I don't understand what Kyle and Bill are complaining about. Have they never seen a CSV* file before?
    * cleavage-seperated values
  • Neil 2012-11-21 09:02
    I've actually had to do the delimiter dance. With real SQL too. No, I lie, it was MS SQL 2005, which conveniently can't parse CSV. Or at least, not the same CSV as products such as MS SQL 2000 and MS Excel 2000 parse.

    I guess I could have resorted to the Unicode character set, but as it happens it turned out that the data I was importing only used 94 of the 95 printable ASCII characters. Guess which one I chose for my delimiter.
  • Neil 2012-11-21 09:05
    Actually, now that I think about it, the delimiter was a comma, but in order to include a comma in data I needed a text qualifier, and MS SQL 2005 won't let me quote the text qualifier to use as part of the data, so I needed to use a character that wasn't in any of my data.
  • camelotbob 2012-11-21 11:16
    What college did you go to? Everybody at my college station did it for free for the experience.
  • Isaac 2012-11-21 21:07
    not frist at all:
    Jeff:
    Yes but you're just one person; you don't expect the entire world to redesign its software systems just to accommodate you, do you?
    I didn't even read the responses to this comment and knew it was some fag linking xkcd. It's not clever. It's not funny. The initial comment was all I needed to know that someone would link the cartoon where the parents iteratively one-up each other on how to screw the school system.

    It was funny to read when it came out. It's even funny when clicking on the Random button on the site and seeing it. It's NOT funny when someone links to it from a one-sentence post and thinks they're so fucking clever to have discovered xkcd.

    You probably still use lmgtfy and think you're so damn clever.

    It means in real life, you're an unoriginal hipster doofus.


    Got anything to do with sanitizing inputs to a SQL database, etc.? Link to Bobby Tables. Got a nerd-project slow-ass turing machine? Like a minecraft logic circuit from redstone? Link to the one where it's some guy alone in the world making a computer out of rocks. Got a story about password security or encryption? Link to the one where they beat the password out of the guy with a wrench.

    Fuck off. You're not clever.


    Whoa whoa whoa ragemonster... You don't have many real life friends do you?
  • Chris 2012-11-25 21:59
    The real WTF is that they replaced it with Wordpress.
  • Maltz 2012-11-27 18:07
    Justsomedudette:
    The real WFT good decision boss? Now that's a frist.


    It seems to me that most (not all, but most) bosses became bosses because they make GOOD decisions. I've found over the years - and I say this as an IT person - that disagreements between management and IT are often the result of either IT not fully understanding the full context of the business problem they're trying to solve (after all, the purpose of IT isn't IT for IT's sake - it's to make the business run more efficiently) OR an inability to explain in layman's terms a technical issue to management. It's all about communication.

    ...unless the boss is just an idiot. Sometimes that happens, too.

    (In this case, the Real WTF is the guy not bringing this issue to his boss' attention sooner with a solution in hand.)
  • Lloyd W 2013-08-13 12:55
    Wow, and I'm sat here as part of a team who runs one with no paid staff at all.