Bilal Shahid

MongoDB Howtos

  1. Connect MongoDB With PowerShell
  2. Check if MongoDB Is Installed on Windows
  3. Difference Between ObjectId and $Oid in MongoDB
  4. Locking in MongoDB
  5. Use an ORM in MongoDB
  6. Build a MongoDB REST API
  7. Convert a String to Date in MongoDB
  8. Import CSV Files in MongoDB
  9. Shutdown/Stop MongoDB

VBA Howtos

  1. Convert Text to Number in Microsoft Excel VBA
  2. Unsort Sorted Data in Microsoft Excel VBA
  3. Parsing XML in Microsoft Excel VBA
  4. Use for Each on an Array Using VBA
  5. Convert Integer to String Data Type in Microsoft Excel VBA
  6. Create a Progress Bar in Excel VBA
  7. Different Ways to Check if a Cell Is Empty in Microsoft Excel VBA
  8. Import CSV Into Access VBA
  9. Loop Through Files in a Folder Using VBA
  10. MsgBox in Microsoft Excel VBA
  11. On Error Statement in Microsoft Excel VBA
  12. Project Password in Microsoft Excel VBA
  13. Save as in Microsoft Excel VBA
  14. Use Regular Expressions in Excel VBA
  15. Clear the Immediate Window Using VBA
  16. Parse JSON With VBA
  17. Read a Text File Line by Line in VBA
  18. Reference Another Sheet in VLookup Using VBA
  19. Convert a Column Number to Letter in Excel Using VBA
  20. Create an Array From a Specific Range in Excel Using VBA
  21. Introduction to Comparison Operators in VBA
  22. Open a Workbook by Specifying Its Path in Microsoft Excel Using VBA
  23. VBA Copy Past Values

SQLite Howtos

  1. Procedure to Open a Database File From SQLite
  2. SQLite Data Types
  3. SQLite Describe a Table
  4. SQLite INSERT a New Record or UPDATE One if It Already Exists
  5. Variables in SQLite
  6. Encryption and Password Protection in SQLite
  7. JSON in SQLite
  8. Regex Operator in SQLite
  9. SQLite Electron Module
  10. Prevent Duplication in SQLite
  11. Temporary Tables in SQLite

PostgreSQL Howtos

  1. PostgreSQL Default Port
  2. Best Postgres Clients Available for Windows Users
  3. Create a Read Only User in PostgreSQL
  4. Drop Not Null Constraint in PostgreSQL
  5. Install and Start PostgreSQL Server on Mac
  6. Install and Troubleshoot the ODBC Driver for PostgreSQL
  7. Introduction to Views in PostgreSQL
  8. Log All PostgreSQL Queries
  9. PostgreSQL - Check Date and Time Relative to Today
  10. PostgreSQL Database Encryption
  11. Add PostgreSQL Database as a Maven Dependency
  12. Convert From Unix Epoch to the Date in PostgreSQL
  13. Insert Current Timestamp in PostgreSQL
  14. PostgreSQL Port 5432
  15. Convert Timezone in PostgreSQL Server
  16. Run PostgreSQL in Memory Only
  17. Select From Dual in PostgreSQL
  18. Transpose Columns to Rows in PostgreSQL
  19. Alternatives to DATEADD() in PostgreSQL
  20. Grant Privileges to the User in PostgreSQL
  21. Install PSQL Without Installing Full PostgreSQL
  22. The DISTINCT Clause in PostgreSQL
  23. The initdb Command in PostgreSQL
  24. Unnest in PostgreSQL
  25. Upgrade the PostgreSQL Server Version Without Losing Any Data
  26. Varchar vs Text in PostgreSQL
  27. Check if PostgreSQL Is Installed on Linux
  28. Database Cluster in PostgreSQL
  29. Array Length in PostgreSQL
  30. Delete All Table Rows in PostgreSQL
  31. Find and Delete Duplicate Records in a Database in PostgreSQL
  32. Limit Rows in PostgreSQL
  33. Order by Clause in PostgreSQL
  34. Use UTC Current Time as Default in PostgreSQL
  35. Start PostgreSQL Server on Windows
  36. Writing Case-Insensitive Queries in PostgreSQL
  37. Configuring PostgreSQL in Linux
  38. Create Role or User if It Does Not Exist in PostgreSQL
  39. Comment Characters in PostgreSQL
  40. NEXTVAL Function in PostgreSQL
  41. Select Random Rows in PostgreSQL
  42. Create a Pivot Table in PostgreSQL
  43. Rename a Table Inside a Schema in PostgreSQL
  44. Run PostgreSQL Queries in PSQL
  45. Save PL/pgSQL Output From PostgreSQL to CSV
  46. Terminate a PostgreSQL Connection
  47. Exit From the Command Line Utility in PostgreSQL
  48. Round an Average to 2 Decimal Places in PostgreSQL
  49. Compare Dates in Datetime Fields in PostgreSQL
  50. Drop Database Through PSQL in PostgreSQL
  51. Subtract a Day From a Timestamp Date in PostgreSQL
  52. Use NOT IN With Subquery in PostgreSQL
  53. Differences Between the IN and ANY Operators in PostgreSQL
  54. Foreign Key ON DELETE CASCADE in PostgreSQL
  55. Insert on Duplicate Update in PostgreSQL
  56. List All Tables in PostgreSQL INFORMATION_SCHEMA Table
  57. Remote Connection to Another Instance Using PSQL
  58. Add a Unique Constraint After Creating a Table in PostgreSQL
  59. Default Username/Password for PostgreSQL Server in Rails 4
  60. Extract Day of Week From Date Field in PostgreSQL
  61. Kill a Process ID in PostgreSQL
  62. SELECT if String Contains a Substring Match in PostgreSQL
  63. Concatenate Columns in PostgreSQL Using Select
  64. Upsert (Insert on Duplicate Update, Merge) in PostgreSQL With EXCLUDE Values
  65. Upsert (Merge, Insert on Duplicate Update) in PostgreSQL
  66. Auto Increment Values in PostgreSQL
  67. Foreign Key Syntax in PostgreSQL
  68. Single Query to Rename and Change Column Type in PostgreSQL
  69. Create Table if It Does Not Exist in PostgreSQL

C# Howtos

  1. URL Encoding in C#
  2. Interface vs Abstract Classes in C#
  3. Obtain a Distinct List Based on One or More Properties in C#
  4. Callback in C#
  5. Draw Circles in C#
  6. Post JSON to a Server in C#
  7. Check for the Existence of a Dictionary Key in C#
  8. Implement a Read-Only Property in C#
  9. Toggle a Boolean Variable in C#
  10. Swap Variable Values Without the Use of Temporary Variable in C#
  11. Convert a Dictionary to JSON String in C#
  12. Implement a Property in an Interface in C#
  13. Method Groups in C#
  14. Convert String to Double in C#
Author: Bilal Shahid
Bilal Shahid avatar Bilal Shahid avatar

Hello, I am Bilal, a research enthusiast who tends to break and make code from scratch. I dwell deep into the latest issues faced by the developer community and provide answers and different solutions. Apart from that, I am just another normal developer with a laptop, a mug of coffee, some biscuits and a thick spectacle!