warren | Links to lose yourself in , curated from HN and other sources | Awesome List library

In this University Database:

i am using python json and i want to let my Python code search for specefic Keywords in a JSON-File.

Basically it should search for the "profilename" and then go one line down and print the email of the profile out.

following are my files for html, .ts and json . As json data was very extensive therefore i have just added a few states and their cities. my 1st dropdown is showing all states. Now I want to match my 1st dropdown's selected value of state with a key "state" in "cities" object in my json file so i can populate 2nd dropdown with cities relevant to that state. and I want to do this in function "getCitiesForSelectedState". please help me find solution for this.

//.ts file

I have some tables in my database and I'm trying to transact between them. My aim is to show the project name and the employees in that project in the form of cards on my projects page as in the image below. (Other than the method I mentioned, if there are better ways to do this, I ask you to share.)

When trying to do this, the first thing that came to my mind was to use leftJoin. Together with the projects, I thought of pulling the users in that project together and showing them by using foreach nested. If I just want to shoot projects, there will be no problem and the first 4 projects come and everything works fine. But since I needed to attract the users in that project along with my projects, when I used leftJoin, I got an output as you can see below. I had to use pagination as I needed to show 4 projects per page, and when I used pagination, the lines that came in were inconsistent. While waiting for 4 projects and their employees to arrive, the first 4 lines came. (3 employees of 1 project and the first employee of the other project have arrived.)

My code:

Does anybody use the w2ui.com component library? There is a cool input component (called combo) that filters a list as you type.

But it doesn't seem to work when it is inside of a popup. When you type in the input box, nothing appears in the filter like it does in the demo.

Here is my javascript:

I'm getting this error message in my table view controller class

value of uitableviewcell has no member delegate

Here is an image of the error.

Is there anything that should be changed in my code?

I'm trying to find the fastest way to return the index of a given element in a sorted array. np.searchsorted() seems to be specifically designed for the job. It uses binary search, which should be faster than the generic np.where(), which I'm assuming needs to loop through the entire array in O(N). However to my surprise, np.searchsorted() takes the same amount of time as np.where(), even for large arrays. Here's a MWE:

I am doing a problem that requires me to balance any binary search tree, with a criteria that the left and right subtree on each level should have the same amount of nodes or at most 1 node difference

How can I approach this problem? So far I have transformed the tree into a linked list.. and thats it. Im pretty sure thats the first step but not too sure. I have looked everywhere for resources, but the closest thing I could find was day-stout-warren algorithm which balances based on height and not amount of nodes.

I am just looking for pseudocode

I have a database table (table A) looks like this, in SQL Server 2016:

TableA: