>>173I've been using the command line program, sqlite3, to browse. I haven't written a browser yet. There is another person that has scraped /prog/ and has written a browser. The db schema is a bit different, so some names would need to change in the program or the db. It would be nice to have a browser. And heck once the browser is there, you basically have a sqlite powered text board with all of /prog/'s old content.
My current browsing experience:
$ sqlite3 prog.dbsqlite> select * from threads order by lastbumptime desc limit 5;1396847195|J programming language |prog|2014-04-07 01:06|2014-04-07 11:44|2014-04-07 11:44|8
1396838670|teledildonics |prog|2014-04-06 22:44|2014-04-07 11:40|2014-04-07 11:40|9
1396882906|That was VIP quality! |prog|2014-04-07 11:01|2014-04-07 11:28|2014-04-07 11:28|2
1304381575|/prog/ Challenge #9002 |prog|2011-05-02 20:12|2014-04-07 11:24|2014-04-07 11:24|75
1339576156|An OPEN letter to Lambda A. Calculus |prog|2012-06-13 04:29|2014-04-07 10:42|2014-04-07 10:42|74
sqlite> select * from threads order by lastbumptime desc limit 5 offset 5;1396850495|Abelsons fat schlong |prog|2014-04-07 02:01|2014-04-07 03:00|2014-04-07 03:00|5
1360383053|The worst thread of all time |prog|2013-02-08 23:10|2014-04-06 23:10|2014-04-06 23:10|125
1396813424|Trying to get friend back into C++ |prog|2014-04-06 15:43|2014-04-06 21:06|2014-04-06 21:06|12
1369714221|Magical Computing |prog|2013-05-28 00:10|2014-04-06 20:58|2014-04-06 20:58|57
1396648721|4chan now supports video uploads |prog|2014-04-04 17:58|2014-04-06 18:40|2014-04-06 18:40|20
sqlite> select * from posts where threadid=1396847195;1396847195|1|Anonymous||| |2014-04-07 01:06|
J is one of the most widespread programming language with an insane level of difficulty that I personally have ever seen, not including esoteric programming languages (i.e. brainfuck, whitespace).<br/>
<br/>
Are there any languages that /prog/ has found to be widely deployed but insanely difficult to learn? inb4 ASM
1396847195|2|Anonymous||| |2014-04-07 01:23|
Programming languages are for faggots. Either learn circuits or fuck off.
1396847195|3|Anonymous||| |2014-04-07 08:17|
*bump*
1396847195|4|Anonymous||| |2014-04-07 10:44|
<a href="read/prog/1396847195/3">>>3</a><br/>
<i>bump my anus</i><br/>
sage
1396847195|5|Anonymous||| |2014-04-07 10:49|
<a href="read/prog/1396847195/2">>>2</a><br/>
Circuits are for faggots. Either learn physics or fuck off.
1396847195|6|Anonymous||| |2014-04-07 11:26|
Well, this thread went nowhere. Thanks fuckers.
1396847195|7|Anonymous||| |2014-04-07 11:30|
<a href="read/prog/1396847195/5">>>5</a><br/>
Physics is for faggots. Either learn pure mathematics or fuck off.
1396847195|8|Anonymous||| |2014-04-07 11:44|
<a href="read/prog/1396847195/5">>>5</a><br/>
circuits is physics, dolt
sqlite> select * from posts where threadid=1369714221 limit 5;1369714221|1|Anonymous||| |2013-05-28 00:10|
Would it be possible for a wizard to create a universal Turing machine that had an infinite amount of memory?<br/>
<br/>
Also, if we could master magic, do you think that it would be possible to create a separate pocket universe for a computer, that could perform exhaustive searches of an infinite problem space in a way that would seem instant when observed from this universe?
1369714221|2|Anonymous|mailto:sage|| |2013-05-28 00:17|
if we could master magic, computers would be boring as fuck
1369714221|3|Anonymous||| |2013-05-28 00:19|
<span class="quote">infinite amount of memory<span class="o"></span><br/>
infinite problem space</span><br/>
Ahmed is 5..4..3..
1369714221|4|Anonymous||| |2013-05-28 00:29|
infinite memory errors
1369714221|5|Anonymous|mailto:sage|| |2013-05-28 00:39|
Wouldn't it be interesting if we found a technique to do the latter.
sqlite> select * from posts where threadid=1369714221 limit 5 offset 5;1369714221|6|Anonymous||| |2013-05-28 00:41|
When the singularity happens (still waiting, Kurzweil and Kaku), I'm going simulate my own private universe where I am a cute little witch and wear cute Touhou dresses, but everyone else is normal. I'll give them hope, then crush their dreams right in front of them, keeping them in perpetual misery. I'll curse them with ambitions, but make those ambitions impossible to fulfill. I'll give them a good life, then smash them right in the middle, just to give them a taste of the happiness that they never have. I'll delude them into thinking that they are free, then reveal to them that they are only my slaves. I'll torture and kill them, just to resurrect them and do it again, until their mind is completely broken and there is no shreds of a human left in them, then discard them and move on to the next victim. I'll make Hell, and condemn those who resent my evil ways to eternal agony. I'll teach them concepts of justice just sneer in their faces as they try to reconcile my words with my actions. I'll reward those who emulate me with riches and power, and punish those who don't with starvation, sickness, and the death of those around them. I'll make them toil for their entire lives to build monuments to my vanity. I'll give them brief reprieves of love and contentment, then kill off everything they loved and leave them wondering what they did wrong.<br/>
<br/>
This will be a very fun and very intellectual game -- I am very much looking forward to it.
1369714221|7|Anonymous|mailto:sage|| |2013-05-28 00:50|
<a href="read/prog/1369714221/6">>>6</a><br/>
G-d is a little girl?
1369714221|8|Anonymous||| |2013-05-28 00:54|
<a href="read/prog/1369714221/6">>>6</a><br/>
You've got some pretty serious issues, YHWH.
1369714221|9|Anonymous||| |2013-05-28 00:58|
<a href="read/prog/1369714221/6">>>6</a><br/>
but once you get to wear the cute dress you would probably stop being angry and wanting to hurt people am I right?
1369714221|10|Anonymous||| |2013-05-28 00:59|
I'm no physician, but I'm pretty sure that quantum mechanics allows for this.
sqlite>