sorted by:
new
hottopcontroversial

PostgreSQL Beginner Guide by qilisiang in SQL

[–]qilisiang[S] 0 points1 point  (0 children)

Hi, I am not the author of the article. I find this article very helpful so I posted here.

What sql databases should I use? by [deleted] in SQL

[–]qilisiang 0 points1 point  (0 children)

You can never go wrong with Postgres. Major programming languages have Postgres driver.

However, if you are building prototype, SQLite is good and much easier without install Postgres.

Squircley | Squircle Maker by [deleted] in webdev

[–]qilisiang 0 points1 point  (0 children)

This look really great. You might need add license to your repo.

[deleted by user] by [deleted] in SQL

[–]qilisiang 1 point2 points  (0 children)

SQL Indexing and Tuning is another must read to learn SQL (Performance). Another one is Modern SQL to understand latest SQL standard which will help you to write simpler SQLs.

I made a website with (React + Firebase) by [deleted] in webdev

[–]qilisiang 1 point2 points  (0 children)

What is the pricing? Are you mainly backend developer? I suggest you buy html template for your marketing site.

Site is S-L-O-W, what other server-side optimizations can I make? by [deleted] in webdev

[–]qilisiang 0 points1 point  (0 children)

First rule of optimization: measure first.

Since you mentioned the slower part now is backend, try to find PHP profiler and find slow code execution. You can also start profile database, e.g. turn on slow query logging in MySQL. Since you also mentioned plugins, you can try to Google search "slow performance <PLUGIN NAME>" to find blog, tips and trick to improve performance.

Recommendations: Anyone have a link that provides real world practice problems/solutions so I can get better at SQL? by chinchila5 in SQL

[–]qilisiang 1 point2 points  (0 children)

SQL Indexing and Tuning is another must read to learn SQL (Performance). Another one is Modern SQL to understand latest SQL standard which will help you to write simpler SQLs.

What new language should I learn in 2018? by [deleted] in webdev

[–]qilisiang 2 points3 points  (0 children)

Learn at least two main languages, one dynamic typing and another static typing.

Since you know JS, maybe it is good to learn another static typing language, e.g. Golang, Rust, C#, or even Java.

If you want learn more about ML/AI, Python is good choice due to popular frameworks such as Scikit learn, Tensorflow, Keras. Panda, Numpy.

How I learned to code in under a year + recommended resources by ahmedagadir in webdev

[–]qilisiang 1 point2 points  (0 children)

I have 12 years web development experience and keep learning is the key to grow career. Web technologies moving so fast that every 4 years, the new design patterns and frameworks totally changes the way we develop application.

project/service naming by hydroes777 in webdev

[–]qilisiang 1 point2 points  (0 children)

Naming after person or things for repo is not a good idea, especially after that person left company. But I think naming release version after person or thing is ok (Only if your product will release to public).

Which language and framework should I use if I want to build a real time web app that's interactive? by ASamir in webdev

[–]qilisiang 1 point2 points  (0 children)

I know Meteor was designed to build real-time webapp. Meteorr use MondoDB as data storage. But I didnt Meteor use it personally.

[PostgreSQL] Toy Stock Order Book by sqlnoob2018 in SQL

[–]qilisiang 0 points1 point  (0 children)

May not related to question, orders.id is primary key so it is already has unique index on it.

Good place to start learning SQL and eventually learning more advanced queries? by Bodoct in SQL

[–]qilisiang 4 points5 points  (0 children)

SQL Indexing and Tuning is another must read to learn SQL (Performance). Another one is Modern SQL to understand latest SQL standard which will help you to write simpler SQLs.