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

  1. This role sounds exciting, especially with the focus on optimizing such a critical industry through innovative technology. With my busy schedule, balancing work and learning new skills is challenging. That's why I might pay someone to take my online English Communication class to stay ahead in communication while focusing on opportunities like this.

    ReplyDelete

Post a Comment

Popular posts from this blog

AWS Elasticache Memcached connection

https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/accessing-elasticache.html#access-from-outside-aws http://hourlyapps.blogspot.com/2010/06/examples-of-memcached-commands.html Access memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/GettingStarted.AuthorizeAccess.html Zip include hidden file https://stackoverflow.com/questions/12493206/zip-including-hidden-files phpmemcachedadmin ~ phpMyAdmin or phpPgAdmin ... telnet mycachecluster.eaogs8.0001.usw2.cache.amazonaws.com 11211 stats items stats cachedump 27 100 https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/VPCs.EC.html https://lzone.de/cheat-sheet/memcached VPC ID Security Group ID (sg-...) Cluster: The identifier for the cluster memcached1 Creation Time: The time (UTC) when the cluster was created January 9, 2019 at 11:47:16 AM UTC+7 Configuration Endpoint: The configuration endpoint of the cluster memcached1.ahgofe.cfg.usw1.cache.amazonaws.com:11211 St...

Notes Windows 10 Virtualbox config, PHP Storm Japanese, custom PHP, Apache build, Postgresql

 cmd => Ctrl + Shift + Enter mklink "C:\Users\HauNT\Videos\host3" "C:\Windows\System32\drivers\etc\hosts" https://www.quora.com/How-to-create-a-router-in-php https://serverfault.com/questions/225155/virtualbox-how-to-set-up-networking-so-both-host-and-guest-can-access-internet 1 NAT + 1 host only config https://unix.stackexchange.com/questions/115464/how-to-properly-set-up-2-network-interfaces-in-centos-running-in-virtualbox DEVICE=eth0 TYPE=Ethernet #BOOTPROTO=dhcp BOOTPROTO=none #IPADDR=10.9.11.246 #PREFIX=24 #GATEWAY=10.9.11.1 #IPV4_FAILURE_FATAL=yes #HWADDR=08:00:27:CC:AC:AC ONBOOT=yes NAME="System eth0" [root@localhost www]# cat /etc/sysconfig/network-scripts/ifcfg-eth1 # Advanced Micro Devices, Inc. [AMD] 79c970 [PCnet32 LANCE] DEVICE=eth1 IPADDR=192.168.56.28 <= no eff => auto like DHCP #GATEWAY=192.168.56.1 #BOOTPROTO=dhcp BOOTPROTO=static <= no eff ONBOOT=yes HWADDR=08:00:27:b4:20:10 [root@localhost www]# ...

Rocket.Chat DB schema

_raix_push_notifications avatars.chunks avatars.files instances meteor_accounts_loginServiceConfiguration meteor_oauth_pendingCredentials meteor_oauth_pendingRequestTokens migrations rocketchat__trash rocketchat_cron_history rocketchat_custom_emoji rocketchat_custom_sounds rocketchat_import rocketchat_integration_history rocketchat_integrations rocketchat_livechat_custom_field rocketchat_livechat_department rocketchat_livechat_department_agents rocketchat_livechat_external_message rocketchat_livechat_inquiry rocketchat_livechat_office_hour rocketchat_livechat_page_visited rocketchat_livechat_trigger rocketchat_message rocketchat_oauth_apps rocketchat_oembed_cache rocketchat_permissions rocketchat_raw_imports rocketchat_reports rocketchat_roles rocketchat_room rocketchat_settings rocketchat_smarsh_history rocketchat_statistics rocketchat_subscription rocketchat_uploads system.indexes users usersSessions https://rocket.chat/docs/developer-guides/sc...