ELI5: What are the benefits of Redis, and how do you use it with RDBMS?

Let's say I have a PostGIS database with a lot related models. Would I have to basically aggregate that data into NoSQL type models to store them in redis? At what point do you move the data from models to Redis?

Note that I am a redis nooblet, so my understanding may be wrong... Just trying to figure out if it even makes sense for me to learn and implement redis. Thanks.

Ninja edit: Also, I guess geographical searches should still be handled by Django's GIS rather than me rewriting it all in Redis, if I go ahead and use that. How do you guys manage it?

/r/django
https://redd.it/7mm71s

Parsing “Ask HN: Who is hiring?” with Python and Hacker News API
https://www.alexkras.com/parse-ask-hn-who-is-hiring-python-and-hacker-news-api/

/r/Python
https://redd.it/7mlqil

Jupyter Notebook in the cloud with browser-based Linux UI
http://engineering.paiza.io/entry/paizacloud_jupyter_notebook

/r/IPython
https://redd.it/7mn9pw

3D isotropic wavelets, texture features, and contour interpolation available via pip / conda with ITK 4.13.0 release
https://blog.kitware.com/itk-4-13-0-has-been-released/

/r/IPython
https://redd.it/7mn7f6

Turtle module drawing a randomised landscape

/r/Python
https://redd.it/7mo2l8

[AF] Convert Oracle query to SQLAlchemy ORM

I have been trying to convert Oracle query to SQLAlchemy specifically ORM Here is the SQL I want to convert:

SELECT p.id,
p.name,
p.address,
to_char(t.s_time, 'mm/dd/yyyy hh:mi:ss AM') date_s,
t.date_h,
FROM p_table p,
(SELECT t_id,
dept,
ROW_NUMBER() OVER(PARTITION BY t_id ORDER BY dept) AS row_id
FROM t_table
WHERE t_id = :t_id
AND actual_time IS NULL) t

WHERE p.id = :id_var
AND row_id = 1
ORDER BY date_c DESC

Here is my attempt on converting this:

row_id = func.row_number().over(partition_by=TModel.t_id, order_by=TModel.dept)
sub_query = db.session.query(TModel.t_id, TModel.dept)\
.add_column(row_id)\
.from_self().filter(row_id == 1)\
.filter(TModel.t_id == t_id)\
.filter(TModel.actual_time == None)\
.label("sub_query")

q = db.session.query(PModel.id, PModel.name,
PModel.address, TModel.s_time, TModel.temp, sub_query)\
.filter(PModel.t_id == t_id)\
.order_by(PModel.date_complete.desc())\
.all()

print q

It seems I didn't correctly convert it into sqlalchemy it returns more than it is expecting for example running the SQL (5 rows) vs SQL(20+ rows) . Any help is greatly appreciated. Thank you!

/r/flask
https://redd.it/7mmjwi

Compiling Jinja2 templates?

Hello there,

I have a flask app and i use pyinstaller to make a stndalone version. My problem is that i have to serve the static files and the templates on a separate folder or else the app cannot find them. Is there a way o compile the html jinja templates as well ?

/r/flask
https://redd.it/7mgahs

[P]style2paintsII: The Most Accurate, Most Natural, Most Harmonious Anime Sketch Colorization and the Best Anime Style Transfer

/r/MachineLearning
https://redd.it/7mlwf4

numba and llvmlite are available in .whl format for Windows, Linux and Mac OS.

Just wanted to say that it's really nice that we can now easily install numba in a virtualenv, without having to use conda.
Kudos to the guys at Anaconda Inc!

/r/Python
https://redd.it/7mo9n9

[D] What type of Asimov-style rules would robot hosts have in HBO's Westworld?

>In the HBO series Westworld, a Host is an artificially created being, an android or artificially created animal. All of the animals (except for flies) in Westworld are hosts.

>The hosts are built to act out both storylines and narratives in the park by interacting with each other and with guests. They are designed to be incapable of permanently hurting any living non-host.

>At least some hosts are given a narrative to follow, and it may be that all hosts have a narrative to follow.

>Narratives are the stories that guests can participate in within the park. These stories are part of the entertainment of the guests. (Hosts follow their own story lines that loop, or repeat. The host's story lines can be part of guest narratives. There have been instances when hosts have broken away from their loops.)


>http://westworld.wikia.com/wiki/Host

>http://westworld.wikia.com/wiki/Narratives

/r/MachineLearning
https://redd.it/7mrbkv

Top 5 Programming language for AI
https://youtu.be/56uHZWniP1o

/r/Python
https://redd.it/7mrop5

[R] [1712.09913] Visualizing the Loss Landscape of Neural Nets
https://arxiv.org/abs/1712.09913

/r/MachineLearning
https://redd.it/7mr7j5

Sqlalchemy for Mysql vs postgres

Hi Im learning to program(first year CompSci student) and Im trying to teach myself how to make a website backed by a database. So far it is proving to be a harder nut to crack than I had anticipated, and definitely a learning experience.

I did a pretty cool tutorial where I scraped some facebook data with their api and stored it in a Mysql database, That was pretty cool. Now next step for my plan will be connecting to that database and getting the info out of it to use. for that end I found sqlalchemy and flask. Seems pretty great and I found a pretty great tutorial :

https://auth0.com/blog/sqlalchemy-orm-tutorial-for-python-developers/

But they use a postgres database! As far as I understand the whole purpose of sqlalchemy is so that the language will be the same for connecting to any database. Am I correct? If not Im thinking this whole thing might be a bit too ambitious for my current skill level! Oh well! Im open to any and all suggestions :)

TLDR: can i use sqlalchemy with a mysql database just like a postgres database?



/r/flask
https://redd.it/7mcwre

Algorithmic Problem Solving with Python [pdf]
http://www.eecs.wsu.edu/~schneidj/PyBook/swan.pdf

/r/Python
https://redd.it/7ms7xc

[HELP] Setting up a frontend workflow in a Django project.

Hi everyone! I have some experience with Flask and is now trying to pickup Django, and am slightly getting overwhelmed by the directory structure. And then there's a handful of techniques which deviates from the stock `startproject` layout, which only adds to the confusion. I mean, that's the reason I'm picking up the framework: to get a standardized structure/layout, unlike Flask in which the burden is in the developer's hands. Okay, enough of the newbie rant :D

The premise is that I would like to incorporate Node/NPM to my workflow. The primary reason is to allow usage of `ES6+` and `SASS` on my static files. Anyway, I currently have the following setup:

<project_root>
├── <django_project_root>
│ ├── __init__.py
│ ├── settings.py
│ ├── urls.py
│ ├── views.py
│ └── wsgi.py
├── lib // Compiled stuff.
│ └── app.js
├── LICENSE
├── manage.py
├── package.json
├── README.md
├── requirements.txt
├── src // Uncompiled 'source'
│ └── app.js
├── templates
│ └── index.djt
├── static // What gets referenced in my templates.
│ └── app.js
└── webpack.config.js

Now, I would like to write my `JS/SCSS` inside my `src` directory, and then:

1. Babel do its thing and output an `ES5` friendly version of whatever is in `src` into the `lib` folder.
2. Webpack grabs what's in `lib` and spits out a browser friendly version into a `static` folder.
3. Templates inside the `tempaltes` directory loads the contents of the `static` folder.
4. Note that I keep both `lib` and `static` out of version control. Which is correct, since I only need the `src` file, right?

Anyway, I can successfully do the workflow above with `ES6` js files inside `src`. But I'm clueless on what to do to do the same with `SCSS` files.

Relevant files:

// package.json
{
// ....
"scripts": {
"build": "babel src -d lib && webpack"
},
// ...
}

---

// webpack.config.js
module.exports = {
entry: './lib/app.js',
output: {
filename: './static/js/app.js',
}
};


How should I continue? Please do tell me if I need to provide more information. Thanks!

/r/django
https://redd.it/7mtbc5

Linting while the dev server runs

I've been doing a bit of front-end development lately and one of the things I really started to like is that while using webpack-dev-server with eslint, any linting errorswill show in the console in real-time when the server reloads.

I was wondering if I could do the same thing using Flask dev server and flake8

Turns out it's fairly simple.

I modified my `run.py` to run flake8 and show the errors any time the Flask dev server restarts.

https://gist.github.com/timster/a6b8d01c864cf7ce7ad20ecb3f8d85b6

This gives a pretty output in the console for any linting errors:

https://i.imgur.com/7zbsXu9.png

Has anyone done anything similar?

/r/flask
https://redd.it/7mty89

8 Python developers that inspired me in 2017. Who inspired you?
https://hackernoon.com/8-python-developers-that-inspired-me-in-2017-85cb43b302a0?source=linkShare-ec39004dd57f-1514536217

/r/Python
https://redd.it/7mt5au

[D] Full graduate course in Bayesian ML [videos + slides + homework]
https://www.zabaras.com/statisticalcomputing

/r/MachineLearning
https://redd.it/7muyz2

App, project, site - making sense of Django's naming scheme
https://consideratecode.com/2017/12/29/app-project-site-making-sense-djangos-naming-scheme/

/r/django
https://redd.it/7mvnlm

django app with celery enabling users to create tasks, and configure how to run them.

hello, i am making a django app using celery, i want the user to be able to schedule tasks. how should i go about doing it?should i use periodic tasks or something else, the examples show static calls to functions.

/r/django
https://redd.it/7mucll