Best way to organize data table

1) what is the best and intuitive way to provide the filtering option when the column is large?

One option would be to have a “add filter” button. The user clicks it, then selects the columns to filter, then finally the filter value/range. That way, you only show a list of filter fields that the user is interested in rather than them all in one go.

Another option, each column header should have a filter button. You click the button, it shows a popup where they select the filter value/range, then they apply it (update your results). If you use this method make sure it is very clear which columns have filters applied. Perhaps make them a different colour, and/or a line of disclaimer text above/below the results saying “one or more filters are applied to these results”, for example.

2) How to provide the sorting function to the user, the best way to know is to provide the sorting when the user clicks on the header.

Sorting by clicking column header makes sense, most users know that is how to sort.

However, you can’t just sort “the current page”. You need to apply the sort to all data and then only return the data relevant to the selected page.

web development – How do I organize my REST API codes along with the codes for generating the website?

Using github as an example, www.github.com is the website people visit and api.github.com is the REST api server programs will visit. But they probably share some codebase and in my case they share a lot.

We actually developed the rest server first for our mobile apps then we decided to develop a website because we had though there were quite some codes can be reused. But now codes are not clean at all and I am trying to refactor them.

The similarity between them and the problems I need to fix include:

First, the logic to access the database is basically the same. After get the data, the REST codes will just return them as JSON while the “website code” (without a better word to describe them) will feed the data to the template which then generates the html pages.

Second, the router logics share in common a lot.

Third, I need to make the deployment easy. We use nginx to direct REST request to the rest server and website request (again, without a better word) to the website server, which is different from the rest server(2 standalone servers).

So how do I organize the source codes to be DRY & be easy deployment ?

c# – How to organize database access logic for the infrastructure and application layer when avoiding ORM tools?

ORMs like Entity Framework do not preclude you from using Raw SQL queries.

If Entity Framework is a bit too much for your liking, consider using Dapper or any of a number of different micro-frameworks. These tools remove a lot of the hassle of making a connection to the database and managing query parameters without encountering Little Bobby Tables, allowing you to focus your time and effort on writing the SQL queries.

ORMs also serve as your Data Access Layer, abstracting CRUD operations away from the more interesting Service Layer of your application. If you still feel like writing your own Data Access Layer, you can still do so. You will need one class and four methods for each table in your database (Create, Read, Update & Delete).

The way you manage your connection can vary. Depending on how quickly MariaDB can open connections and whether or not it caches connections, you might want to just open a connection for each query. You could also do it at the Aggregate level if you’re practicing DDD. Or, you could simply open a connection and leave it open. It really all depends on your application and what you want to do with it.

One file per SQL statement sounds like a bit much. Try putting your SQL statements inside your entity classes; it’s a very convenient place to stash them.

Folder structures are largely a matter of taste. There’s no “standard,” and everyone does them differently.

Further Reading
P of EAA : Data Mapper
P of EAA : Repository
P of EAA : Service Layer

c# – How to organize my controllers in projects in .Net API?

I’m working on a project that is a API with many controllers and modules. Which of the following is the best architectural practice to organizing my API controllers by dll (.NET 4.7 WebAPI)? Why?

OBS: Each item is inside a module is a dll

  1. One dll for each controller. Each csproj contains only one Controller.cs file:

Module 1
— API Controller 1

— API Controller 2

— Domain
— Application
— Infra

Module 2
— API Controller 3

— API Controller 4

— Domain
— Application
— Infra

  1. Group controllers in projects by context

Module 1
— API

— Domain
— Application
— Infra

Module 2
— API

— Domain
— Application
— Infra

  1. Create only one csproj with all controllers.

Module 1
— Domain
— Application
— Infra

Module 2
— Domain
— Application
— Infra

API (controllers)

Note: I’m using DDD (as possible), separating my business rules by context. Each context has its layers: domain, application and infra.

I started centralizing all Controllers of all contexts in one api project. It started to be messy, so I break in separate projects. However, there is some performance issue or architectural pattern that should I follow to organize my project?

c# – How to organize my controllers in projects in .Net API?

I’m working on a project that is a API with many controllers and modules. Which of the following is the best architectural practice to organizing my API controllers by dll (.NET 4.7 WebAPI)? Why?

  1. One dll for each controller. Each csproj contains only one Controller.cs file
  2. Group controllers in projects by context
  3. Create only one csproj with all controllers.
  4. Another way?

Note: I’m using DDD (as possible), separating my business rules by context. Each context has its layers: domain, application and infra.

advanced custom fields – Organize media library into folders and get folders via WP Rest API?

I’m building a Vue/NuxtJS portfolio site that will hopefully use WordPress as a headless CMS. I’ve been searching for hours but can’t seem to come to a definitive solution.

