DEV Community: ZakiMax

I'v just started Flutter project.

ZakiMax — Mon, 10 Jan 2022 06:06:53 +0000

I'v been developing in React for while a now.
However, it became necessary to develop a smartphone application for sales company.

I'm using Faker.js

ZakiMax — Wed, 23 Jun 2021 04:33:45 +0000

I'm using this to create seeding data on firebase.
https://www.npmjs.com/package/faker

NoSQL　Date Structure

ZakiMax — Fri, 18 Jun 2021 05:05:06 +0000

■Our Situation
We are developing a video distribution service in the sports domain & lifeStyle. This time, I', going to migrate from AWS EC2 to firebase CloudStore.

■Process
1 テストプロジェクトで一通りの機能を試す
Try out a set of functions in a test project.

2 まず既存DBを接続していない状態でもエラーが出ない状態にリファクタ
First, refactor the existing DB to a state where no errors occur even when it is not connected.

3 既存のDB構造をもとに一旦NoSQLでのDB構造を立てる
Create a NoSQL DB structure based on the existing DB structure.

4 一つずつfetchしている関数をfirebaseに置き換える
Replace the functions that are fetching one by one with firebase.

5 問題を都度修正
Fix problems on a case-by-case basis

▼firebase 公式You Tubeチャンネルから抜粋
・firestoreについて（this is best movie）
https://youtu.be/v_hR4K4auoQ

・SQL 構造を　Firebase 構造に変換するには
https://youtu.be/ran_Ylug7AE
　
・一般的な SQL のクエリを Firebase データベース用に変換
https://youtu.be/sKFLI5FOOHs

・結合について　
https://youtu.be/Idu9EJPSxiY

・非正規化
https://youtu.be/vKqXSZLLnHA

・このQiitaの記事も参考になりそう。
https://qiita.com/1amageek/items/d606dcee9fbcf21eeec6

What is transaction?

ZakiMax — Fri, 18 Jun 2021 03:18:48 +0000

It's multiple processes combined into one.

Consistency of results is required.

These multiple processes can't be separated.

The result of the execution is either success or failure.

What is NoSQL?

ZakiMax — Fri, 18 Jun 2021 02:49:17 +0000

Our team moving to NoSQL DB for my current project.(I've only used SOL originally...) So I'm going to think about it. Actually we plan to firebase.

My questions are ...
① What's good about NoSQL?
② What's bad about NoSQL?
③ I mean...actually what does SQL mean?
④ How do we design NoSQL DB...what is best practice?

① What's good about NoSQL?

Fast processing!
Easier!! to handle scale-out

② What's bad about NoSQL?

Data integrity is difficult to maintain
Data processing is difficult

③ I mean...actually what does SQL mean?

A database language for manipulating and defining data. ex...SELECT,INSERT,UPDATE,DELETE

④ How do we design NoSQL DB...what is best practice?

I don't know yet......................

Reference site
■Client Side Join
https://qiita.com/1amageek/items/afc1c0ceb15ffc2372fd
■What is RESTful API
https://qiita.com/NagaokaKenichi/items/0647c30ef596cedf4bf2#restful-api%E3%81%A8%E3%81%AF

What is CLI?

ZakiMax — Sun, 13 Jun 2021 03:15:29 +0000

On working, there're something I didn't understand "CLI".

I'was searching for this Answer.

The Answer I found is stand for Command Line Interface.

But I'm not sure.