China Jails Woman for Internet Posting-Report

Grok Headline matches for China Jails Woman for Internet Posting-Report

China jails woman in porn crackdown

China jails woman in porn crackdown 08/16/2004 06:12 AM
'Lewd' shows a no-no

China jails Internet porn queen

China jails Internet porn queen 08/15/2004 03:04 PM
Hindustan Times Aug 15 2004 5:43PM GMT

China Arrests 11 Falun Gong Members for
Posting Torture Photos on Internet

China Arrests 11 Falun Gong Members for
Posting Torture Photos on Internet 12/31/2004 02:04 AM
Digital Chosun Dec 31 2004 4:39AM GMT

CHINA: woman jailed for internet porn
site

CHINA: woman jailed for internet porn
site 08/15/2004 11:14 AM
ABC Asia Pacific Aug 15 2004 2:38PM GMT

China jails dissident for spying

China jails dissident for spying 05/13/2004 12:29 AM
Prominent US-based Chinese democracy activist Yang Jianli is given five years for espionage.

China Jails U.S.-Based Activist Yang for
Spying

China Jails U.S.-Based Activist Yang for
Spying 05/13/2004 02:15 AM
Reuters via Wired News May 13 2004 6:33AM GMT

China Jails U.S.-Based Activist Yang for
Spying (Reuters)

China Jails U.S.-Based Activist Yang for
Spying (Reuters) 05/13/2004 02:20 AM
Reuters - China sentenced U.S.-based scholar Yang Jianli to five years in jail on Thursday for illegally entering the country and spying in a case that has triggered widespread criticism abroad, his lawyer said.

China end-June Internet users 87 mln, up
28 pct yr-on-yr - research report

China end-June Internet users 87 mln, up
28 pct yr-on-yr - research report 07/20/2004 07:38 AM
FXstreet.com Jul 20 2004 11:55AM GMT

China Has Shut Thousands of Internet
Cafes -- Report

China Has Shut Thousands of Internet
Cafes -- Report 05/06/2004 04:14 PM
Washington Post May 6 2004 8:32PM GMT

China launches website for people to
report 'unlawful' Internet content

China launches website for people to
report 'unlawful' Internet content 06/10/2004 01:03 PM
AFP via Yahoo! Jun 10 2004 5:37PM GMT

China denies Internet report of Ebola
deaths in south part of country

China denies Internet report of Ebola
deaths in south part of country 03/30/2005 07:22 AM
Canadian Press via Canada.com Mar 30 2005 10:53AM GMT

Vietnam jails internet activist

Vietnam jails internet activist 12/31/2003 02:39 AM
iafrica.com Dec 31 2003 1:04AM ET

Syria jails government critic over
'unlawful' internet use

Syria jails government critic over
'unlawful' internet use 06/21/2004 12:36 PM
Silicon.com Jun 21 2004 5:10PM GMT

Man arrested for subversive Internet
posting

Man arrested for subversive Internet
posting 02/18/2004 03:47 AM
CHINAdaily Feb 18 2004 7:42AM GMT

China to train first woman astronaut

China to train first woman astronaut 07/30/2004 01:29 AM
Content.sina.com - Thu Jul 29, 08:20 am GMT

Man arrested for posting subversive
messages on Internet

Man arrested for posting subversive
messages on Internet 02/17/2004 01:25 AM
Xinhuanet Feb 17 2004 5:32AM GMT

Onlines Grades - Internet Grade Posting

Onlines Grades - Internet Grade Posting 12/30/2004 07:37 PM
Online Grades Coming Soon!

How long is the average Internet
discussion forum posting?

How long is the average Internet
discussion forum posting? 03/17/2005 03:23 AM

A friend of mine who works at a database management system company asked for thoughts on how long a string a database table needs to be able to store, as a practical matter, to serve most Internet programming needs.  This prompted me to do some queries into the photo.net discussion forum.  Here's my message to him, which I thought would be interesting to nerd readers....

Three basic issues for Web development relating to varchar/clob:

1) Strings are uploaded from a browser-rendered TEXTAREA are of a length that is impossible for the programmer to predict. In a sense, then, every text slot in the database must be prepared to accept a string of arbitrary length. http://www.cs.tut.fi/~jkorpela/forms/textarea.html#brow serlimits reveals that some browsers have limits of 32K or 64K but that as Microsoft and Mozilla get more sophisticated these seem to be disappearing.

2) Software developers of Internet applications are often first-time SQL programmers and sometimes first-time programmers altogether. Unless a DBMS can make CLOBs work with every SQL function and command these novice programmers must learn a whole new computer language, essentially, to deal with CLOBs.

