bshipp

35 ms·

301.
by bshipp 7y ago
I found docker was perfect for self-hosting services with relative ease. upgrades are self-contained, security is simplified behind a reverse proxy like nginx, and there are very few dependency conflicts to worry about. I've got about
302.
by bshipp 7y ago
That's a term I haven't heard in a very very long time, but you're right, that's exactly what I'm looking for!
303.
by bshipp 7y ago
Thanks so much, that's exactly what I was looking for. I'm far more mobile these days than I was 20 years ago which limits the usefulness of most local IRC clients so this looks perfect for having a 'homebase' website&#x
304.
by bshipp 7y ago
That sounds like a simple, clever solution. Thanks!
305.
by bshipp 7y ago
I have a question regarding IRC. I haven't really used it much since 2001-2002 but is there a self-hosted option where i can leave a client running on my server and then access it with my phone and/or browser on a desktop pc when
306.
by bshipp 7y ago
I assume you mean metres, not kilometres? There wouldn't appear to be much atmosphere to benefit a lighter than air ship at 10000 km.
307.
by bshipp 7y ago
Thanks very much for the suggestion! I really didn't know where to start and the first few sites seemed to dive right into charts but I'll check out manifests this time. Thanks again.
308.
by bshipp 7y ago
This resonated with my recent experience. I have been using Docker and docker-compose quite comfortably for a few years now. I thought it'd try and dip toes into Kubernetes to extend my containerization skill-set and learn something n
309.
by bshipp 7y ago
Thanks for the recommendation! I've honestly never heard of J and I'll take a look at it.
310.
by bshipp 7y ago
Similar to what @overcast said: initially I didn't use select_related at all. Almost immediately I saw huge DB utilization with hundreds of thousands of tuples returned for (what I assumed) were pretty simple queries. I realized, as
311.
by bshipp 7y ago
You're absolutely right. As someone coming into Python and SQL from a purely Excel background, the first realization I had was that I had been, in essence, programming Excel. Not in a rational VBA kind of way, but in how I was linkin
312.
by bshipp 7y ago
ORMs are just as capable as any developer of generating bad SQL queries that crush databases and plug network connections.
313.
by bshipp 7y ago
Thank you for clarifying that; I was wondering where the concern was coming from. Without disagreeing with any of the above, one important consideration is what you're going to do with the query. If all you want to know is a column&#x
314.
by bshipp 7y ago
One thing that hasn't been mentioned yet, that I found when I started using Python and SQL together, is the importance of well-considered indices. ORM's aren't always too clever when they generate an index, and often (for re
315.
by bshipp 7y ago
It all depends on the database and the API in use. When handling sqlite with Python I often use Roger Binns' APSW. ( https://rogerbinns.github.io/apsw/cursor.html#cursors ) With an in-memory database or running it
316.
by bshipp 7y ago
select_related caught me when I first started using Django. It's a sneaky one because the queries worked fine when I first wrote the program. Then I started populating the database and, over the course of months, the queries got slowe
317.
by bshipp 7y ago
Even after learning python, pandas, and SQL I still find myself firing up Excel first when exploring a new problem. The interface is incredibly simple for pasting, manipulating, and visualizing data. The warts really only start appearing
318.
by bshipp 7y ago
I wonder if people do timings for the variances between a function in the DB vs Python? Unless your queries are so small (like individual records) that a round-trip to the DB is impacted by network lag, I find it's almost always faste
319.
by bshipp 7y ago
django-debug-toolbar is excellent, and I use it on my django sites as well. In addition, the documentation does a pretty good job of highlighting some of the common gotchas. Unlike your environment, my page/js weight is very low but I
320.
by bshipp 7y ago
One situation that makes a great deal of sense on paper and is very difficult to effectively implement on commercial scales is aquaponics. In theory, being able to produce both fish and vegetables should be a good value proposition. In rea
321.
by bshipp 7y ago
There is some value in certain conditions for some of the items he has indicated. His most egregious error is thinking that no one is investigating or leveraging them. Generating specific taste profiles of fruits and vegetables based on in
322.
by bshipp 7y ago
You're absolutely correct. There are very few situations where the benefit of only using artificial light outweighs the cost of ignoring free sunlight. Most hydroponics will transition with supplemental lighting, not exclusive LED ligh
323.
by bshipp 7y ago
After getting my masters in ag science and spending a decade working in hydroponics and field agriculture I am glad to see someone else identifying the hubris here. Multiple times a month I have to endure a pitch or presentation from some u
324.
by bshipp 7y ago
Growing up a family friend owned a tree planting company and I got to know many of them before they headed north to start the season. My memory (in the early 80's) is definitely a large group of young, university-aged, smelly, bearded
325.
by bshipp 7y ago
I use crawlera, and it does have the capability to establish and maintain a session. I can't pick the precise initial IP but once the connection is made I can certainly tell it to keep using that IP. Sessions are the only way to use cr
326.
by bshipp 7y ago
But...did you? Do the structural adjustments I mean.
327.
by bshipp 7y ago
Indeed, AMD is finally in a good position after years wandering the desert. That said, this current strong performance is the result of years of R&D, something that would have to be built from the ground up if Apple was to try and repl
328.
by bshipp 7y ago
Fair enough, I always associated PowerPC with Apple and assumed they were the driving force behind it's use. Regardless, that makes the financial calculus even more suspect as they would have even fewer units to amortize the cost over.
329.
by bshipp 7y ago
correct me if I'm wrong, but isn't the reason they moved to Intel chips in the first place because their homegrown CPUs couldn't keep up? Has that calculus changed in the meantime?
330.
by bshipp 7y ago
I don't disagree, but it's not really different with spinning rust. the solution would likely be similar: seal it in an enclosure to prevent intrusion of dust, scratches, etc.

More ›