Skip to main content

Bash nohup without output, DB design junction table etc

https://stackoverflow.com/questions/10408816/how-do-i-use-the-nohup-command-without-getting-nohup-out

nohup command >/dev/null 2>&1   # doesn't create nohup.out
nohup command >/dev/null 2>&1 & # runs in background, still doesn't create nohup.out


Job description

Requirements:

5 years minimum of professional experience in Software Engineering. Experience with any or all of the following technologies is a plus: Node.js, React, TypeScript. Startup experience valued.

Our company:

Did you know that 90% of all goods globally are transported through a container, and the largest container vessels are 400 meters long and can transport 20,000 containers at a time? The container shipping industry is the back-bone and enabler of global trade, but it is struggling. At its core the industry is fundamentally inefficient: 50% of all container vessels globally are delayed coming into port, and key planning processes are done manually on a global scale. This leads to high operational costs, lost revenue, and unnecessarily high greenhouse gas emissions

Portchain is a 2 year old Danish container shipping startup devoted to help container carriers and terminals reduce operational complexity and optimize planning. We apply cutting-edge AI leading to both a better bottom line and less greenhouse gas emissions.

We are an international team of 15 people serving a global customer base and several of the largest companies in the industry. We have received $5M in funding to expand the team in order to serve our increasing customer traction.


More information: https://www.portchain.com/careers/full-stack-software-engineer/


About this job
Job type: Full-time
Experience level: Mid-Level, Senior
Role: Full Stack Developer
Industry: Agile Software Development, Computer Software, eCommerce
Company size: 1–10 people
Company type: Private
Technologies
phphtmlcssjavascriptlamp
Job description

Become part of our team and start working on innovative projects that actively shape the world of tomorrow’s eCommerce and online shopping.

signundsinn is a full-service agency for all things digital, eCommerce and Shopware. We currently work on a number of exciting digital projects that require to be treated with expertise and passion for the job - a job that could soon be yours!

To make your life and first days on the job easier, we will provide you with a comprehensive training and individual support from the get-go - so don’t worry if you don’t have the required skill set just yet.

Your tasks:

■ Development of high-performing and individually designed applications for our customers (B2C and B2B Shops)

■ Implementation of technical concepts and software applications

■ Identification of interfaces between B2C/B2B online shops and existing merchandise management systems on our client’s website

■ Direct communication with the technical service providers of these merchandise management systems

■ Performance optimization of all import interfaces

What we expect:

■ Proactive and innovative way of programming

■ High expertise in object-oriented programming with PHP

■ Previous experience with the creation of websites based on the LAMP technology (Linux/Apache/MySQL/PHP)

■ Previous practical experience with the eShop System of Shopware (or Magento), as well as the development of Shopware plugins and templating with Smarty

■ Knowledge of HTML5, CSS3 and jQuery

■ Confident handling and usage of development tools such as Git

■ Further beneficial is the knowledge of frameworks such as Zend or Symfony

What we provide:

■ An exciting work environment, including demanding, innovative digital projects for interesting clients

■ flat hierarchies and open communication

■ Regular internal and external training and coaching

■ Very positive working atmosphere amongst competent, highly motivated and open-minded colleagues

■ Short decision paths and room for your own creativity

■ Frequent team events

■ Flexible working hours

■ Optional certifications

You couldn’t tick off all of these boxes, but came close? You haven´t worked yet with Shopware but you worked with Magento or another eCommerce system?

We are still very much looking forward to your application (cover letter, CV including a photo of yourself, references) and would be more than happy to offer you additional training and coaching as suited for the position.


https://stackoverflow.com/questions/36116353/foreign-key-vs-intermediate-tables

This type of table is called a junction table and is used to represent many-to-many relationships. As far as I know, all states are within a single country, so there is no need to have a junction table. A state could simple have a country_id column. You are correct.

You might think the same of the "county" and "city" entities. At least in the United States, this is not strictly true (unless you follow the Census Bureau definitions). Some cities do span multiple counties.

As a write this, I am in New York County (more commonly known as "Manhattan"), which is part of New York City. New York City actually comprises five counties. Other cities also span counties, such as Chicago (Cook and DuPage counties), Atlanta (Fulton and Dekalb), and many other (listed on this Wikipedia page). New York City of course "wins", spanning five, more than any other ;)


Cool PHP fast extract array key => value to list of variables:
https://www.geeksforgeeks.org/php-extract-function/

https://www.noelherrick.com/blog/mysql-strict_all_tables-vs-strict_trans_tables

