database design – Find tables with columns with empty and NULL values in Postgresql

After some research I found an example where I can find tables and its columns with NULL values. But the function also returns true when the column is empty. It gives me errors when I try to add an or statement. How can I modify the function so it returns also true when the column contains blank values? This is the function I found:

create function has_nulls(p_schema in text, p_table in text, p_column in text)
                returns boolean language plpgsql as $$
declare 
  b boolean;
begin
  execute 'select exists(select * from '||
          p_table||' where '||p_column||' is null)' into b;
  return b;
end;$$;

social interfaces – How to make the user journey map more socializ-able and more integrated within the design process

Right now a 2 person team maintains the user journey map for our mobile app. It sits on a miro board and the only time others in the wider product team or org see it is once a quarter at the most during a detailed run-through of assumptions and pain points.

we’re hoping that we could make the user journey map more socializ-able and more integrated within the design process. My question is how do we do this?

One idea we had was to re-create an offline version in the office where everyone can see it. but given Covid this year people actually working at the office has drastically reduced.

design – Best way to implement functionality of a class

Ahhh the classic conundrum of OOP: “where do I put a method that intersects with multiple core classes?” My opinion: it doesn’t really matter, just be as consistent as you can. All you are striving for is for your coworkers to not struggle to hard when trying to spot these methods, especially if they are unsure if a bit of functionality already exists or not.

In your specific example, it looks like you are modeling a Library with your classes. Can I assume you have a Book class as well? My first instinct would be to create a class dedicated to operations for checking out books, and therefor keeping the methods out of the User and Book classes.

class BookLoanManager
    void CheckoutBook(User user, Book book)
    void ReturnBook(User user, Book book)
    void RenewBook(User user, Book book)

I want to design a WordPress movie site

Advertising

y u no do it?

Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

Starts at just $1 per CPM or $0.10 per CPC.

Hi, I want to design Like this site

Advertising

y u no do it?

Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

Starts at just $1 per CPM or $0.10 per CPC.

$100 design contest-72 hrs

We need a brand logo for our company called "SKAPES"
Its a company like Amazon, Walmart, Flipkart, Myntra
So the logo should be high quality brand logo use any colors

sample logos on this website
amazon.com
flipkart.com
myntra.com
walmart.com

Please post your entires below.
Thanks

design – Does presentation layer inlcude REST and SOAP services?

Please, consider three pictures, I found in internet:

enter image description here

enter image description here

enter image description here

I always thought, that REST and SOAP services are in service layer – see #1. However, if you look at #2, you’ll see, that presentation layer provides restful service. #3 shows, that presentation layer includes only REST services, but not SOAP.

So, does presentation layer include REST and SOAP services?

design patterns – DDD: Aggregate root too many lines of code

I am following the DDD principles and have these Aggregate root classes. The problem is that after some time my class contains 1400 lines of code which makes development experience a little bit worse.

Is there any recommended way by DDD how can I split this AggregateRoot class into few classes?

I know, you, it can be said that I should reduce my bounded context but that’s not the case. All the methods and fields in class belongs where it should belong just as every VO is created by the root method it contains quite many different public and private methods.