I know it’s possible to organize the media library into folders through various plugins. I also know I can use something like ACF to add additional fields (although I’m not sure if ACF works with the media library). There are essentially two endpoints I need, and I’m not sure if it’s possible since WordPress removed the filter parameter from the API.

  1. Retrieve all folders and its cover image for the gallery index. For example, if there are four folders I’ve created in the media library, I’d like the endpoint to return an array of four objects that return folder title and cover image. The endpoint might look something like /wp-json/wp/v2/media/folders.
  2. Retrieve all images and size variations of those images for a specific folder. For example, if a user clicks into a specific gallery to see all of the images in that gallery. If a user clicks on a specific image, a Lightbox pops up to display a full-size version of that image. The endpoint might look something like /wp-json/wp/v2/media/folders/1.

I would greatly appreciate any guidance or suggestions anyone could provide!

Do I need to organize the links in XML Sitemap?

We use Yoast on the WordPress website and it generates an https://www.website.com/page-sitemap.xml, organized based on the last modified date.

Do we need to have fixed it based on our navigation menu?

computer architecture: can a threads example be used to organize the code in a logical way?

I'm looking for an example of where threads can be used for organizing the code to answer the following question:

Threads can be used to execute code in parallel, but also simply to organize the code in a logical way. Give an example of the latter.

I have the following example of some course notes:

The other reason for using multiple threads is code organisation. Here, the standard example
is that of a web server. A web server has to handle multiple clients at the same time. Yet, it is
convenient to implement the server as if there was a single client. Then, you ask the operating
system to run several copies of the same server, in parallel, one for each client

Is this example essentially saying that generally writing code using multiple threads is more conducive to "code organization" than a wireless alternative?

I feel like this example is pretty vague?

usability: what's the best way to organize my personal / work computer file / folder structure to organize by design?

It might not seem like a question from ux.stackexchange, but I really think UX designers may be the best people to answer something like that.

I want to organize the folder organization structure on my computer and am having trouble finding bibliography or complete systems / principles to help me with that.


What do I use my computer for?

Apart from personal use

I work on many self-initiated artistic projects (no clients), using many different file formats:

  • Simple images like .jpg, .png
  • Design formats like Photoshop, Illustrator, InDesign
  • Video projects like Premiere or Final cut and all the raw video files like .mov or .mp4
  • Write projects with many .TXT, .reduction, .source records

The number of my projects is calculated in tenths, while the individual pieces that comprise the projects (files) are thousands.


Ideally what I want is the following

  • A system that works on all operating systems (macOS, Windows, Linux) and that does not depend on other software to work
  • Single file location
  • Only one possible file location by design (no doubt when retrieving or storing)
  • The file location should not be linked to the location of a project (because sometimes a & # 39; file & # 39; becomes part of another project)
  • Easy to add new file types (that I haven't used yet)

Any suggestions on what works for you, or even & # 39; How should I think / what to focus on? & # 39; to solve the problem as well as books, systems or beginning That will broaden my understanding. You are more than welcome.

Organize a list based on a given item from that list

If I have these three lists:

list1={{0.01,87.,0.},{0.03,87.,0.18353},{0.1,87.,0.494987},{0.3,87.,0.899803},{1.,87.,1.08076},{3.,87.,1.10593},{10.,87.,1.04781},{10.,87.,1.02449},{10.,87.,0.964193},{30.,87.,1.0602},{30.,87.,1.04075},{30.,87.,1.05987},{100.,87.,1.14661},{100.,87.,1.00639},{100.,87.,1.09384},{300.,87.,1.067},{300.,87.,1.15047},{300.,87.,1.10715},{1000.,87.,1.05152},{1000.,87.,1.06942},{1000.,87.,1.17143},{3000.,87.,1.12162},{10000.,87.,1.13136}}

list2={{0.01,75.,0.},{0.03,75.,0.},{0.1,75.,0.0959691},{0.3,75.,0.37954},{1.,75.,0.678807},{3.,75.,0.90385},{10.,75.,0.965262},{10.,75.,1.01025},{10.,75.,1.01675},{30.,75.,1.04836},{30.,75.,1.11345},{30.,75.,1.09146},{100.,75.,1.16961},{100.,75.,1.19018},{100.,75.,1.16968},{300.,75.,1.20834},{300.,75.,1.22955},{300.,75.,1.19569},{1000.,75.,1.25479},{1000.,75.,1.32295},{1000.,75.,1.22151},{3000.,75.,1.28794},{10000.,75.,1.25897}}

list3={{0.01,55.,0.},{0.03,55.,0.},{0.1,55.,0.},{0.3,55.,0.},{1.,55.,0.},{3.,55.,0.},{10.,55.,0.},{10.,55.,0.},{10.,55.,0.},{30.,55.,0.},{30.,55.,0.},{30.,55.,0.},{100.,55.,0.},{100.,55.,0.},{100.,55.,0.},{300.,55.,0.0721335},{1000.,55.,0.214175},{3000.,55.,0.748622},{10000.,55.,1.05191}}

How can I make the list merge since they are arranged from the smallest number to the highest according to the first item in the list (ranging from 0.01 to 10,000) to get {0.01,87,0,0.01,75,0,0.01,55,0,.......10000.,87.,1.13136,10000.,75.,1.25897,10000.,55.,1.05191}

Thank you!