Pacharapol Withayasakpunt

Jan 28

A quick glance at PostgreSQL (Node.js driver) - better than doc-type NoSQL, and too good to be true

#docker #postgres #node #fulltextsearch

2 min read

array.map(): A better way 🧐 ?

for ... of is handy when serialize await async. Explicit ite...

Jan 29

Postgres backup using Docker

I tweaked a little with Python script, and used supervisord i...

Jan 29

The Easiest Way to Rate Limit a Python API

pip install? It would be almost import antigravity. For req...

Jan 27

You Are Using Emojis The Wrong Way ❌

I do think emoji should be avoided, except for the sake of co...

Jan 27

FAT32 vs. NTFS: Which Is Better?🔥🔥

Not sure about exFAT?

Jan 27

What if I don't use GET (and DELETE)?

About URL too long, I finally have seen it. With DELETE reque...

Jan 18

Which one is better? OOP or FL?

Why not both? Also, FP can avoid many errors.

Jan 18

What Javascript features are the most confusing to you?

WeakMap, WeakSet. I haven't even tried.

Jan 17

View last 250 Comments

Pacharapol Withayasakpunt

Jan 28

How do you plan your database in development, before migrating to production?

#help #database #devops #webdev

3 4

1 min read

Pacharapol Withayasakpunt

Jan 19

Constraints in SQLite FTS5 virtual table (unique, not null, constraints, compound)

#sqlite #sql #database #fts5

1 min read

Pacharapol Withayasakpunt

Jan 14

Why do many Javascript libraries or documentations keep using callback, var, == or function keywords?

#discuss #javascript #node #webdev

4 1

1 min read

Pacharapol Withayasakpunt

Jan 14

Why are C and C++ slow to build?

#discuss #c #go #computerscience

1 3

1 min read

Pacharapol Withayasakpunt

Jan 12

SQLite findings (on JSON and others)

#sqlite #sql #nosql #database

3 min read

Pacharapol Withayasakpunt

Jan 11

Would you use target="_blank"? And how many rels?

#discuss #webdev #security

6 2

1 min read

Pacharapol Withayasakpunt

Jan 9

How strong do passwords should practically be? And reuse of PIN?

#discuss #security #password #pin

1 min read

Pacharapol Withayasakpunt

Jan 8

Dark mode would be better if... (especially in dev.to)

#discuss #meta #darkmode #webdev

6 9

1 min read

Pacharapol Withayasakpunt

Jan 8

How complex are your URL querystrings? And how do you encode it? Also, do you validate it?

#discuss #webdev #restapi

1 min read

Pacharapol Withayasakpunt

Jan 6

Yet another way to convert a website (with backend) to desktop app

#webdev #desktop #go #crossplatform

1 min read

Pacharapol Withayasakpunt

Jan 6

Windows desktop app (Golang) triggers antivirus

#help #desktop #go #windows

1 min read

Pacharapol Withayasakpunt

Dec 29 '20

I finally have done it (without sudo) - the catastrophic command

#help #linux

2 5

1 min read

Pacharapol Withayasakpunt

Dec 28 '20

MongoDB Atlas Security (and IP Address range?)

#help #mongodb #security #database

1 min read

Pacharapol Withayasakpunt

Dec 26 '20

Reddit mass scraping via API

#javascript #node #tutorial #oauth

16 1

3 min read

Pacharapol Withayasakpunt

Dec 24 '20

What if I don't use GET (and DELETE)?

#discuss #restapi #webdev

7 11

1 min read

Pacharapol Withayasakpunt

Dec 23 '20

Case sensitivity in SQL

#sql #database #sqlite #unicode

1 min read

Pacharapol Withayasakpunt

Dec 21 '20

Do you use ORM? What about native SQL features?

#discuss #orm #sql #database

1 13

1 min read

Pacharapol Withayasakpunt

Dec 19 '20

How do YOU secure your remote database?

#discuss #digitalocean #database #security

5 1

1 min read

Pacharapol Withayasakpunt

Dec 19 '20

What's a best way to visualize Postgres schema?

#help #postgres #sql #hasura

1 1

1 min read

Pacharapol Withayasakpunt

Dec 19 '20

How much does Postgres cost?

#help #database #postgres #fts

4 2

1 min read

Pacharapol Withayasakpunt

Dec 18 '20

Do you use CDN? Why? Why not? And yes, it does work with build process and TypeScript. What about CSS?

#discuss #webdev #cdn #typescript

1 min read

Pacharapol Withayasakpunt

Dec 18 '20

When your JAMstack goes beyond Static, what your hosting of choice?

#discuss #webdev #jamstack

14 10

1 min read

Pacharapol Withayasakpunt

Dec 16 '20

Anyone else NEVER create a Node.js project at Git root?

#discuss #vscode #vue #node

1 2

1 min read

Pacharapol Withayasakpunt

Dec 16 '20

When YOU make Static Site (with SSG), what additional APIs do YOU eventually have to use and how? (third-party or self-made)

#discuss #webdev #ssg #ssr

5 8

1 min read

Pacharapol Withayasakpunt

Dec 15 '20

Need help regarding self-hosted WordPress (installing plugins, FTPS?, markdown editor, backup?)

#help #wordpress #digitalocean #sysadmin

1 5

1 min read

Pacharapol Withayasakpunt

Dec 15 '20

Anyone really practically use Firestore?

#help #firebase #nosql

1 1

1 min read

Pacharapol Withayasakpunt

Dec 11 '20

Is it OK to tell users to Accept Cookies, or leave?

#discuss #webdev #law #cookies

9 6

1 min read

Pacharapol Withayasakpunt

Dec 11 '20

Dear vanilla JavaScript users, which version do you use? Transpiler?

#discuss #javascript #node #webdev

