danpelota (u/danpelota)

danpelota commented on "None of These Books Are Obscene": Judge Strikes Down Much of FL's Book Ban Bill bookriot.com/penguin-rand... · Posted by u/healsdata

jwally · 10 days ago

Is the Bible still ok???

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

Genesis 16:4 – “And he went in unto Hagar, and she conceived…” (Abram and Hagar)

Genesis 29:23 – “…and he went in unto her.” (Jacob and Leah)

Genesis 30:4 – “…and Jacob went in unto her.” (Jacob and Bilhah)

Ruth 4:13 – “…and he went in unto her, and the LORD gave her conception…” (Boaz and Ruth)

Variants & related euphemisms

Genesis 38:16 – “…he turned unto her by the way, and said, Go to, I pray thee, let me come in unto thee…” (Judah and Tamar)

2 Samuel 11:4 – “And David sent messengers, and took her; and she came in unto him, and he lay with her…” (David and Bathsheba)

Leviticus 18:6+ – “uncover nakedness” is repeated as a sexual euphemism.

Genesis 38:9 – “…when he went in unto his brother’s wife, that he spilled it on the ground…” (Onan; explicit ejaculation reference).

danpelota · 10 days ago

Ezekiel 23:20 - "There she lusted after her lovers, whose genitals were like those of donkeys and whose emission was like that of horses."

danpelota commented on Show HN: Visual SQL chartio.com/blog/why-we-m... · Posted by u/thingsilearned

mstade · 5 years ago

Looks nice, but like others here we need something that can be self hosted or even better – run offline.

Somewhat related: does anyone know of any good components/libraries that can be embedded in a web page to let users interactively build SQL queries of reasonable complexity? By that I mean something that not only lets you pick columns and filter and maybe group things, but also do joins on other tables as well.

Edit: just to clarify, it doesn't have to be be visual only. In fact, something that lets you edit a query interactively either by visual components or actual SQL code is perfect, especially if it's bidirectional so that edits in the code also show in the UI and vice versa.

danpelota · 5 years ago

I don't know about embedding, but I've been happy with the Metabase UI for building these kinds of queries:

https://www.metabase.com/docs/latest/users-guide/custom-ques...

danpelota commented on Comprehensive Guide on Data Visualization with Pandas kanoki.org/2019/09/16/dat... · Posted by u/min2bro

whitehouse3 · 6 years ago

Lately, `pip install pandas` is my first step after making a new virtual environment. Its read_sql and read_csv methods are magic. The resulting DataFrames are just like DataTables in C#. And for complex joins and aggregations, I can DataFrame.to_sql into an in-memory SQLite database.

Pandas feels like the wrong tool for this job. I don't use multi-indexes or any statistical methods. I don't chart anything.

But it's so darn convenient. If the time comes to optimize I can `import csv` directly and improve performance. But nothing beats it for prototyping.

Are there better options in this space?

danpelota · 6 years ago

On occasion, I've fired up pandas just to sanitize a CSV file and drop malformed rows as preparation to bulk ingesting into a database:

  import pandas as pd
  pd.read_csv('bad_file.csv', error_bad_lines=False).to_csv('good_file.csv')

It's not efficient (reads everything into memory), but read_csv is robust when it comes to handling embedded unescaped quotes/commas/etc., and supports dropping rows with the incorrect number of columns due to anomalies it can't handle.

danpelota commented on Github search sucks (and how it could be better) github.com/isaacs/github/... · Posted by u/RenaudWasTaken

hbt · 8 years ago

all files ending with py with "import flask"

https://github.com/search?q=filename%3A%2A.py+%22import+flas...

use advanced search to specify stars:>20 etc.

danpelota · 8 years ago

Unfortunately, you can search code by file extension and phrase, and you can use advanced search to search for repository descriptions filtering by stars, but I don't believe you can do both at once.

For instance, searching for "flask" and limiting the results to >1000 stars returns only the 27 repositories with a matching description[0], but the code search returns over 4 million results, ignoring the stars parameter[1].

https://github.com/search?l=&q=flask+stars%3A%3E1000&ref=adv...

danpelota commented on Github search sucks (and how it could be better) github.com/isaacs/github/... · Posted by u/RenaudWasTaken

danpelota · 8 years ago

I would love to be able to search all code for a string and then either (1) sort the resulting repositories by stars/forks; or (2) limit the results to repositories with >X stars/forks. When learning a new framework or library I like to find popular projects that use it and read the code to get a sense of conventions, architecture, etc. For instance, it'd be fantastic to find all repositories with over 20 stars containing a *.py file with "import flask" or "from flask" in them.

danpelota commented on Ask HN: Are there any systematic and scientific ways to develop a habit? · Posted by u/sammyjiang

katzgrau · 9 years ago

Have a read, great book on the topic: https://www.amazon.com/Power-Habit-What-Life-Business/dp/081...

Systematic, definitely. Scientific? Not really sure, but I find it extremely effective. If I could boil it down to "what works" for me, it'd be:

- Pick a task or thing that you want to accomplish. Let's say running (mine is running/lifting).

- Pick a "cue," or something that signals when you perform said task. The more apparent the cue the better. Mine is waking up. Working out is the first thing I do.

- Follow this routine religiously for about 21 days. That's the magic number according to people who are into this kind of thing, and I agree. At this point you kind of forget what your old habit was when you woke up, and you naturally go to perform your new task.

And lastly, there will be some days when you don't want to perform the task. Do it anyway. A streak of not performing that task is really just the (re)formation of a bad habit.

danpelota · 9 years ago

In addition, I haven't seen the third step in the "Cue -> Habit -> Reward" cycle mentioned yet. While the Reward may be the lingering endorphin rush from a hard workout or the feeling of accomplishment after finishing a chore, the author also suggests a simple, pleasurable behavior after the task that you're trying to make a habit of (like a small piece of chocolate immediately after a run or allowing yourself a few shameless minutes of cat videos after a focused study session). The idea is to allow your mind to associate the pleasure response with the habit each time it encounters the cue.

danpelota commented on Europol chief warns on computer encryption bbc.com/news/technology-3... · Posted by u/neokya

danpelota · 10 years ago

Really, we need to be rethinking the legality of combination safes and deadbolt locks - they're being leveraged in terrorist operations as well.