I'm working on an application that allows a user to view playlists belonging to a particular radio show and stream/download/favourite the tracks in them. It has 4 core entities: User, Show, Playlist and Track.

• Each show has multiple playlists (one-to-many)
• Each playlist has multiple tracks (one-to-many)

To be able to reference a playlist belonging to a particular show. I gave those playlists the same uuid as the show they belong to. A few questions though.

1. Is this the right/best way to associate data?
2. As a track could potentially belong to multiple playlists, I can't take the same approach as I do for (show/playlist) How would be best to handle this? Ideally I would like to have a single "Track" table containing all tracks for all playlists.

For any experienced database designers out there, how would you structure this data? What would you consider in designing the schema and why? If I did go with 4 tables only, presumably there would be performance implications given the potential amount of data in any one of those tables, particularly tracks. If that is the case, how best to structure this kind of thing with performance in mind? Thanks in advance for any help :)

For reference, in case it's of importance, I'm using sqlite3.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

Hey everyone,

I've been programming for some time now but notice without any formalized education in CS I often get lost in the weeds when it comes to developing larger applications. I'm familiar with the principles of TDD and SOLID - which have helped with maintainability - however still feel that I'm lacking in the ability to architect a properly structured system. As an example, I'm currently developing a flask REST API for a website (just for learning purposes). This involves parsing a html response and serializing the result as JSON. I'm still quite unclear as to structuring this sort of thing. If any more experienced developers could point me in the right direction/offer up their opinion I'd be very appreciative. Currently I have something like this (based - I hope correctly? - on uncle bob's clean architecture).

Firstly, I'm defining the domain model. i.e the structure of the API response. Then, from outside in.

1. Infrastructure (Flask): User makes request via interface (in my case a request to some endpoint)
2. Adapters: request object checks if the request is valid (on the way back it checks if the response is valid) - Is this layer only for error handling?
3. Repository: I'm struggling a bit here, AFAIUI this layer is traditionally a database. In my case however, where the request is valid, is this where I should handle the networking layer? i.e all the requests to return the website source? I'm also confused given at this stage I should be returning the relevant domain model, like an ORM, but as my data is unstructured, in order to do this I need to transform the response first. Where would it be best to handle this?
4. Use Cases: Here I transform the domain model depending on the request. For example, filter all objects by id. Have I understood this correctly?
5. Serializers: Encode the domain model as JSON to return from flask route.

If you got this far, thanks so much for reading. I really hope to hear the opinions of more experienced devs who can steer me in the right direction/correct me should I have misunderstood anything.

I've recently built a brainfuck just-in-time compiler and I'm looking for my next project. I think compiling a more complicated (and more easily written) language would build on what I've learned so far. Rather than design my own language from the ground up, I'd prefer to work with a toy language that already has existing programs and a spec. This would both save me some work and give me more solid ground to build upon.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

I am a fullstack developer that spends a good portion of my time building out complex User Interfaces, and the rest building out back-ends for that software. In my opinion the current method that my company uses for a designer to developer hand off is a bit lacking in efficiency.

The current method is usually a designer will provide a developer with a Photoshop (or very occasionally an Illustrator) file containing the entire applications design. It is then up to the developer to export assets (both quick exporting things as pngs, going through and separating shadows from assets, or creating assets from the layers provided) and dig through the file to determine fonts and placement of items.

Is it a common expectation that a developer should be spending a good chunk of time in Adobe on asset manipulation?

Additionally does anyone have any process or program suggestions that may make life easier?

Hi. AVG's been bugging me with reminders to renew my subscription recently, but I don't have the money for that. I've been using AVG Free for years, but each time I trial the full edition it seems to install as a separate program, and then I have to manually revert back to the free version once the trial's up. The only other anti-malware I use is MalwareBytes (free again).

I'm not too worried about using a VPN, and have been advised to avoid the free ones anyway. I'd really just like a decent alternative to AVG Free that won't mess with my Steam games or pester me to upgrade several times a day. I have almost no experience with other anti-malware programs, so I'd rather ask people in the know for advice than just install something straight away and find out that it does one of the aforementioned annoying things.

...Should I use a free VPN? I'm trying to save as much of my scant moolah as I can, and I do occasionally torrent things, but the free ones are allegedly a little shady.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

I read the AskReddit thread on "What costs less than $100 that changed your life?" (link unavailable since I'm at work) but someone responded "SQL" - jobs just open up that make a ton of money.

I did a cursory search on Indeed and holy moly they were right -- SQL jobs get easily 2x what I make now. I'm pretty good at Excel and that sort of thinking, so I was thinking I'd try taking a class.

Do yall have any recommendations as to a good course to take in SQL, preferably online, preferably free or cheap? I'm willing to pay a bit if it'll mean I can make a lot more, but I'm currently not making a ton, haha.

Any responses welcome, including ideas as to how to break into like, tech-oriented fields as well.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This may seem an obvious question, but not as much as it seems. She uses Windows, I’m currently using Linux/macOS. How to instruct her to install her Python environment? Should I use Zoom, Skype, Google Hangouts, or another solution? Is there and easy way for live-drawing (online blackboard) to explain things to her visually? And, perhaps most importantly, how can I do that for free?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

Following up on @freddy's query about self-hosting ...

I am trying to set up a self-hosted VPS running Synapse (the server-side component of Matrix), Riot-web, and bundled in Jitsi. I've twice gotten it up and running successfully for internal accounts/users, but federation keeps throwing weird authentication errors when trying to connect with user accounts from other server instances (a week later, my regular Matrix account still has 3 outstanding broken Invites from the new server-account which I can neither accept nor reject ... ).

I'm basically following along with this youtube setup tutorial (except I am using Apache rather than nginx).

Before I start to drill into the nitty-gritty of my issue(s), does anyone here have experience setting this up? Anyone care to dedicate a bit of time and energy to helping me figure out what I'm doing wrong?

Additionally, I saw commentary from @smores that Jitsi isn't performing well for him on his self-hosted server ... any further details you can share?

Edited to add:

Sorry all, I didn't think through the timing. I am still motivated to get a self-hosted Matrix instance up and running; however, right at the moment, I have a couple of other, higher priorities I need to attend to first. If I'd thought about it, I would have held off on starting this thread for a couple of days.

I will get back to this thread ... let's say, Wed or Thurs ... take another crack at the Matrix set-up then, and provide details here, as I do.

Thanks,
EtC

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

I’m currently studying Python Object Oriented programming and got to a point where logic and syntax are the least of my problems. I always get to a stage where I’m completely lost between modules, classes, objects and a sea of “selfs”.

I’m not doing anything too complicated, just small projects for practice, but I think I would benefit from planning. My mental processes are highly disorganized (ADHD) and I need all the help I can get with that.

I don’t need an automated tool (even though it might come in handy) -- sketching things out on paper is probably enough.

I only know about UML, which seems fine. Can anyone recommend a tutorial about this and other tools?

Edit to link my last attempt at following a tutorial:

This is the last tutorial I tried to follow, a Pygame project from the book Python Crash Course 2ed. Following tutorials is frequently mostly typing, so what I achieved there is not a real representation of my abilities -- I would not be able to do something like that on my own. In fact, I failed to answer the latest exercises, which were basically smaller versions of this project.

My problem is not with syntax and the basics of how OOP works, but rather with memory and organization of information.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

Sorry if this is a silly question, but I keep running into situations where a small CLI or GUI tool that could be handed a single file and hand me back an encrypted version would be useful. I've done some googling, but all I typically turn up is blogspam about random Windows-only tools that seem to be of dubious quality.

Anyone know of a good tool for this type of thing?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

In the DC canon, The Mobius Chair is a time-space/dimensional vehicle operated by the New God Metron. It allows him to travel and observe the universe, but the one I'm making is nowhere near as functional.

I've come into a recliner chair with a cupholder on each armrest, and I already had a split keyboard. My plan is to use the cupholders as a mount for both ends of the split keyboard, so that I could use the entire run of armrest and have my hands lay naturally on the keys. Goals are to minimize weird stretching and be able to comfortably type for long stretches of time, to put off stuff building this that I planned to work on this weekend, and to look super boss, though not necessarily in that order.

If I want ultimate angulation and the best range of motion, I was thinking about something like a cupholder with a phone or a tablet mount, like this one, but if anyone has recommendations for what would be best to work with, or have done something like this before, I'm all ears.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

I'm finally in a position in my life to afford a personal domain. The name I'd like to use is name of an episode from a moderately popular TV series. The series ended its run few years ago, but I'm not sure how copyright/trademarks work.

So far, I'm planning a strictly noncommercial personal use only. Will the choice of domain name be any trouble down the road?

Hello everyone. I consider myself fairly competent when it comes to my work with LaTeX, but as everyone who uses it knows, it is definetely strange sometimes. And right now I have a problem which just irks me in the wrong ways:

I use XeTeX and a number of custom fonts for my documents, but when writing mathematical formulas I found out that the font I set for Greek letters (Gentium Plus) is used for letter commands like \alpha, \Alpha, ... but not for commands like \sum, \prod. As you can see in this example here. You can see XeTeX defaults to Computer Modern.

I've looked all over the net for solutions but I can't find one. I'm using mathspec, amsmath, amsfonts, amssymb as my font related packages and I set my fonts like this:

\setmainfont{Charis SIL}
\setsansfont{Helvetica Now Display}
\setmonofont[Scale=MatchLowercase]{Fira Code Retina}
\setmathfont(Digits,Latin){Charis SIL}
\setmathfont(Greek){Gentium Plus}

I feel like I'm going insane not solving this problem. Should you require it, my entire LaTeX template is here on Github. Please help, thank you.

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

I'm trying to package Elmer for use with NixOS, and could use some help from any experienced Nix users. My current attempt is located here. There is some junk left around in that file from my experimenting, but it's at least a start. There are also a few lines of error included in the comment here.

Any help is appreciated!

I've been thinking on and off about packaging up a few simple Python utilities I've written to stick up on Github for people to use if they want, but, every time I go to check out how one goes about managing dependencies and all that for a project, I run into a whole wall of options. Does anyone better versed in all of this have any recommendations for me?

While I've been teaching myself my first programming language (Python), I've been getting more into using the terminal as much as possible to build familiarity and get comfortable. This has opened my eyes to so many useful utilities and makes me curious as to what there is out there that I haven't heard of yet.

My favorites so far:

exa - A modern version of "ls"

youtube-dl - Download videos from youtube.com or other video platforms with various options

hledger - Plain text double-entry accounting software based on ledger written in Haskell

thefuck - App that corrects a spelling mistake in the previous command by typing "fuck"

spicetify-cli - Customizes the Spotify client with themes and extensions

spotifyd - Lightweight Spotify daemon

spotify-tui - Control Spotify in the terminal

neofetch - Launch tool that can display ASCII art or pictures and general system information

I'm on macOS but I'm almost certain all of these are cross-platform.

What are your favorite or "must-have" CLI packages?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

I have two computers (a desktop and a laptop) that broke down just before my city entered a lockdown. Being able to assemble and fix my own computer hardware is something I have always wanted to do, and if I knew that I would probably not be using a borrowed Macbook Air right now.

I have no immediate need to provide any maintenance services, nor do I require a primer in electronics or anything too advanced. Just enough to know how to assemble and disassemble a machine, identify and fix the most obvious issues without breaking anything.

I tend to learn better from sequential and structure learning materials, preferably in text/images form. But videos are also welcomed. I know the names of the things and what they are, but I don't really know how to put things together in practice.

Suggestions? :)

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

A while back I developed a desktop-based text editor (Scrivenvar) that uses the Chain-of-Responsibility design pattern to help me author fairly involved text documents. The editor's high-level architecture resembles the following diagram:

https://i.imgur.com/8IMpAkN.png

Am I reinventing the wheel here? Are there any modern, cross-platform, liberal open-source (LGPL, MIT, Apache 2), text editor frameworks (such as xi or Visual Studio Code), that would enable (re)development of such a tool?

Scrivenvar is written in Java, but to my chagrin, Java 9+ no longer bundles JavaFX. The text editor was based on MarkdownWriterFX, itself based on JavaFX. This means there's no easy upgrade path, so I'm looking to rebuild the editor either as a cross-platform desktop application or as a web application.

After using Shreddit to delete my Reddit history periodically for some time now, I finally decided to make a cron job to automate it on a weekly basis. I use it to delete every post and comment that isn't whitelisted, which right now is just a tiny subreddit for a musician I like that I solely moderate and a pinned post explaining why I have a bunch of karma but barely any posts.

After setting this up, it got me curious as to what tasks other people automate in their lives in order to streamline their workflows and eliminate minor (or major) routine tasks.

So, what do you automate, and how did you go about doing it?

I know this has been posted before, but I was going through old posts about blogging and at least half the blogs linked in the comments were offline now, so I thought I'd bring this topic back to light.

Do you run your own personal blog, and if so, could you share some details?

• Is it self-hosted, or do you rent server space?

• Do you use Wordpress or another blog platform like that, publish through other means like a flat-file CMS, or did you build it from scratch?

• What topics do you write about?

• How consistently do you post; or alternatively, why don't you post as often as you would like to?

• Do you keep analytics, or do you write regardless of how many clicks you get?

• Is your site monetized with ads or otherwise?

• How popular is your blog on average?

• How do you keep up with other writers' posts?

I'm bringing this up because it seems like most places around the web centered on blogging are more in it for the money rather than for the content. Places like /r/blogging and the like are all talk about how to maximize views, earn revenue, and find your niche. I'd love to see some discussion more geared towards the content and construction of individual blogs, as opposed to people trying the next "get rich quick" scheme on their lists of passive income opportunities.

Personally, I have multiple blogs for the sole purpose of giving me a platform to voice my opinions or share things that interest me without being constrained to a centralized platform like Twitter or Medium. I'd love to hear what you have all made and/or shared online, as well as the process behind making it happen.

Hi All,

I have recently completed a software archaeology project, reverse engineering Space Invaders si78c, and would like to cast around for opinions as to which game(s) to do next.

I am currently thinking of doing either Pacman, Donkey Kong or Galaga but am willing to entertain suggestions about other games of a similar vintage. Please go into detail as to why you think it's an important title.

Eventually I would like to tackle bigger games from the home micro / console market, but they are most likely out of scope for now.

Please note, this is very labour intensive work, taking several months / years at a time depending on title complexity, and I will most likely only do a handful of these (barring any great advances) in my lifetime.

Cheers,
Jason

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?