Re: Hate Mail | https://longreads.com/
But really, I don’t block my internet stalker because I’m compelled by my own shame. How much do I need to be liked? I do my best to avoid the black hole of this question: I don’t google myself. I don’t read the comments anymore. I read only the most professional reviews. But once the dark gravity of judgement has me in its grasp, once it’s in my inbox, I can’t look away. Fleetingly, it feels true that I should be tested. That in asking the world to consider my voice, I’ve invited th...
writing  harassment  theinternet  dudes  thelifeofthemind 
11 hours ago
Doctors Decry Medical Lobby’s Donations to Pro-Gun Politicians
Wintemute noted, they have to preserve relationships with elected officials with whom they work on a range of policies. Wintemute said doctors should privately push elected officials to embrace policies to reduce gun violence, and should change their everyday medical practice by talking about the issue with colleagues and patients.
guns  policy  america 
16 hours ago
Perl - Subroutine redefined - Stack Overflow | https://stackoverflow.com/
When I did this, it was because I used Exporter's @EXPORT, and redefined 'read' that some other package had also exported.
errormessage  perl  newbie  packages  devel  sortof  solution 
3 days ago
In Florida Recount, Sloppy Signatures Placed Thousands of Ballots in Limbo - The New York Times
The idea that “in 2018 we are still having a conversation” about election staff members analyzing signatures, he added later, “is preposterous in a world that now includes biometrics and block chain.”
elections  voting 
4 days ago
Primer on Python Decorators – Real Python | https://realpython.com/
<code class="language-python">
def repeat(_func=None, *, num_times=2):
def decorator_repeat(func):
def wrapper_repeat(*args, **kwargs):
for _ in range(num_times):
value = func(*args, **kwargs)
return value
return wrapper_repeat

if _func is None:
return decorator_repeat
return decorator_repeat(_func)
python  newbie  language  idiom  decorators  solution 
5 days ago
How to pass password to mysql command line - Unix & Linux Stack Exchange | https://unix.stackexchange.com/
It doesn't look like you can send a password to 'mysql' on stdin, even though that's where it seems to be expecting it from with the '-p' (no password) option.

So I ended up using the '--defaults-file' option.
mysql  cli  dba  commandline  pipes  subprocess  python  workaround  solution 
5 days ago
python - SQLAlchemy default DateTime - Stack Overflow | https://stackoverflow.com/
You could use 'server_default=func.now()', but that will calculate a timestamp once per transaction, which may not be what you want.

This probably works fine:

<code class="language-python">
import datetime
from sqlalchemy import Column, Integer, DateTime
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class Test(Base):
__tablename__ = 'test'

id = Column(Integer, primary_key=True)
created_date = Column(DateTime, default=datetime.datetime.utcnow)

python  sqlalchemy  sql  timeanddate  timestamp  dba  solution 
5 days ago
perl - How can I set default values using Getopt::Std? - Stack Overflow | https://stackoverflow.com/
The best thing is to use GetOpt::Long and use a hash instead of individual variables. Then you can pass default values by pre-populating the array
<code class="language-perl">
use Getopt::Long;
my %opts = (parameter => 20);
GetOptions( \%opts,
) or die "Invalid parameters!";
perl  argumentprocessing  shellscripting  getopt  solution 
6 days ago
MySQL :: Re: repair by sorting? | https://forums.mysql.com/
"Repair by sorting" is MyISAM's way of updating the indexes after a bulk insert. When inserting Millions of rows of data into a MyISAM table, it is normal for the index updates to take longer than the actual inserts.
mysql  dba  errormessage  solution 
10 days ago
innodb - Internal reason for killing process taking up long time in mysql - Database Administrators Stack Exchange | https://dba.stackexchange.com/
Possible causes: InnoDB takes forever to roll back mass inserts. Also, innodb_buffer_pool_size might've been too small (default is only like 128 MB).
innodb  mysql  performance  optimization  errormessage  itsslow  maybesolution 
10 days ago
UCSC MySQL | http://lh3lh3.users.sourceforge.net/
The binning algorithm is in section 5.3 of the SAM specification (https://samtools.github.io/hts-specs/SAMv1.pdf?page=18).
A note on binning

For small tables like refGene, UCSC simply creates MySQL indices on the chromosomal coordinate of a record. For large tables like snp129, UCSC cacluates a bin number for each record and only indexes chromosome name and the bin number without indexing chromosomal coordinates. Doing in this way is faster than simply relying on the MySQL indices and saves disk space as well. Detailed algorithm can be found in Kent et al. (2002) or from the SAM format specification. You can also read the source code of this script to see how the bin number is calculated and used in query.
binning  mysql  ucsc  genomebrowser  dba  optimization 
10 days ago
Index of /bin/linux/ubuntu | https://cran.r-project.org/
Some people have reported difficulties using this approach. The issue is usually related to a firewall blocking port 11371. If the first gpg command fails, you may want to try (thanks to Mischan Toosarani for the tip):
<code class="language-bash">
gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys E298A3A825C0D65DFD57CBB651716619E084DAB9

and then feed it to apt-key with
<code class="language-bash">
gpg -a --export E298A3A825C0D65DFD57CBB651716619E084DAB9 | sudo apt-key add -

Another alternative approach is to search for the key at http://keyserver.ubuntu.com:11371/ and copy the key to a plain text file, say key.txt. Then, feed the key to apt-key with
<code class="language-bash">
sudo apt-key add key.txt
r  installation  ubuntu  packages  keyserver  errormessage  workaround  solution 
11 days ago
« earlier      
acf addon addressbook advice alternativeto america android animation annoyance apache api app apple applescript art article audio authentication automation backupandrecovery bash bestpractices bioinformatics blog browser bug by:20gnd c calendar centos chrome cli cloudstorage collaboration comic commandline configfile console cplusplus crossplatform cs css culture cycling dammitbrain database dba debian debugging design devel disasterrecovery documentation driver dropbox editor education email employment encryption errormessage essential extension eyecandy favorite filemanagement filesystem film firefox flask framework freeware from:twitter fuckina funny gaming git github gmail gnome google graphics gui hacking hardware health history hosting howto html html5 humor icons ide imageprocessing inspiration installation interesting ios iphone java javascript jquery keyboard language latex ldap learning library linux list lists mac markdown math matlab maybesolution mediawiki mobile movein mozilla music mysql mystuff needshelp networking newbie news nonfree opensource osx packagemanagement pdf perl photography php plugin politics printing privacy productivity programming projectstowatch python rails reference research ruby samplecode science scm script scripting searchandindex searchengine security service shell shellscripting socialmedia software solution ssh storage syntaxhighlighting sysadmin systemmonitoring terminal testing textprocessing thefuture theme thewaythingswere thunderbird tipsandtricks todo toolchain troubleshooting tutorial ubuntu ui unix utility versioncontrol via:ifttt video vim visualization watchthisspace web webapp webapps webdesign webdevel webmaster wiki win7 windows wishlist wordpress work writing x11

Copy this bookmark: