Wikipedia:Reference desk/Computing

Welcome to the computing section
of the Wikipedia reference desk.

skip to bottom

Select a section:

• Computing
• Entertainment
• Humanities
• Language
• Mathematics
• Science
• Miscellaneous
• Archives

Want a faster answer?

Main page: Help searching Wikipedia

   

How can I get my question answered?

• Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
• Post your question to only one section, providing a short header that gives the topic of your question.
• Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
• Don't post personal contact information – it will be removed. Any answers will be provided here.
• Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
• Note:
  • We don't answer (and may remove) questions that require medical diagnosis or legal advice.
  • We don't answer requests for opinions, predictions or debate.
  • We don't do your homework for you, though we'll help you past the stuck point.
  • We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.

Ready? Ask a new question!

How do I answer a question?

Main page: Wikipedia:Reference desk/Guidelines

• The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.

See also:

• Teahouse
• Help desk
• Village pump
• Help manual

February 24

organizational chart

Hi. I've been tasked with producing an organizational chart with photos and titles and positions of about 40 people. What free software would be good for this? The structure is quite complex. I am familiar with inkscape, but this doesn't seem quite the right tool. I am learning to use scribus, but this isn't quite right either. Can anyone advise? Robinh (talk) 06:36, 24 February 2012 (UTC)

OpenOffice.org Draw is a free software tool for creating structured drawings. It has a user interface that I would describe as "half way between Microsoft Visio and PowerPoint." There are plenty of other options; you can draw things in GIMP, but it's probably not the tool you'd use for an org-chart. We have a List of concept- and mind-mapping software, including some with nice graphical features. FreeMind can be used to draw tree-like structures very quickly and easily, with some limitations on the layout. Nimur (talk) 08:06, 24 February 2012 (UTC)

I've used a web app site called LucidChart to create organizational charts before, and it works pretty well. 192.84.79.2 (talk) 11:32, 24 February 2012 (UTC)

thanks guys. I didn't kno about either of these suggestions. best wishes, 222.153.61.63 (talk) 04:24, 25 February 2012 (UTC)

Notable Wikipedians who are regular contributors or administrators?

So I was just wondering if there are any notable Wikipedians who regularly spend their time contributing to the encyclopedia at present, has rights such as rollback, account creator etc. or is even an administrator. It's unlikely there are any but I would still like to know. Narutolovehinata5 ^tccsdnew 14:02, 24 February 2012 (UTC)

You can look through Wikipedia:Wikipedians with articles; you'll need to use other tools to see who has what rights, and use your own standards for who really passes for notable. -- Finlay McWalterჷTalk 14:10, 24 February 2012 (UTC)

There are some known ones (an old category Category:Notable Wikipedians now redirects to another one). There are probably also some unknown ones contributing anonymously. 67.117.145.9 (talk) 16:41, 24 February 2012 (UTC)

I consider many of the contributors on the list of reference-desk regulars to be "notable." For some of our more prolific contributors, I can often identify who the author was (by tone and style), long before I scroll down to their signature. I'd say that any author skilled enough that their voice is distinctive counts as "notable" in some contexts. (I would not use this as a criteria for Wikipedia article space inclusion, where we have a more stringent set of criteria). Nimur (talk) 17:55, 24 February 2012 (UTC)

I meant notable Wikipedians, as in those Wikipedians who are at Wikipedia:Wikipedians with articles. Are there any examples? Narutolovehinata5 ^tccsdnew 23:40, 24 February 2012 (UTC)

User:Jimbo Wales, of course. →Στc. 03:01, 25 February 2012 (UTC)

Aside from Jimbo, of course. Narutolovehinata5 ^tccsdnew 03:14, 25 February 2012 (UTC)

The only one who I know off the top of my head is Cory Doctorow but I don't know if he contributes to anything outside his own article and those of his books and work. Might be worth a look though. Dismas|^(talk) 03:18, 25 February 2012 (UTC)

User:MGodwin, legal counsel for the WMF. →Στc. 04:27, 25 February 2012 (UTC)

Anyone aside from Jimbo or anyone Wikipedia-related. Not even Angela or Larry. Narutolovehinata5 ^tccsdnew 04:33, 25 February 2012 (UTC)

Elonka Dunin is the only one I can think of right now. sonia♫ 04:59, 25 February 2012 (UTC)

Does that mean you want to exclude anyone who got involved in the WMF after they were prolific editors (and quite a while after the founding)? If so, what sort of level? Do you include arbcom? Oversighters? Checkusers? While these people will generally be selected by the community there's also some WMF involvement. Nil Einne (talk) 19:32, 25 February 2012 (UTC)

MGodwin hasn't been legal counsel for a while (resigned in October 2010), see Meta:General Counsel. Geoff Brigham has been the counsel since 2011 and is currently a redlink Nil Einne (talk) 19:32, 25 February 2012 (UTC)

There are several more that I know of, but I don't feel comfortable naming them. 67.117.145.9 (talk) 05:28, 25 February 2012 (UTC)

Here are a few that I noticed.

• Admins:
  • Arthur Rubin (talk · contribs · blocks · count · rollback · admin · logs) (Arthur Rubin)
  • SimonP (talk · contribs · blocks · count · rollback · admin · logs) (Simon Pulsifer) - The ultimate in notable Wikipedians. He's notable because he edits.
  • Michael Snow (talk · contribs · blocks · count · rollback · admin · logs) (Michael Snow (attorney))

• Rollbackers:
  • Snowded (talk · contribs · blocks · count · rollback · admin · logs) (Dave Snowden)
  • Jokestress (talk · contribs · blocks · count · rollback · admin · logs) (Andrea James)
  • Sue Gardner (talk · contribs · blocks · count · rollback · admin · logs) (Sue Gardner)
  • William M. Connolley (talk · contribs · blocks · count · rollback · admin · logs) (William Connolley) - was an admin at one time.

No doubt there are others but those are the names that jumped out at me. Not sure if they are all current contributors or not. CambridgeBayWeather (talk) 11:58, 25 February 2012 (UTC)

Word - Libreoffice conversion

Is there someplace to find answers to questions of this sort:

In Microsoft Word I can use "XXX". Is there an equivalent thing to use in LibreOffice?

For example:

In Microsoft Word I can use ^p in a find and replace command to represent a paragraph mark (eg, to replace commas with paragraph marks). Is there a way to do this in LibreOffice?

Thanks, Wanderer57 (talk) 22:14, 24 February 2012 (UTC)

Though not official, a quick Google revealed [1]. Though I suppose you might be looking for something like an FAQ of how-to's. --Melab±1 ☎ 00:43, 25 February 2012 (UTC)

Thank you Melab-1. In my limited experience of LibreOffice, unofficial seems more useful than "official". Following your lead, I got to a wiki where my specific question was answered, at this URL:

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Writer#Positional_match_.5E__.24__.5C.3C__.5C.3E