Position Responsibilities

    Setup development/build & deployment process & tool (CI/CD) and enforce development convention
    Participation in managing DevOps side of things of new applications and projects we
    work on.
    Work with high load applications.
    Design and build infrastructure on AWS, Azure, GCP.
    Monitor and maintain alive services and servers on Linux and Windows.
    Design highly available and fault tolerant environments.
    Help developers with deployment and bug investigation.
    Build and maintain backup and restore processes.
    Work on configuration management systems.
    Providing support level 2 for production system (troubleshooting, fixing or create L3 ticket for development team)
    Support internal users on IT system (office, operating system, network, VPN)

Your Skills and Experience

    Very fast learner
    Experience with build tools like Jenkins, AWS CodeBuild, Codepipline
    Experience on Kubernetes, Rancher, Microservice
    Experience in managing Git or other Git on cloud services
    A deep understanding of the Linux and Windows operating systems.
    Ability to debug and solve configuration, performance and reliability problems quickly; sometimes under pressure if there are issues that are directly affecting product users.
    Knowledge of standard methodologies: configuration management, monitoring, alerting, metrics.
    Knowledge of networks basis and work of TCP/IP.
    Knowledge of database administration (Postgres, Mongodb)
    3+ years of operational experience as System Administrator or System Engineer or DevOps engineer.
    Scripting and/or development skills to automate everything.
    Ability to automate routine processes using Python, Bash or PowerShell.
    Experience in administering IT on cloud systems like Office 365
    Good service attitude and proactive
    Proficient English
    Experience in Java/Spring Cloud/Spring Boot programming is prefered.


*** Master data , semi master data not match on Dev vs Production
My Area data  tend to be a master data ie. all province and locality inside a country. It rarely change.
But the problem is that I can not get all GLOBAL database of it. And It have to represent in Japanese...
So the only way is to build master data table evolved by the time, I mean each time new shop/area added or updated then master table update too to reflect these data.
This way work but the ID, area_id, locality_id etc. is changed since it auto increment or similar mechanism. And when you run application on Dev, Production environment it will be different.
The problem is one area but have different ID between environment it run. It may lead to bug or look like bug and hard to track and confirm data.
This way of data store somehow like Wordpress or noSQL DB way of working.
This is a interesting case on DB design. I see that if I can use the way Google store address_components (JSON) then it would match perfectly:

address_components {
{"long_name": "New York", "short_name": "NY",
types: ["administrative_level_1", "policical"]
}

So the key here is long_name and type administrative_level_1, when I tried to insert/update, firstly I can check these two properties.

But Relational DB (MySQL) this have to / should be stored as relation/flat table style. We can use JSON but I think it somehow weird and not common in RDBMS (?)


Eloquent soft delete

use Illuminate\Database\Eloquent\SoftDeletes;

class MyModel extends BaseModel
{

    public static $name = \App\Models\MyModel::class;
    use SoftDeletes;
...

Comments

Popular posts from this blog

Rand mm 10

https://stackoverflow.com/questions/2447791/define-vs-const Oh const vs define, many time I got unexpected interview question. As this one, I do not know much or try to study this. My work flow, and I believe of many programmer is that search topic only when we have task or job to tackle. We ignore many 'basic', 'fundamental' documents, RTFM is boring. So I think it is a trade off between the two way of study language. And I think there are a bridge or balanced way to extract both advantage of two method. There are some huge issue with programmer like me that prevent we master some technique that take only little time if doing properly. For example, some Red Hat certificate program, lesson, course that I have learned during Collage gave our exceptional useful when it cover almost all topic while working with Linux. I remember it called something like RHEL (RedHat Enterprise Linux) Certificate... I think there are many tons of documents, guide n books about Linux bu

Martin Fowler - Software Architecture - Making Architecture matter

  https://martinfowler.com/architecture/ One can appreciate the point of this presentation when one's sense of code smell is trained, functional and utilized. Those controlling the budget as well as developer leads should understand the design stamina hypothesis, so that the appropriate focus and priority is given to internal quality - otherwise pay a high price soon. Andrew Farrell 8 months ago I love that he was able to give an important lesson on the “How?” of software architecture at the very end: delegate decisions to those with the time to focus on them. Very nice and straight-forward talk about the value of software architecture For me, architecture is the distribution of complexity in a system. And also, how subsystems communicate with each other. A battle between craftmanship and the economics and economics always win... https://hackernoon.com/applying-clean-architecture-on-web-application-with-modular-pattern-7b11f1b89011 1. Independent of Frameworks 2. Testable 3. Indepe