6 3

1 min read

Pacharapol Withayasakpunt

Dec 11 '20

`engineStrict: true` in package.json is problematic - DON'T

#npm #node #javascript #pnpm

1 min read

Pacharapol Withayasakpunt

Dec 9 '20

How does troll (tech) become cute?

#discuss #qt #history

3 5

1 min read

Pacharapol Withayasakpunt

Dec 8 '20

How do I override "prefer-color-scheme" media query on CSS I didn't make? (e.g. classless CSS)

#help #css #webdev

1 1

1 min read

Pacharapol Withayasakpunt

Dec 5 '20

How to humanize duration accurately in JavaScript, including weeks, months and years

#javascript #typescript #date #webdev

5 1

3 min read

Pacharapol Withayasakpunt

Dec 3 '20

What features would you want for a `q` Querystring parser? (e.g. full-text-search, or more?)

#discuss #search #fts #database

5 1

1 min read

Pacharapol Withayasakpunt

Dec 2 '20

PORT number changes from VSCode terminal (by exactly +1)

#help #wsl #windows #webdev

1 min read

Pacharapol Withayasakpunt

Dec 2 '20

Is fetch too low-level? Do you have a favorite wrapper?

#discuss #fetch #javascript #typescript

1 4

1 min read

Pacharapol Withayasakpunt

Dec 2 '20

Please explain why I need software architecture

#explainlikeimfive #fullstack #desktop #computerscience

11 24

1 min read

Pacharapol Withayasakpunt

Nov 30 '20

Windows equivalent of Conky - DesktopInfo

#windows #conky #desktopinfo #widget

3 min read

Pacharapol Withayasakpunt

Nov 27 '20

Shell (e.g. Bash) users before coming to Windows Terminal - which shell do you use?

#discuss #windows

6 6

1 min read

Pacharapol Withayasakpunt

Nov 27 '20

How do YOU configure Git for Windows?

#discuss #git #windows

9 3

1 min read

Pacharapol Withayasakpunt

Nov 27 '20

Merging images/PDF to create a new wholesome PDF file

#pdf #imagemagick #poppler

1 min read

Pacharapol Withayasakpunt

Nov 27 '20

How do change "org name" of a GitHub repo?

#help #github

2 2

1 min read

Pacharapol Withayasakpunt

Nov 26 '20

SQL table design for Arrays, Dates and Indexes - what I learnt from ORM

#sql #sqlite #nosql #orm

3 min read

Pacharapol Withayasakpunt

Nov 26 '20

Don't Promise.all() everything at once

#javascript #async

1 min read

Pacharapol Withayasakpunt

Nov 23 '20

Newer VSCode / Electron cannot embed YouTube, and probably cannot play video/audio.

#help #vscode #electron

1 min read

Pacharapol Withayasakpunt

Nov 21 '20

go mod, updating to latest versions, and gvm

#go

1 min read

Pacharapol Withayasakpunt

Nov 21 '20

How to write Godoc?

#discuss #go #vscode

3 2

1 min read

Pacharapol Withayasakpunt

Nov 21 '20

Golang doesn't recommend you do these; Golint prevented you from doing these; but they might actually be good.

#discuss #go #vscode

2 min read

Pacharapol Withayasakpunt

Nov 19 '20

Accessing WSL to-and-from Windows (I still have problems with "PORT" generated in Windows, accessing inside WSL)

#help #wsl

1 min read

Pacharapol Withayasakpunt

Nov 19 '20

Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

#discuss #sql #sqlite

1 min read

Pacharapol Withayasakpunt

Nov 19 '20

req.query (or req.params / req.body) to TypeScript enum

#help #typescript #webdev

1 min read

Pacharapol Withayasakpunt

Nov 16 '20

Git on Windows (vs *nix, via WSL2) - does "file mode" matter?

#help #git #wsl #windows

7 1

1 min read

Pacharapol Withayasakpunt

Nov 14 '20

WSL vs plain old VirtualBox

#wsl #windows #linux #virtualbox

9 5

2 min read

Pacharapol Withayasakpunt

Nov 14 '20

Can't get fcitx to work in WSL2. Also, Win10 multilingual input method sucks, nor does it work with WSL

#help #wsl #linux #windows

1 min read

Pacharapol Withayasakpunt

Nov 12 '20

varchar(n) - how big should n be?

#help #sql #database

2 4

1 min read

Pacharapol Withayasakpunt

Nov 4 '20

Markdown to PDF: missing pieces from various approaches, and beyond HTML

#pdf #markdown #latex #vscode

7 2

2 min read

Pacharapol Withayasakpunt

Oct 20 '20

Please ELI5 big data and privacy concerns, and possible black hacks

#explainlikeimfive #bigdata #privacy #ai

2 3

1 min read

Pacharapol Withayasakpunt

Oct 20 '20

Powerlevel10k CLI wizard to generate Oh-My-Zsh! theme

#zsh #vscode #terminal #linux

1 min read

Pacharapol Withayasakpunt

Oct 20 '20

What is required or should be done, according to PDPA / GDPR?

#discuss #privacy #ethics #gdpr

4 1

1 min read

Pacharapol Withayasakpunt

Oct 18 '20

Social Dilemma, a thoughtful, yet dangerous topic to discuss in general

#discuss #google #facebook #ethics

2 min read

DEV Community is a community of 561,546 amazing developers

Recent comments

array.map(): A better way 🧐 ?

Postgres backup using Docker

The Easiest Way to Rate Limit a Python API

You Are Using Emojis The Wrong Way ❌

FAT32 vs. NTFS: Which Is Better?🔥🔥

What if I don't use GET (and DELETE)?

Which one is better? OOP or FL?

What Javascript features are the most confusing to you?

Log in to continue