Posts in 2021
-
Most votes on debian questions 2
May 01, 2021 in FAQ
Most votes on debian questions 2. #11 Where are sudo incidents reported? #12 How do I download a package from apt-get without installing it? #13 How to build a Debian/Ubuntu package from source? #14 python-dev installation error: ImportError: No module named apt_pkg #15 Bash script prints "Command Not Found" on empty lines #16 CUDA incompatible with my gcc version #17 Call Python script from bash with argument #18 How to set up a Subversion (SVN) server on GNU/Linux - Ubuntu #19 Node.js app can't run on port 80 even though there's no other process blocking the port #20 Switching users inside Docker image to a non-root user
Read all the top votes questions and answers in a single page. #11: Where are sudo incidents reported? (Score: 140) Created: 2012-11-25 Tags: linux, command-line, permissions, debian, sudo Attempting something devious on my machine leads to …
-
Most votes on debian questions 10
May 01, 2021 in FAQ
Most votes on debian questions 10. #91 screen Cannot open your terminal '/dev/pts/0' - please check #92 /usr/bin/time –format output elapsed time in milliseconds #93 What does the colon (:) and dash (-) in an Ubuntu dpkg version number mean? #94 How to install docker in docker container? #95 Installing gitLab missing modernizer? #96 Error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory #97 Why is QsslSocket working with Qt 5.3 but not Qt 5.7 on Debian Stretch? #98 "skipping: no hosts matched" issue with Vagrant and Ansible #99 Piping password to smbpasswd #100 Adding a rule in iptables in debian to open a new port
Read all the top votes questions and answers in a single page. #91: screen Cannot open your terminal '/dev/pts/0' - please check (Score: 32) Created: 2014-01-24 Last updated: 2018-07-16 Tags: linux, shell, debian, gnu-screen I want to start a program …
-
Most votes on debian questions 1
May 01, 2021 in FAQ
Most votes on debian questions 1. #1 Version of Apache installed on a Debian machine #2 ps command doesn't work in docker container #3 Test a weekly cron job #4 How to search contents of multiple pdf files? #5 How to check the version before installing a package using apt-get? #6 How to kill zombie process #7 Setting Django up to use MySQL #8 What is difference between arm64 and armhf? #9 No module named _sqlite3 #10 How to set the locale inside a Debian/Ubuntu Docker container?
Read all the top votes questions and answers in a single page. #1: Version of Apache installed on a Debian machine (Score: 319) Created: 2008-11-14 Last updated: 2016-12-19 Tags: apache, debian, version How can I check which version of Apache is …
-
Most votes on database questions 9
May 01, 2021 in FAQ
Most votes on database questions 9. #81 What is the easiest way to ignore a JPA field during persistence? #82 Proper Repository Pattern Design in PHP? #83 What are the differences between B trees and B+ trees? #84 Error Code: 2013. Lost connection to MySQL server during query #85 How can I modify the size of column in a MySQL table? #86 Liquibase lock - reasons? #87 Altering column size in SQL Server #88 Rename a table in MySQL #89 How to check if a database exists in SQL Server? #90 What's faster, SELECT DISTINCT or GROUP BY in MySQL?
Read all the top votes questions and answers in a single page. #81: What is the easiest way to ignore a JPA field during persistence? (Score: 317) Created: 2009-08-15 Last updated: 2020-02-28 Tags: java, database, hibernate, jpa I’m essentially …
-
Most votes on database questions 8
May 01, 2021 in FAQ
Most votes on database questions 8. #71 What's the difference between TRUNCATE and DELETE in SQL #72 Does MySQL ignore null values on unique constraints? #73 Run PostgreSQL queries from the command line #74 What does character set and collation mean exactly? #75 Versioning SQL Server database #76 Django Model() vs Model.objects.create() #77 What are OLTP and OLAP. What is the difference between them? #78 Difference Between Schema / Database in MySQL #79 How big can a MySQL database get before performance starts to degrade #80 How to check if mysql database exists
Read all the top votes questions and answers in a single page. #71: What's the difference between TRUNCATE and DELETE in SQL (Score: 338) Created: 2008-09-26 Last updated: 2019-06-03 Tags: sql, database, truncate What’s the difference between …
-
Most votes on database questions 7
May 01, 2021 in FAQ
Most votes on database questions 7. #61 MySQL Error: : 'Access denied for user 'root'@'localhost' #62 Auto Generate Database Diagram MySQL #63 Rails :include vs. :joins #64 How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework? #65 PostgreSQL: Drop PostgreSQL database through command line #66 Django CharField vs TextField #67 What are the performance characteristics of sqlite with very large database files? #68 What datatype to use when storing latitude and longitude data in SQL databases? #69 T-SQL Cast versus Convert #70 Get the Last Inserted Id Using Laravel Eloquent
Read all the top votes questions and answers in a single page. #61: MySQL Error: : 'Access denied for user 'root'@'localhost' (Score: 358) Created: 2017-01-14 Last updated: 2017-01-14 Tags: mysql, sql, database, database-connection $ ./mysqladmin -u …
-
Most votes on database questions 6
May 01, 2021 in FAQ
Most votes on database questions 6. #51 Is storing a delimited list in a database column really that bad? #52 How to replace a string in a SQL Server Table Column #53 Best database field type for a URL #54 Postgres and Indexes on Foreign Keys and Primary Keys #55 What database does Google use? #56 Compare two MySQL databases #57 When and why are database joins expensive? #58 How to remove a field completely from a MongoDB document? #59 Should each and every table have a primary key? #60 What's the best strategy for unit-testing database-driven applications?
Read all the top votes questions and answers in a single page. #51: Is storing a delimited list in a database column really that bad? (Score: 384) Created: 2010-09-06 Last updated: 2017-03-22 Tags: database, database-design, database-normalization …
-
Most votes on database questions 5
May 01, 2021 in FAQ
Most votes on database questions 5. #41 How to select the nth row in a SQL database table? #42 Kill a postgresql session/connection #43 List of standard lengths for database fields #44 Storing Images in DB - Yea or Nay? #45 How to secure database passwords in PHP? #46 Room - Schema export directory is not provided to the annotation processor so we cannot export the schema #47 How should I tackle –secure-file-priv in MySQL? #48 How do I show the schema of a table in a MySQL database? #49 Can I have multiple primary keys in a single table? #50 How can I stop redis-server?
Read all the top votes questions and answers in a single page. #41: How to select the nth row in a SQL database table? (Score: 429) Created: 2008-08-19 Last updated: 2019-07-19 Tags: mysql, sql, database, oracle, postgresql I’m interested in …
-
Most votes on database questions 4
May 01, 2021 in FAQ
Most votes on database questions 4. #31 Elasticsearch query to return all records #32 Import SQL dump into PostgreSQL database #33 How do you rename a MongoDB database? #34 Postgres could not connect to server #35 How do you query for "is not null" in Mongo? #36 Best way to store password in database #37 MongoDB or CouchDB - fit for production? #38 What's the Hi/Lo algorithm? #39 Maximum length for MySQL type text #40 Error renaming a column in MySQL
Read all the top votes questions and answers in a single page. #31: Elasticsearch query to return all records (Score: 526) Created: 2012-01-12 Last updated: 2020-04-14 Tags: database, elasticsearch, query-string, elasticsearch-dsl I have a small …
-
Most votes on database questions 3
May 01, 2021 in FAQ
Most votes on database questions 3. #21 Skip certain tables with mysqldump #22 How do I restore a dump file from mysqldump? #23 Difference between partition key, composite key and clustering key in Cassandra? #24 What is the difference between Left, Right, Outer and Inner Joins? #25 What is this Javascript "require"? #26 How to shrink/purge ibdata1 file in MySQL #27 Database development mistakes made by application developers #28 Authentication plugin 'caching_sha2_password' cannot be loaded #29 Rails DB Migration - How To Drop a Table? #30 Copying PostgreSQL database to another server
Read all the top votes questions and answers in a single page. #21: Skip certain tables with mysqldump (Score: 600) Created: 2009-01-08 Tags: sql, mysql, database, mysqldump Is there a way to restrict certain tables from the mysqldump command? For …