I am including this URL in case someone else looking for the same information arrives here. I gather the mechanism of "find and replace" in LibreOffice is more complicated and, if one understands it, more useful than in Word. Wanderer57 (talk) 02:55, 25 February 2012 (UTC)

You might find this useful (official) if you are interested in special find and replace functions. SmartSE (talk) 17:23, 26 February 2012 (UTC)

February 25

Shell script that prints a file tree to the screen

What would a shell script designed to print out a file tree like this look like?

/
  directory1/
    subdirectory1/
    file1
  directory2/
  file1

--Melab±1 ☎ 00:40, 25 February 2012 (UTC)

ls -R might be what you're looking for. RudolfRed (talk) 00:55, 25 February 2012 (UTC)

No, I need the script to format exactly as I gave the example. I would think sed and grep would be used. --Melab±1 ☎ 01:30, 25 February 2012 (UTC)

Use

find

and then pipe it to a script that counts the number of forward slashes, then tab x the number of forward slashes and print it. Broba (talk) 02:09, 25 February 2012 (UTC)

There's probably one named tree in your distro's repos. ¦ Reisio (talk) 02:54, 25 February 2012 (UTC)

Tree (Unix) - which also give examples of how to do it with ls, grep, sed. Mitch Ames (talk) 02:32, 26 February 2012 (UTC)

flush disc cache in Windows 7

Is there a way to flush the disc cache in Windows 7 without rebooting? I searched and found a program called flushmem.exe, but it did more than flush the disc cache and it locked up my system. I saw references to a program called sync, but the links to it were dead. Bubba73 ^{You talkin' to me?} 00:45, 25 February 2012 (UTC)

It's here now. -- BenRG (talk) 06:18, 25 February 2012 (UTC)

When I was searching, that program came up. But I just tried it and it either doesn't work or doesn't do what I need. It says that it causes things in the disc buffer to be written out. What I need is sort of the opposite. After I read a disc file, it is still in the disc cache - I need to remove it from the cache so it has to actually read from the disc the next time. Bubba73 ^{You talkin' to me?} 16:36, 25 February 2012 (UTC)

These guys say no and they know far more than I do.[2] Thincat (talk) 23:17, 25 February 2012 (UTC)

They mention a program to use up the RAM. I can write a program to use of the RAM and then release it - that should make it give up what is in the disk cache. Bubba73 ^{You talkin' to me?} 00:41, 27 February 2012 (UTC)

I found out that with an external HD, unplugging the USB cable and plugging it back in does it. That is a lot faster than rebooting. Bubba73 ^{You talkin' to me?} 01:10, 27 February 2012 (UTC)

That's good to know. I am glad you have found your own solution. Thincat (talk) 00:07, 28 February 2012 (UTC)

Set to Terminal to run a custom command and now it closes every time

How do I fix this? I am running Ubuntu 11.10, which means there is no gconf-editor that I can use. --Melab±1 ☎ 01:27, 25 February 2012 (UTC)

Does it close right after running the command ? Do you type the command directly into the window ? StuRat (talk) 01:30, 25 February 2012 (UTC)

If the problem is in gnome-terminal, and not in your shell, you can start a shell in a different terminal. You can enter console mode by pressing "Ctrl + Alt + F1", giving you a video-mode console. You could start xterm or konsole, if you have either of those installed on your system. You could start nedit or gvim, text editors which allow you to execute shell commands (by spawning bash internally, usually). The best solution is going to depend on exactly what is broken; can you elaborate? Nimur (talk) 01:37, 25 February 2012 (UTC)

Ubuntu 11.10 uses Unity. Anything you have to say about Gnome does not apply. --Melab±1 ☎ 02:02, 25 February 2012 (UTC)

Your Terminal application in the Unity environment is still "gnome-terminal." Even when Unity is installed, you can run the GTK and KDE shared libraries; and you can run native Linux graphical user interface applications that communicate straight to the X11 server. And, you can even switch to console mode, leaving behind X and Unity. With due respect, Melab, everything I said above does apply. Have you tried it yet? Nimur (talk) 02:58, 25 February 2012 (UTC)

I think I know what the poster means by "a custom command". Use one of the techniques shown above to get to a command line, but don't use the Ctrl+Alt+F1 method because that won't work for our purposes. If you can't get to a command line any other way, press Alt+F2. Now enter this code: gnome-terminal -e bash. Yes I'm aware that you're using Unity; enter the code anyway. Now your normal terminal should pop up. Go to the settings for your profile (Edit -> Profile Preferences -> Title and Command) and uncheck the box that says "Run a custom command instead of my shell". You're done. --NYKevin @285, i.e. 05:50, 25 February 2012 (UTC)

Norton product differences

What exactly is the difference between Norton 360, Norton AntiVirus, and Norton Internet Security? I looked at each article, and while it looks like 360 is AntiVirus + Backup + Firewall, I'm a little unclear if that's it, or the differences between the others. A handy comparison chart would be ideal. Any help is appreciated. Broba (talk) 02:00, 25 February 2012 (UTC)

I'm inclined to consider it mostly marketing nonsense, but if you look at the first paragraph of Norton 360 there is a clue at least to that one's distinct attributes. ¦ Reisio (talk) 02:59, 25 February 2012 (UTC)

AntiVirus is an antivirus program and also includes email filtering and phishing protection. Internet Security includes this and adds a firewall. 360 adds a backup to those. If you're non-commercial, all these are available from Windows for free (firewall is built in to XP SP2 and later, MSE provides antivirus and there are numerous 3rd party free antivirus solutions, and backup I think has been part of Windows for a long time). I'm not sure if there are free anti-virus solutions for commercial users. Norton has the advantage of being a well-known and fairly well-trusted name, but with a reputation for being a bit of a resource hog.-gadfium 08:02, 25 February 2012 (UTC)

Lustre is slow

I am doing work on a shared scientific computing cluster that uses Lustre (file system) to supply a 200 TB file system. I find that this system is often slow, and in particular exhibits high latency such that basic operations, such as listing a directory, sometimes pause for several seconds. Such pauses are annoying, but more significantly I routinely need to write large data sets to this system (e.g. 5 GB of data distributed in ~25 files) and such an operation will often take a few hours to complete. A comparable operation on a modern desktop will often complete after a few minutes.

I suspect it is a long-shot to get useful advice here, but I'm wondering if anyone here has experience with such systems. Is there a way for me (as a basic system user with no admin privileges) to optimize or structure my file system needs to get better performance? Dragons flight (talk) 07:47, 25 February 2012 (UTC)

why don't you tell THEM (whoever supplies you, whoever is the actual admin) about these problems. They might not be aware of it. It could be something simple to fix, like a rogue process, a reboot, failed hard-drive(s) that haven't been replaced, whatever. Tell them about it. --80.99.254.208 (talk) 09:34, 25 February 2012 (UTC)

As you suspect, the odds of finding someone regular enough at the RD who works with Lustre are quite low... have you considered asking on some of the forums/irc channels devoted to Lustre development? Those people will notn only be familiar but have some in depth technical knowledge too... I know that's kind of a non answer but I bet you'd get faster traction there. Also as the IP says, if you don't have root then I doubt even if we could find you the perfect solution, you're authorized to implement it.

I've never used it so I'm just shooting in the dark here, but I believe the underlying machines have a traditionally formatted storage device... it's quite possible 1 node is slowing down everything else. Shadowjams (talk) 20:48, 26 February 2012 (UTC)

android phone as a radio scanner

logan........... i have been working upon the major project for my IT b.tech for quite a time and i came upon this idea....i searched the internet quite hard but could not find a suitable answer...."my question is as follow:: we all know that our normal phone works by hooking up to a particular frequency upon which we make our call..and also it recieves a call because of some handshake which goes on before recieving call..in other words our phone is basically a scanner because it scans for a particular frequency...but the irony is that it is so designed just to search for a particular frequency or perhaps respond to a particular signalling information so that it can recieve a call...i chose an android phone because it is easily available in the market and is software defined as we all know it is upgradable...so can we over-ride the already existing software with another software and make it a small portable short distance radio scanner with the addition of some hardware.....and can we manipulate the phone somehow that the input be given from a computer keyboard and viewed on a monitor but the processing unit be the android phone..--122.168.56.118 (talk) 08:13, 25 February 2012 (UTC).....

The software for the radio modem in a modern phone is generally a binary blob (often for a dedicated coprocessor, rather than the main application CPU). This kind of low-level radio tweaking isn't part of the iOS or Android APIs, so if you wanted to mess around with this stuff, you'd have to get a system image (maybe from a system update), reverse engineer that (which might be difficult, as it may be encrypted), find the firmware image in there (if there is one; the firmware will be reasonably stable, and may not be updated each time) and then reverse engineer that. And you have to worry about the communication laws of your country - most countries regulate what you can send, and some what you can receive in the mobile phone band. If you want just to mess around with software defined radio, GNU Radio is a much easier and more open environment in which to work. -- Finlay McWalterჷTalk 11:05, 25 February 2012 (UTC)

Furthermore, mobile telephone radios are quite limited in terms of the RF spectrum. They have hardware that is specifically designed for receiving and sending data on standard telephone and mobile data networks. If you. ever played with a HAM base station, you've been quite spoiled: you can set your frequency, modulation parameters, power, and so forth; you can mix an arbitrary baseband signal on to your carrier, and (licensing issues aside), transmit and receive whatever you want, whereever you want. In a mobile telephone, the amplifier bandwidth, hardware modulation/demodulation,, and antenna matching (among numerous other technical details) are not designed for general purpose RF experimentation, so you won't be able to dial in to an arbitrary band and receive intelligible signal or data. This is to say nothing of the digital encoding and keying schemes in use today - even within the bands the telephone's radio can receive, there are a lot of details that make generic signal production or interception very impractical. Have a look at digital radio and software-defined radio. I think you may have a lot of work to get up to speed on the complexities of modern digital wireless telephone service. Regrettably, this field is neither cheap nor easy for the hobbyist/skilled technical enthusiast. Consider looking into buying a commercial telephony signal analyzer, for example the GSM software package for the PXI series VNAs. As you can see, a considerable amount of expensive hardware (several hundred thousand dollars) is required. It is, in general, prohibitively difficult to do this sort of RF work on modern systems without the assistance of a major engineering company. Perhaps you can get in touch with such a business and work out an internship or academic cooperative. Nimur (talk) 19:10, 26 February 2012 (UTC)

constitutional operating system

has anyone ever advanced the idea of a constitutional operating system? At the moment, it seems that the ultimate owner of the physical computer can do whatever they want on it. No matter what a program does, it would never have to answer to a judge program, nor is there a code of laws that a judge would judge program behavior by. Antivirus programs come close, but these are like mercenaries -- they're not part of the sovereign system. The sovereign system seems like a dictatorship.

Has anyone ever proposed a constitutional operating system, such that there were limits on what the operating system itself could do, in the interest of programs, who would be able to appeal to a judge program? Sorry, I'm not terribly versed in operating system design, but it just seem like it's still back in the dark ages and has never really had an enlightenment in this regard. --80.99.254.208 (talk) 12:01, 25 February 2012 (UTC)

I don't understand quite what you want. But I wouldn't say that there aren't limits on what the OS can do. For example, it cannot upload all your data to a home computer somewhere without your authorization. The ideal case of a good OS is that the user is at the command. XPPaul (talk) 13:27, 25 February 2012 (UTC)

I think you are stretching an analogy well past breaking point. 131.111.255.9 (talk) 15:44, 25 February 2012 (UTC)

I already have enough problems arguing with "windoze" over what I want it to do, without giving it constitutional rights to argue back! Dbfirs 17:52, 25 February 2012 (UTC)

About the "ultimate owner of the physical system can do whatever they want" ... this is what DRM attempts to defeat, and the result is either ineffective DRM or a broken system (or both). But the rest of what you say sounds unrelated. In any event, the OS is by definition whatever has ultimate control over the system resources, which include the internal "security-like" mechanisms like protected memory and rings.

The real problem is that security mechanisms don't offer fine-grained control in the terms that people are interested in. For example, I'm not really concerned with which programs manipulate my photographs, but I might object if my browser secretly unchecked a "keep this album private" option. This kind of stuff is much harder to control in a meaningful way, but it's an area of ongoing research in security and programming languages and operating systems. I'm not an expert in this area at all, but we're probably decades away from good comprehensive solutions being actually implemented in consumer systems. Paul (Stansifer) 18:45, 25 February 2012 (UTC)

There may be a more useful way of looking at the premise: Maybe humans' constitutions and laws are our sloppy, pathetic way of trying to approach the awesomeness of a quality operating system. Operating systems can let the user provide an absolute restriction on a particular directory such that, say, Firefox can't access anything in there at all. At all! Our laws wish they could do this. Instead, people buy locks for their doors and make governments that have to provide police and courts and punishments and constitutions in a hacked-together attempt to stop people from doing bad stuff. Comet Tuttle (talk) 21:42, 25 February 2012 (UTC)

“it seems that the ultimate owner of the physical computer can do whatever they want on it. ” This depends on what operating system you use. As Dbfirs hints at. Microsoft software tends to only let you use you computer (that you own) in ways that only Microsoft approve of – which in practise means you have pay them for the privilege of letting 'your computer' do what you want it to do. Its a great business concept – I wish I had thought of it. Just think of buying a car and only being able to drive down roads that another company lets you. --Aspro (talk) 22:04, 25 February 2012 (UTC)

You might like the book Code and Other Laws of Cyberspace, though its concept is different from what you're describing. The E programming language had the concept of ERights and I half-remember an associated notion of an economy between programs (I never used that language), but the article describes it mostly as capability-based security which was a pretty standard concept. WP also has a bunch of articles about the Actor model of programming, though beware, they are written mostly by the concept's inventor and they are often biased or distorted. 67.117.145.9 (talk) 02:47, 26 February 2012 (UTC)

If I understand the OP correctly, DOS was that way. DOS got the program started then it stayed out of the way until either the program called on it for something (like input/output) or the program ended. Windows gets in the way of any program. Bubba73 ^{You talkin' to me?} 03:42, 26 February 2012 (UTC)

I disagree with that assessment. In a modern system, the OS is only even running code at all (a) during context switches, to hand off control between threads, and (b) when a program asks it for something. The only difference is that DOS was missing part (a). The OS may impose some security restrictions (which could be disabled, but no one wants that). Now, the Windows user interface is pretty intrusive to the user, but that's a problem about the relationship between the Windows shell (which is just another program) and the user, not between Windows kernel and programs. Paul (Stansifer) 18:17, 26 February 2012 (UTC)

A small digression: the reason we like Constitutions and democracy and whatnot in government is not because they are efficient, guarantee good results, or make everything function well. We like them because dictators usually are not benevolent. (And even if one dictator is benevolent, there is no guarantee that his or her successor will be.) If we could trust dictators to somehow, magically, be compelled to do only what would somehow balance all of the needs, resources, and values of the people to maximum efficiency, we wouldn't need something as clunky as a constitution or courts or, god forbid, a legislative branch. Now I just don't see the compelling reason to want a more democratic operating system. What's the goal, here? What's the wrong to be righted? How would such a system actually produce better output? It sounds like it would be more inefficient than the current version, and more unpredictable, with no positive gains. --Mr.98 (talk) 03:59, 26 February 2012 (UTC)

Maybe not to you, but what about to programs? Right now, a user has the right to terminate a program at will, and the Operating System most certainly has this right. I envision a constitutional operating system where a program could protest that it should not be terminated. You are thinking in terms of users, but I'm thinking in terms of the rights of programs. Why shouldn't programs be given rights? --80.99.254.208 (talk) 14:50, 26 February 2012 (UTC)

Operating systems and all other software do not (as yet) exhibit the characteristics of Sentience – they are just math. Unless of course you're Microsoft that wants to own the un-ownable. Would you hold a funeral service for your slide rule when it slips no more and the cursor comes to is final resting place? Mind you, the do come in handy, on their eventual demise, for marking where exactly you planted those sweet peas in the garden.--Aspro (talk) 17:16, 26 February 2012 (UTC)

Computer multitasking#Cooperative multitasking/time-sharing was in some ways giving the programs 'rights'. You can see how well it worked... In any case as others have said you seem to be anthomorphising computers too much. If you really want to use your analogy, in reality, both programs and computers are in most regards the 'slaves' of the administrators. Few people want programs that refuse to terminate when you tell them to because they have 'rights'. (And if you've used a Windows and a large variety of third party programs enough, you've probably encountered the problem when kill process doesn't actually kill the process.) People may voluntarily accept limitations in some cases if they feel they improve things, but it's not clear what benefit there is to have a third 'party' resolving 'disputes' between OS and program. It seems liable to be an unnecessarily complex addition liable to cause more problems then it prevents. People make computers and all the programs on them so they work for the people using them, not so they can stage an uprising because you're violating their rights. Nil Einne (talk) 18:04, 26 February 2012 (UTC)

Generally speaking, we don't give abstract rights to things which are not empathic — things that don't feel. (There are some exceptions — e.g. comatose patients — but programs don't fit under any of them.) It's possible that in the far future we could have programs that qualified as that (Gibson's Neuromancer is a pretty classic sci-fi reference.) But at the moment there's nothing even close to that. So programs don't have rights. Neither does your carpet, or your shoes, or your tomatoes, or your books, or your pests. (Some insects are accorded certain rights if they are endangered. Many larger animals have some form of limited rights given to them. Many do not.) --Mr.98 (talk) 02:12, 27 February 2012 (UTC)

To the OP: Tron was not a documentary :-) --Trovatore (talk) 04:05, 26 February 2012 (UTC)

The original question uses some altogether silly terminology, but the concepts are actually pretty important. There are a lot of scenarios where the owner of a computer system is not the operator. For example, consider "cloud computing" Service Level Agreement systems, where a hosting company permits an end-user to run a program with guaranteed privileges. If the hardware or low-level software fails, the system owner is obligated to roll over to new hardware (usually aided by virtualized resources), guaranteeing that the program will continue to run and meeting the contractual uptime and availability requirements. A program protected by a service-level agreement has a pre-agreed, guaranteed "right" to run, enforced by hardware and software technology; and backed up by a human business obligation with real financial consequences.

There are other cases where a system owner (say, your corporate employer) wants to control what tools and software you may run on their hardware. Or, a server administrator wants to make sure that the un-monitored systems are behaving properly. This is the realm of trusted computing and hardware/software authentication. Only privileged programs are whitelisted and permitted to run.

The Unix operating system, and many others like it, rigidly enforce rules about shared resources: system CPU time, file and I/O access, user access rights, and so forth, are carefully monitored. If a program is authorized to run with superuser privileges, it is guaranteed to be permitted certain operations - for example, to terminate other programs or to steal I/O hardware access away from other unprivileged programs. One might say that the entire purpose of a modern multi-user, multi-programming operating system is to lay out and enforce the rules for sharing access to a system. Nimur (talk) 18:41, 27 February 2012 (UTC)

The OP is probably unfamiliar with the relevant terminology. You're looking for something along the lines of Access control list and Filesystem permissions. The OS can do whatever it wants (with some restrictions such as flashing hardware with unsigned firmware images) and the user is in control of the OS. The user's control is limited by their technical prowess (and certain difficulties imposed by the OS as in Windows). You can limit/control access through virtualization and certain abstractions. The .Net Framework has Code Access Permissions. Additionally, manifests can be used to restrict/grant access for Windows programs.Smallman12q (talk) 13:27, 29 February 2012 (UTC)

Can DokuWiki indentation?

MediaWiki can use ":" like:

MediaWiki

Produced by WikiMedia

How to do this in DokuWiki?--铁铁的火大了 (talk) 13:27, 25 February 2012 (UTC)

If the purpose of the indentation is to show the relationship of comments and replies, as is most usually used here (for example, I have indented this paragraph for that reason), then the corresponding function in DokuWiki uses the greater than character (>) rather than the colon. However, this is not represented onscreen in the same way as MediaWiki's indentation (I actually think Doku handles it better). If you are looking to produce the same onscreen results, then according to the page I linked it doesn't seem possible using only their own markup. AJSham 19:10, 25 February 2012 (UTC)

buzzing power adapter

I have an older Netgear router with a largish (as such things go) power cube, that recently has started making an annoying buzzing noise (fairly low frequency). It stops when I press down on a certain spot on the outside of the cube, suggesting some adhesive or something has loosened up just underneath that spot, allowing a component to vibrate. Any idea if 1) it's possible to fix a thing like that, 2) whether continuing to use it is a likely significant safety hazard (e.g. it might catch on fire) rather than just an annoyance? Thanks. 67.117.145.9 (talk) 23:09, 25 February 2012 (UTC)

You could go to a local hardware store and buy an appropriately sized clamp to hold the power cube where it vibrates, thus keeping it from vibrating. That doesn't fix it but it would keep it from buzzing. Dismas|^(talk) 02:37, 26 February 2012 (UTC)

Thanks, I might try that, though having a clamp around the cube while it's plugged in will be a bit awkward. I was thinking more in terms of opening it up and re-glueing whatever is loose. Well I was thinking of replacing the router anyway, in favor of a fancier one, so maybe this cube issue will help things along. 67.117.145.9 (talk) 06:16, 26 February 2012 (UTC)

The buzzing probably won't generate enough heat for it to catch fire. Also, can't you tell if it's getting hot by touching it ? This could be an indication that it's likely to fail soon, though. The vibration can't be good for it, but, in any case, once one part of it fails (the adhesive), that probably means it has reached the lifespan for which all the components were rated. So, having a spare ready to go might be a wise choice. StuRat (talk) 07:06, 26 February 2012 (UTC)

Thanks, yeah, you're probably right, and I wonder where to even get a spare P/S. I guess I could call Netgear tech support. I never really noticed the size of the brick before--the router is a relative power hog by today's standards. The P/S isn't warm but the router itself does get pretty warm. I've opened another thread about picking a replacement router. 67.117.145.9 (talk) 10:05, 26 February 2012 (UTC)

February 26

Need router

I want to replace my old Netgear router with one that can run FOSS firmware like Tomato/DD-WRT/OpenWRT. It should have wifi since I occasionally have visitors who want wireless internet access, but most of the time I'd want to run it in wired mode with the radios turned off. It would be very useful if I can activate and de-activate the wifi without resetting the router and dropping all the existing ethernet sessions. Is that a standard feature these days? My existing router reboots itself after any configuration change.

I see Newegg has the classic Netgear WRT-54GL and the newer WNR3500L-100NAS on sale for just a bit more $$$. I think I don't really care about super-fast wireless modes because for my purposes, wifi is for web surfing and therefore the wifi's useful speed is bounded by the WAN. But the WNR3500L's gigabit ethernet capability would be useful (the 54GL just has 100Mbit) and it's a more powerful box in general. OTOH, the 54GL is quite old yet still extremely popular, and I'm a bit suspicious of newer stuff due to a perception of declining build quality as costs have been reduced, so I'm not sure what to do.

Any advice? I suppose what I really want is something like a Soekris box but I don't want to spend that much or spend a lot of time configuring it. I also don't want to use any PC-like devices with cooling fans. I'm basically left with this Netgear stuff.

Thanks.

67.117.145.9 (talk) 10:01, 26 February 2012 (UTC)

Graphics card

This is kind of related to this question I asked previously about factors limiting .svg animation speed. I've got a file that has a lot of lines in and appears jerky. It runs at about 1.5 frames/second in chrome which is not ideal. Checking my system stats - the CPU (2 cores of 2Ghz each) is only ~60% used and RAM (2Gb) is only ~50% used. My graphics card is one of these, which our article describes as "basic" and almost 5 years old. Considering this, is it likely that my graphics card is responsible for the jerkiness? Is there anyway in ubuntu I can check to see how hard my graphics card is working? Assuming it is my graphics card being crap, what might make a good upgrade (in terms of a good price:performance ratio? Finally, if anyone has a super fast graphics computer, any chance you could email me and I will send you the file to see if it runs more quickly? Cheers SmartSE (talk) 17:18, 26 February 2012 (UTC)

A likely villain is the graphics driver. ATI has a poor track record of delivering Linux video drivers for their cards that are remotely comparable with their Windows equivalents. NVidia, in contrast, releases very good Linux drivers, which perform very similarly to their Window counterparts. I've heard that ATI's proprietary drivers are better than they used to be, but I don't know how you'd install that, as ATI lost me as a customer several years ago on this basis. My first advice would be to visit the Ubuntu forums and someone there should help you get the best ATI driver you can. If that isn't sufficient, a mid-range Nvidia card may be better. In either case, try using the Chromium browser rather than Firefox, as its SVG support has been a bit better. You might try Opera too, although I've not tested SVGs much on it. 94.5.190.65 (talk) 17:31, 26 February 2012 (UTC)

I'm not sure how true this is anymore, I've not had an issue with their drivers recently (FirePro V7800) but I had a terrible time with NVIDIA "optimus" based systems . IRWolfie- (talk) 17:38, 26 February 2012 (UTC)

Some other suggestions:

1) Reboot computer and ensure nothing else is running when you watch a video.

2) Reduce the screen resolution.

3) Reduce the movie resolution, if you have that option.

4) Reduce the frame rate, if you have that option (this is a last resort, though, as it may actually cause jerkiness on fast motion scenes, if reduced too much). StuRat (talk) 22:23, 26 February 2012 (UTC)

Circuit symbol for a solar panel

I am trying to do my GCSE coursework and I need to know what the circuit symbol for a solar panel is. If it helps, I am connecting a resistor to an ammeter and voltmeter and then connecting the voltmeter in parallel and the ammeter in series to the solar panel. I need to know what the circuit symbol for a solar panel is so I can draw my circuit diagram. I need the UK version of the symbol. Puffin ^{Let's talk!} 21:07, 26 February 2012 (UTC)

Maybe this? [3] RudolfRed (talk) 21:12, 26 February 2012 (UTC)

I don't know, it would be good if someone knew for definite, but it looks like it. If no one else knows then I will just have to use that one. Puffin ^{Let's talk!} 21:25, 26 February 2012 (UTC)

Ask your instructor or advisor. Or maybe one of your classmates. RudolfRed (talk) 21:33, 26 February 2012 (UTC)

Yes, that looks like it. However, as this is an uncommon symbol, I also suggest writing SOLAR PANEL next to the symbol, to make it clear to all who read it. StuRat (talk) 22:17, 26 February 2012 (UTC)

Googling solar panel circuit diagram returns quite a lot of results. The symbol linked above (and a variation with 2 cells) seems most common[4], but there are also some sites using a rectangle hatched with a grid pattern that looks something like an actual solar cell - this page has both. --Colapeninsula (talk) 10:08, 28 February 2012 (UTC)

Downloading MMS/SMS from Motorola phone

I haven't had much luck googling this because I can't seem to filter out the hits for downloading stuff to my phone. I'm trying to copy my Inbox and Sent Items from a Motorola i335 to a computer. I'm willing to do it in either Linux or Windows (Vista).

The closest I've gotten is KMobileTools, which (after some fiddling) manages to detect the phone well enough to show me signal strength and battery charge. But if I ask it to show me my SMS, it appears that in its opinion, there aren't any. Maybe I have the "initialization string" wrong or something? How can I find out what it's supposed to be? Thanks for any help. --Trovatore (talk) 21:20, 26 February 2012 (UTC)

Most phones these days come with a load of software for synchronising with your PC (less so with Linux). Check out Motorola's software downloads page and the i335's support options page to see if something useful is there. Astronaut (talk) 22:01, 26 February 2012 (UTC)

Appreciate it, but no, I can't find anything there. I was able to use the phonebook manager, so at least I could back up my contacts (although annoyingly it downloads it in Microsoft Access format and has no provision for exporting it to a more useful format, so I had to find a Linux tool for that step). But I don't see anything about synching up messages. Question is still open if anyone can help.... --Trovatore (talk) 22:41, 26 February 2012 (UTC)

Just curious... is this for a one-off backup or an ongoing need to copy SMS/MMS to a computer? You see, if it is a one-off backup, then perhaps you could forward the messages to a phone (a friend's phone?) that does have the software to do this? Astronaut (talk) 23:15, 26 February 2012 (UTC)

There doesn't seem to be any convenient way to do a batch-forward, so that doesn't strike me as a good solution for 100+ messages. Also I want to know how to do this if I'm going to continue with this carrier. --Trovatore (talk) 03:53, 27 February 2012 (UTC)

February 27

Formatting hard drives

Hello everyone. I want to format the two hard drives on my computer, which now uses Windows XP, and then set up the Ubuntu OS. I have already formatted my secondary hard disk from my Windows XP OS. Now, how can I format my primary hard disk, which I obviously can't format from within Windows XP? Please note I have no Windows XP installation disk available, so I need an alternate solution. Thanks in advance.--Leptictidium (mt) 15:50, 27 February 2012 (UTC)

It's a little unclear exactly what your setup is and what you want to do. Are you trying to set up a dual boot? Is your second hard drive internal or external? Assuming you want a dual boot, do you want Ubuntu to live on the first hard disk, or the second?

In any case, you shouldn't need a Windows install disk, just a Linux one, which you can just download, so whatever it is you want to do can almost certainly be done. But how to do it depends on the details of what you want. --Trovatore (talk) 15:55, 27 February 2012 (UTC)

Someone messed up with this computer a long time ago, setting up Windows XP both on drive C:\ and on drive H:\. I've accessed Windows XP on drive H and have used it to format drive C, so that's one less to go. My question is: what should I do now to format drive H too? But now that I know it can be done with a Linux install disk too, I think I already know. Thanks. Leptictidium (mt) 16:02, 27 February 2012 (UTC)

Be sure to back your data up first! As for the format itself, most (if not all) mainstream Linux installers give You the opportunity to partition Your hard disk accordingly in order to prepare it for the installation. I found this back from the day when I was a newbie at this partitioning stuff. Cheers, Ouro (blah blah) 17:24, 27 February 2012 (UTC)

All you need is an Ubuntu install disk. It will format and partition your hard disk if you tell it to. Of course this erases everything on the hard disk. Comet Tuttle (talk) 01:04, 28 February 2012 (UTC)

Size Of Wikipedia

• What will be the size of complete Wikipedia (English)? I mean all articles, talk pages, templates, projects etc.. 1 TB, 10 TB, 100 TB? You can add a {{tb}} template in my page. --Tito Dutta (Send me a message) 18:46, 27 February 2012 (UTC)
• Best answer provider will get a barnstar.. if interested and permitted! Strikeout this paragraph if this violates any guidelines here.--Tito Dutta (Send me a message) 18:49, 27 February 2012 (UTC)

See Special:Statistics. Bubba73 ^{You talkin' to me?} 20:12, 27 February 2012 (UTC)

Have a look here too though why the data for ENWP is so out of date, I don't know.[5] Thincat (talk) 22:50, 27 February 2012 (UTC)

So the English Wikipedia should be around 20GB now. Bubba73 ^{You talkin' to me?} 23:07, 27 February 2012 (UTC)

According to Wikipedia:Database download all English Wikipedia pages in 2010 were ~280 GB compressed, and "expand to multiple terabytes of text" when uncompressed. This does not include images. There is also Wikipedia:Size of Wikipedia but it seems to be several years out of date AvrillirvA (talk) 00:08, 28 February 2012 (UTC)

That's presumably all versions of all pages? --Tagishsimon (talk) 00:10, 28 February 2012 (UTC)

Yes. Wikipedia:Database download says 7.3 GB compressed, 31.0 GB uncompressed for "Current revisions only, no talk or user pages". Thincat (talk) 00:19, 28 February 2012 (UTC)

As of the English Wikipedia Jan 04, 2012 dump, the uncompressed size of " Articles, templates, media/file descriptions, and primary meta-pages" is 33.1 GB. ^Avic_ennasis @ 06:08, 5 Adar 5772 / 06:08, 28 February 2012 (UTC)

Getting URL of link

At http://www.spanair.com/Default.aspx?language=es I'm trying to get the URL of "Descargar instrucciones" but I haven't figured out how. When I right click it doesn't show a URL. WhisperToMe (talk) 22:04, 27 February 2012 (UTC)

The reason is because it doesn't really contain a link. It's a submit element that sends a form request to the server. The server then takes a look at what is sent to it and acts upon it — in this case, sending back the PDF. Because it is sent via the POST method there's no way to represent that as a simple hyperlink. --Mr.98 (talk) 22:37, 27 February 2012 (UTC)

Okay, so how could one best represent it? I'm trying to get it archived on http://www.webcitation.org WhisperToMe (talk) 01:58, 28 February 2012 (UTC)

You can either 1. upload the PDF somewhere else, 2. just link to the URL above as the citation. Those are your options. The site has not given you any way to direct link to that file. --Mr.98 (talk) 12:08, 28 February 2012 (UTC)

When some browsers download (like Google Chrome or Firefox) After you download you can get the download link (Often those "direct links" are deleted when it finished downloading, it's to avoid direct linking. — Preceding unsigned comment added by 190.60.93.218 (talk) 12:34, 28 February 2012 (UTC)

They may not even exist depending on how the coding works. I suspect it just streams the file to the browser. --Mr.98 (talk) 13:24, 28 February 2012 (UTC)

The correct URL for the PDF is in fact http://www.spanair.com/Default.aspx?language=es - but as the OP and others are already aware, this will only deliver the PDF if accompanied by an HTTP POST request (that is, the invisible part that happens behind the scenes when you click on the form submission button). The technical name for this type of URL is a "non-idempotent locator." In other words, the same URL will cause the server to do something different depending on the type and format of the HTTP request. Such URLs are indeed part of the HTTP standard (RFC 2616 §9.5), and are recommended for serving content that can vary from time to time, user to user, and so on; and for serving content that should not be cached by a proxy or cache. Whether this particular document satisfies such criteria, I am not sure... it looks like a pretty static PDF document to me. Nonetheless, the website operator may still choose to use this type of URL for other reasons - as has been noted, this discourages "hot-linking." In the spirit of standards-compliant pedantry, though, this does not prevent hot-linking. The scheme in use entirely depends on the user-agent, knowing that most user-agents use graphically displayed "links" to mean HTTP GET. Because most major web browsers don't have a user-interface for "bookmarking" an HTTP POST request, this sort of forces you to load the page and click the download button. Nonetheless, one could build a custom web-browser that does allow bookmarking and hot-linking with HTTP POST support. In fact, any HTML element that supports an "action" attribute could be used on a third-party web-page, allowing a hot-link to the document. Nimur (talk) 17:52, 28 February 2012 (UTC)

Indeed, but unfortunately I imagine webcitation has done no such thing. :/ ¦ Reisio (talk) 18:03, 28 February 2012 (UTC)

I know - this is frustrating, because it's silly semantics. But, the citation is valid even if it doesn't link directly to the document - a citation cites, not links, to its source. Furthermore, what you are citing is a web resource who provided a document. A URL is intended to locate a resource, not to identify a document. So, it's fair to cite the document and point to the resource that provided it. If you intend to identify the specific document (and not the resource who provides it) then what you want is a Uniform resource identifier, or its similar commercial counterpart, the digital object identifier, to specifically identify the PDF. Keep in mind: having a URI identifies an object but doesn't always tell you where it is located! Unfortunately for all involved parties, the PDF in this question doesn't have a unique identifier, (the author never assigned it one!) so this PDF cannot have a unique locator.

So - just because your citation won't contain a valid hot-link, don't worry. You have still created a valid citation. Nimur (talk) 20:07, 28 February 2012 (UTC)

I'm wondering.. can I submit that request from the url? 190.158.184.192 (talk) 23:17, 28 February 2012 (UTC)

February 28

missed an email - how do I forward the whole email account in Gmail's new look?

I have an account I rarely used and missed an email. I used to be able to forward ALL incoming mail (by going under settings) in gmail, and I would like to turn that on again, but can't find it under the new look. Can anyone tell me where it is (exactly)/how to get to that window again? Thanks. --80.99.254.208 (talk) 11:06, 28 February 2012 (UTC)

At the top right, click on the gear/sprocket icon. Go down to Settings. Click on the Forwarding tab. Change the top item. Dismas|^(talk) 11:40, 28 February 2012 (UTC)

Hey, thanks! Perfect. I don't know how I missed that gear/sprocket, I was looking around at that area, mostly by clicking my username at top-right and clicking "account settings". oh well. Thanks again. --80.99.254.208 (talk) 09:11, 29 February 2012 (UTC)

You're welcome! Dismas|^(talk) 14:05, 29 February 2012 (UTC)

Icon maker

I've been playing with a resource hacker (A program that has the ability to change bitmaps on a executable file, it is what the exe displays, for example calc.exe displays a calculator). It seems the program needs different versions of the same icon..

256 colors	256x256px	48x48px	32x32px	16x16px
32 colors	256x256px	48x48px	32x32px	16x16px
16 colors	256x256px	48x48px	32x32px	16x16px

(Ok there isn't really a 16 colors bitmap with 256x256 resolution, it's ridiculous, it's an example) Is there anyway automated way of getting all those versions of a bitmap? It seems that it will take a really long time to do it manually. Thanks! --190.60.93.218 (talk) 12:52, 28 February 2012 (UTC)

If you are just editing icons, there are icon editors out there that will auto-generate the different sizes. Otherwise you could use something like Imagemagick to do it automatically. --Mr.98 (talk) 21:48, 28 February 2012 (UTC)

Do you know where I can get an Imamagick GUI? 190.158.184.192 (talk) 22:49, 28 February 2012 (UTC) > Nevermind, seems that the gui doesn't work for it, and I'm not really good with commands... well do you know any icon editor that do that automatically? I'm using IcoFX Portable 190.158.184.192 (talk) 22:56, 28 February 2012 (UTC)

8 x 4 foot IR pass filter

I need an 8 foot by 4 foot sheet of semi transparent material that allows most/all IR light to pass though. I intend to use this sheet(maybe glued to a sheet of acrylic) as a projector screen. This screen needs to let IR pass though and it needs to show the projected image from the opposite side. Anyone know where i could get a sheet or a lining or paint that will allow me to build this screen? 98.238.132.145 (talk) 19:24, 28 February 2012 (UTC)

You won't be able to get so much material for cheap, at least not if it's got great optical properties. As a cheap workaround, you can use blue plastic - which will block blue light and pass red light. Let's speak quantitatively, though: how strong of a wavelength discrimination do you need? How much do you want to attenuate non-infrared light? How much parasitic attenuation can you afford in the infrared band? What non-visible-light bands do you care (and not-care) about blocking? Nimur (talk) 20:18, 28 February 2012 (UTC)

For example, McMaster sells 4x8 foot blue acrylic (8505K189, 8505K889, and 8505K989, ranging from ~ $130 to ~$230 per sheet). Catalog page 3569. This will pass infrared and block blue visible light (and other visible light, but not very well). You can stack as many sheets as deep as you need to progressively cut off more visible light. Nimur (talk) 20:22, 28 February 2012 (UTC)

My goal is to make a table that can ID and track objects. The way i was thinking that i was going to achieve this was to have a camera under the table that only sees IR and a IR flood light. To ID and track objects i was going to place a bar code on the bottom of the objects and read it via IR(if you have a better idea please tell me). The table it's self would have an image project on to it from underneath. I understand that this is not a cheap project so i am not only exploring cheap options. The sheets of blue acrylic might work if i am able to off set the blue from the computer/projector (make the projected image full color). As a side note i have discovered that the polarized layer on the front of a computer screen contains all the properties needed for my project - its just that i dont know of any 8 foot by 4 foot screen that i could take apart. 98.238.132.145 (talk) 20:55, 28 February 2012 (UTC)

A camera that only sees IR? Do you mean like FLIR? or Thermographic camera? Those are considerably different to typical "near infrared" night vision cameras which also "see" considerable parts of the visible spectrum. Vespine (talk) 00:08, 29 February 2012 (UTC)

Interesting and challenging idea! A couple of other factors spring to mind. Any surface that scatters visible light enough to make it a useful projecting surface will also probably scatter "near infrared light", unless you employ some sort of exotic narrow band filtering, which is probably not cost effective or practical. Anything outside of the "near infrared" range will probably NOT be able to read a barcode unless you print your barcodes out of exotic IR absorbing materials. Also, IR flood lights are also "near infared" so they'll be useless if you use anything but a near infrared camera. So immediately I wonder if you are just over engineering this. Have you ever seen someone in a steamy shower? The closer something is to a "diffuse" surface the less diffuse it appears, to the point where if something is resting directly on it, the frosting might be barely noticeable all together. The projector provides a fairly bright light source, maybe if you find just the right level of frosted perspex or glass, you can just use a regular camera? Vespine (talk) 00:17, 29 February 2012 (UTC)

The camera i had in mind was either going to be a wii controller or a modified FinePix S700. Your point about the diffused surface has already been considered, i was planning on playing around with that and seeing if i could simply get away with a 8x4 foot sheet of acrylic with a diffuser on it - but i don't think the light from the projector would work as it's light changes depending on whats being displayed.

Effective way to quickly reverse geocode

I have a table (table1) full of latitude and longitude coordinates stored as doubles.

I have another table (table2) (a very large one) full of places in countries (e.g. cities) that also have latitude and longitude coordinates, along with a country code.

What's an efficient SQL query that allows me to take the lat/lon coordinates in table1, run them through table2 to find the nearest coordinates, and then grab the country code from table2?

It does not have to be precise. Speed matters more than accuracy here; table2 has several million entries in it, and table1 is pretty large as well, and I'd like this to finish in my lifetime... --Mr.98 (talk) 21:54, 28 February 2012 (UTC)

One caution, the method you outlined above may sometimes return the wrong country. That is, a location in nation X may be closer to a city in your DB in nation Y, than to any city in your DB in nation X. For example, let's say your coords are in Niagara-on-the-Lake, Ontario but that city isn't in table 2, and the nearest city in table 2 is actually Buffalo, New York. StuRat (talk) 01:24, 29 February 2012 (UTC)

Also, does this have to be all SQL ? I'm thinking a mixture of embedded SQL and program logic would be in order. That is, use SQL to find the 10 closest possibilities with some very approximate calculation (like the sum of the differences in longitude and latitude), then use the program to sift out the closest, using exact calculations accounting for the distortion of the grid at different locations on the Earth (using some basic trig). StuRat (talk) 01:36, 29 February 2012 (UTC)

One other point, how do you deal with East and West and North and South longitudes and latitudes ? Have you set up a convention where one hemisphere is positive and another is negative ? As long as you've used the same convention in both tables, that should work, except for when -180 becomes +180. That is, your program would have to know that -179 is right by +179, it would be difficult to get an SQL query to handle that. StuRat (talk) 01:41, 29 February 2012 (UTC)

For reference, a relevant article is Spatial index. -- ToE 02:13, 29 February 2012 (UTC)

I don't really care TOO much about the boundary areas. Again, I'm crunching a lot of data here. As for SQL — well, I just want the dang thing to be pretty fast. It's a ton of data. If it takes more than a second per entry, it's going to take a week to do the calculations. That's a bit much. As for the coordinates, it's just standard decimal lat/lng, so it uses negatives, positives, what have you. Both of the databases use the same standardized approach. --Mr.98 (talk) 03:27, 29 February 2012 (UTC)

Can we assume that your lat and lng columns in table 2 are indexed? -- ToE 04:17, 29 February 2012 (UTC)

Sure! I mean, they're not at the moment, but I can probably change that, assuming Access doesn't explode under the strain (which it has done a few times already). --Mr.98 (talk) 13:11, 29 February 2012 (UTC)

February 29

MP3 player

My mp3 player does not work anymore, so I bought a new one (this type). It's basically the same than the one I had, both are X-view, both have the same buttons and use, but the new one has 4 GB instead of 2. But there's a problem. If I turned off the old one, when I turned it on again it was still at the song I last played; there are hundreds of songs so it took months to reach back the begining and repeat the songs (so, I could load the MP3 with songs just once and it was never repetitive... well, it was, but with months between each repeat, who notices?). But the new one does not do this: when I turn it off, and turn it on later, it's back at the first song. Sure, I could scroll manually to the one I last heard, but who would want to scroll hundreds of times? (I can not even keep the button pressed, that just goes fast forward inside the song, not advancing though several songs). Perhaps I could load just a dozen of songs each day and change them, but that would be so uncomfortable, and which would be the point of having 4 GB of space then?

I know that MP3 players are capable to remember the last song: the last I had, and the previous one, both could, and I see no reason why would such a feature be removed from new models. Is there a way to configure or "fix" this machine, or should I go back to the place where I bought it and request my money back? Cambalachero (talk) 00:20, 29 February 2012 (UTC)

I'd say take it back where you bought it. If they can show you how to get it to behave properly, keep it. If not, get your money back. StuRat (talk) 01:19, 29 February 2012 (UTC)

Agreed. As an alternative, most MP3 players have a "random" or "shuffle" function that will avoid starting at the beginning every time. Dbfirs 07:51, 29 February 2012 (UTC)

Can't hit enter after typing URL in Firefox

I could always type in a web site address and hit enter to go there, but for the last month or so (around when Firefox upgraded), this has no longer worked. Now I have to hit the little arrow which appears on the right side of the type-in window. I'm running Firefox 10.0.2 on Windows XP SP3. Is there a way to enable enter again ? StuRat (talk) 01:16, 29 February 2012 (UTC)

First thing to try: disable all add-ons. Googling for firefox url enter suggests at least an antivirus extension causes that. 88.112.59.31 (talk) 07:17, 29 February 2012 (UTC)

It still works for me. Bubba73 ^{You talkin' to me?} 14:01, 29 February 2012 (UTC)

PDF document not opening properly in PDF Complete

Yesterday, I scanned a paper document with a Xerox scanner, which sent the resulting scan to my work e-mail as a PDF document. My work computer runs Windows 7, and uses PDF Complete as its document viewer. This viewer had trouble opening the PDF document: it froze up the computer for minutes, taking over 1 gigabyte of memory. When the document finally opened, it just showed the pictures, not any text. The exact same document opens fine on my father's computer, which runs Windows Vista and uses Adobe Acrobat, and on my home computer, which runs Fedora 14 Linux and uses Evince. What could be the reason that the document doesn't open properly on my work computer? JIP | Talk 07:11, 29 February 2012 (UTC)

Must be a version incompatibility or bug in PDF complete. Is there any reason you're not using Adobe Reader on your Win7 machine? It's free, updates regularly, and the format was invented by Adobe... Sandman30s (talk) 08:17, 29 February 2012 (UTC)

Open it in Acrobat, save it as a new PDF. I suspect it's a bug in the PDF format as implemented by the scanner — a not uncommon occurrence. --Mr.98 (talk) 15:02, 29 February 2012 (UTC)