3) Internet applications are often developed using feeble ad hoc tools, such as PHP (my students in 6.171, MIT's Software Engineering for Internet Applications, mostly picked PHP to do their semester project even though I would have discouraged this, being a mistruster of thrown-together unnecessary new languages). Many of these tools don't have facilities for dealing with anything beyond the basic SQL data types so they couldn't use CLOBs if they wanted to.

I think for Web development it is reasonable to expect the average string length from the user to be 300 chars, despite wanting to be prepared for a maximum of 32K or even larger. Oops. Typing that prompted me to do the query (see below). Averaging 2 million messages on photo.net, the correct number is 425. The histogram query reveals that out of 2 million messages over a 10-year period a 32K limit would have resulted in 6 messages being rejected and a 16K limit something like 30 rejections.

If you wanted to implement something like Salon.com as a single RDBMS table for both articles and comments on articles I think a 64K limit might be required. If someone authors a 5000-word magazine article in Microsoft Word and then saves as HTML that will be 25-30k of content plus at least a factor of 2 in HTML tags and other Microsoft-added filler. http://www.photo.net/bboard/q-and-a-fetch-msg?msg_id=002oFh is an example of one of the big postings on photo.net. It is 37962 chars long, the HTML is very clean (i.e., much less filler than if saved by Word), and yet the page doesn't seem excessively long.

So... my conclusion from looking at the queries below is that 32K would do the job for a pure discussion forum system and that it would be marginal for storing articles unless a publisher decided that everything should be broken up into "part 1", "part 2", and "part 3". Looking at the .html files on photo.net, the vast majority are in fact under 32K and most are under 64K.

However, if you look at http://philip.greenspun.com/seia/ the largest chapters are 88.7k.

If you want to facilitate novice programmers building full-scale content management systems where all the content is uploaded from browsers it might be necessary to make the varchar datatype bloat up to 100k-ish. But 32K would be adequate to build something like eBay, amazon (user-uploaded content and much of the publisher content as well), or photo.net discussion forums.

----------- some stats from photo.net

select avg(dbms_lob.getlength(MESSAGE)),count(*) from bboard;

AVG(DBMS_LOB.GETLENGTH(MESSAGE)) COUNT(*)
-------------------------------- ----------
  424.672669  2052290

select round(dbms_lob.getlength(MESSAGE),-3), count(*)
from bboard
group by round(dbms_lob.getlength(MESSAGE),-3);

ROUND(DBMS_LOB.GETLENGTH(MESSAGE),-3) COUNT(*)
-------- ----------------------------- ----------
  0  1452035
1000 510236
2000  58330
3000  11972
4000 3399
5000 1303
6000  481
7000  264
8000  138
9000 93
10000 66
11000 38
12000 22
13000 21
14000 17
15000  6
16000 12
17000  9
18000 14
19000  4
20000  4
21000  1
22000  2
23000  1
24000  4
25000  3
26000  2
27000  1
30000  2
32000  1
33000  2
34000  1
37000  1
38000  1

Note:  Oracle did a much better job formatting these in SQL*Plus; for some reason the tabs didn't carry through after cutting and pasting.

------------------------------

Epilogue (not from my email to the friend):

Look how much fun it is to program SQL.  Three lines of code and you get an interesting answer (and those three lines would have been much cleaner and simpler if we hadn't been forced to use the CLOB datatype, which has its own strange accessor functions).  Compare to Java and C where typing until your fingers fall off usually doesn't result in much of anything.  SQL, Lisp, and Haskell are the only programming languages that I've seen where one spends more time thinking than typing.

Islamic Internet posting claims British
hostage has been killed

Islamic Internet posting claims British
hostage has been killed 09/26/2004 01:47 AM
eTaiwanNews.com Sep 26 2004 6:34AM GMT

Chinese worker detained for posting
articles, poems on the Internet

Chinese worker detained for posting
articles, poems on the Internet 12/20/2003 08:42 AM
AFP via Yahoo! Dec 20 2003 7:30AM ET

report from a 75-year-old woman who
visited Iraq

report from a 75-year-old woman who
visited Iraq 12/08/2003 05:45 AM
Mom on the front lines

tennessean.com/nation-world/archives/03/12/43731138.shtml?Elem ent_ID=43731138
track this site | 4 links

Girl accused of threatening to kill nine
students, posting list of targets on
Internet

Girl accused of threatening to kill nine
students, posting list of targets on
Internet 03/26/2005 07:20 AM
Financial Post Mar 26 2005 11:57AM GMT

Surrogate mother and husband charged in
child trafficking after posting baby on
Internet

Surrogate mother and husband charged in
child trafficking after posting baby on
Internet 02/01/2005 09:51 PM
China Post Feb 2 2005 1:48AM GMT

Police Say Woman Filed Fake Rape Report
(AP)

Police Say Woman Filed Fake Rape Report
(AP) 05/27/2004 09:31 PM
AP - A woman has been accused of filing a fake rape report so her airman boyfriend could get emergency leave to return to the United States from Korea so they could be married.

Report: Black Woman Says She's
Thurmond's Child

Report: Black Woman Says She's
Thurmond's Child 12/14/2003 01:44 PM
Reuters via Wired News Dec 14 2003 12:42PM ET

Woman Files Fake Report in Order to
Marry (AP)

Woman Files Fake Report in Order to
Marry (AP) 05/27/2004 07:43 PM
AP - A woman has been accused of filing a fake rape report so her airman boyfriend could get emergency leave to return to the United States from Korea so they could be married.

BAMBI FRANCISCOHedging your netsWith
Internet stocks posting impressive gains
for 2004, next year may be the t

BAMBI FRANCISCOHedging your netsWith
Internet stocks posting impressive gains
for 2004, next year may be the t 01/04/2005 04:21 AM
CBS MarketWatch Jan 4 2005 8:50AM GMT

BAMBI FRANCISCOHedging your nets With
Internet stocks posting impressive gains
for 2004, next year may be the

BAMBI FRANCISCOHedging your nets With
Internet stocks posting impressive gains
for 2004, next year may be the 12/29/2004 08:44 PM
CBS MarketWatch Dec 30 2004 12:40AM GMT

CHINA: China issues more internet
regulations

CHINA: China issues more internet
regulations 06/22/2004 01:09 AM
Asia Media Jun 22 2004 5:14AM GMT

Hedging your netsWith Internet stocks
posting impressive gains for 2004, next
year may be the time to hedge so

Hedging your netsWith Internet stocks
posting impressive gains for 2004, next
year may be the time to hedge so 01/04/2005 04:21 AM
CBS MarketWatch Jan 4 2005 8:50AM GMT

Hedging your nets With Internet stocks
posting impressive gains for 2004, next
year may be the time to hedge s

Hedging your nets With Internet stocks
posting impressive gains for 2004, next
year may be the time to hedge s 12/29/2004 08:44 PM
CBS MarketWatch Dec 30 2004 12:41AM GMT

BAGHDAD, Iraq (AP) - A posting on an
Islamic Internet site Saturday claimed
that an al-Qaida-linked group has

BAGHDAD, Iraq (AP) - A posting on an
Islamic Internet site Saturday claimed
that an al-Qaida-linked group has 09/25/2004 09:55 AM
940 News Sep 25 2004 2:14PM GMT

Report: China Firm Plans 3,000 Net Cafes
(AP)

Report: China Firm Plans 3,000 Net Cafes
(AP) 09/15/2004 01:38 PM
AP - China's second-largest mobile phone company plans to open 3,000 Internet cafes by the end of the year, exerting stronger state control over a sector once dominated by private enterprise, state-run radio reported Tuesday.

Report: China Hosts Most Spam Websites

Report: China Hosts Most Spam Websites 05/04/2004 09:15 AM

Report: Japan, China, S. Korea
developing next Net

Report: Japan, China, S. Korea
developing next Net 12/30/2003 06:32 PM
The countries are reportedly planning to jointly develop Internet Protocol version 6, the next-generation Net standard, challenging the U.S.-dominated market for current IPv4-based Net tech.

China will issue 3G licenses in 2005 -
Interfax 3G report

China will issue 3G licenses in 2005 -
Interfax 3G report 06/18/2004 07:48 AM
Interfax Information Agency Jun 18 2004 12:15PM GMT

Siemens mobile phones to go on sale
throughout China: report (AFP)

Siemens mobile phones to go on sale
throughout China: report (AFP) 05/01/2004 05:13 PM
AFP - The German technology giant Siemens is poised to sign a deal with China which will allow it to sell its mobile phones throughout the country, it was reported.

Report: Japan, China, South Korea
developing next Net

Report: Japan, China, South Korea
developing next Net 12/30/2003 06:27 PM
ZDNet Dec 30 2003 6:10PM ET

New China Online Game Report Promises
Growth

New China Online Game Report Promises
Growth 04/03/2005 09:38 PM
ChinaTechNews.com Apr 4 2005 12:53AM GMT
Grok Description matches for China Jails Woman for Internet Posting-Report
GrokA matches for China Jails Woman for Internet Posting-Report

China Jails Woman for Internet Posting-Report

The following phrases have been identified by the grok system as matching this entry: