RSS

Posts in 2021

  • Most votes on ssl questions 2

    May 01, 2021 in FAQ

    Most votes on ssl questions 2. #11 How to determine SSL cert expiration date from a PEM encoded certificate? #12 Is an HTTPS query string secure? #13 How to create an HTTPS server in Node.js? #14 Could not establish trust relationship for SSL/TLS secure channel – SOAP #15 curl: (60) SSL certificate problem: unable to get local issuer certificate #16 InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately #17 How do I set GIT_SSL_NO_VERIFY for specific repos only? #18 Warning about SSL connection when connecting to MySQL database #19 urllib and "SSL: CERTIFICATE_VERIFY_FAILED" Error #20 Powershell Invoke-WebRequest Fails with SSL/TLS Secure Channel

    Read all the top votes questions and answers in a single page. #11: How to determine SSL cert expiration date from a PEM encoded certificate? (Score: 381) Created: 2014-01-23 Last updated: 2019-12-11 Tags: linux, bash, ssl, openssl, certificate If I …

    Read more

  • Most votes on ssl questions 10

    May 01, 2021 in FAQ

    Most votes on ssl questions 10. #91 How can I generate a self-signed certificate with SubjectAltName using OpenSSL? #92 How can I test https connections with Django as easily as I can non-https connections using 'runserver'? #93 bypass invalid SSL certificate in .net core #94 ASP.NET MVC RequireHttps in Production Only #95 Keystore type: which one to use? #96 SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch #97 Java client certificates over HTTPS/SSL #98 How can I convert a PFX certificate file for use with Apache on a linux server? #99 Javax.net.ssl.SSLHandshakeException: javax.net.ssl.SSLProtocolException: SSL handshake aborted: Failure in SSL library, usually a protocol error #100 Disable SSL fallback and use only TLS for outbound connections in .NET? (Poodle mitigation)

    Read all the top votes questions and answers in a single page. #91: How can I generate a self-signed certificate with SubjectAltName using OpenSSL? (Score: 122) Created: 2014-01-31 Last updated: 2017-11-01 Tags: ssl, openssl, ssl-certificate, …

    Read more

  • Most votes on ssl questions 1

    May 01, 2021 in FAQ

    Most votes on ssl questions 1. #1 How to create a self-signed certificate with OpenSSL #2 Getting Chrome to accept self-signed localhost certificate #3 Are HTTPS URLs encrypted? #4 How to get .pem file from .key and .crt files? #5 Resolving javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed Error? #6 pip install fails with "connection error: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:598)" #7 Convert .pem to .crt and .key #8 Trusting all certificates using HttpClient over HTTPS #9 Python Requests throwing SSLError #10 SSL certificate rejected trying to access GitHub over HTTPS behind firewall

    Read all the top votes questions and answers in a single page. #1: How to create a self-signed certificate with OpenSSL (Score: 1509) Created: 2012-04-16 Last updated: 2018-12-28 Tags: ssl, openssl, certificate, ssl-certificate, x509certificate …

    Read more

  • Most votes on sqlite questions 9

    May 01, 2021 in FAQ

    Most votes on sqlite questions 9. #81 How to convert image file data in a byte array to a Bitmap? #82 Delete column from SQLite table #83 Convert MySQL to SQlite #84 SQLiteDatabase.query method #85 auto create database in Entity Framework Core #86 Change from SQLite to PostgreSQL in a fresh Rails project #87 Set default value of an integer column SQLite #88 Convert NSData to String? #89 SQLite DateTime comparison #90 Android: upgrading DB version and adding new table

    Read all the top votes questions and answers in a single page. #81: How to convert image file data in a byte array to a Bitmap? (Score: 127) Created: 2011-10-01 Last updated: 2020-12-23 Tags: android, arrays, sqlite, bitmap I want to store image in …

    Read more

  • Most votes on sqlite questions 8

    May 01, 2021 in FAQ

    Most votes on sqlite questions 8. #71 Is there type Long in SQLite? #72 How do you rename a table in SQLite 3.0? #73 How can I add the sqlite3 module to Python? #74 SQLite Reset Primary Key Field #75 Select random row from a sqlite table #76 SQLite select where empty? #77 SQLite error 'attempt to write a readonly database' during insert? #78 Import CSV to SQLite #79 Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine #80 Could not load file or assembly 'System.Data.SQLite'

    Read all the top votes questions and answers in a single page. #71: Is there type Long in SQLite? (Score: 134) Created: 2011-12-29 Last updated: 2016-12-29 Tags: android, sqlite I want to create a table with the column type Long instead of Integer. …

    Read more

  • Most votes on sqlite questions 7

    May 01, 2021 in FAQ

    Most votes on sqlite questions 7. #61 Why do you need to create a cursor when querying a sqlite database? #62 SQLite in Android How to update a specific row #63 SQLite with encryption/password protection #64 How to use SQL Order By statement to sort results case insensitive? #65 How do I add a foreign key to an existing SQLite table? #66 Is an index needed for a primary key in SQLite? #67 Get generated id after insert #68 String concatenation does not work in SQLite #69 How do I view the SQLite database on an Android device? #70 How can I get dict from sqlite query?

    Read all the top votes questions and answers in a single page. #61: Why do you need to create a cursor when querying a sqlite database? (Score: 150) Created: 2011-06-11 Last updated: 2017-12-07 Tags: python, sqlite, cursor I’m completely new to …

    Read more

  • Most votes on sqlite questions 6

    May 01, 2021 in FAQ

    Most votes on sqlite questions 6. #51 Get boolean from database using Android and SQLite #52 sqlite alter table add MULTIPLE columns in a single statement #53 Pros and Cons of SQLite and Shared Preferences #54 Android search with Fragments #55 Create SQLite Database and table #56 How to delete SQLite database from Android programmatically #57 No module named _sqlite3 #58 Copying data from one SQLite database to another #59 How to have an automatic timestamp in SQLite? #60 Sqlite LIMIT / OFFSET query

    Read all the top votes questions and answers in a single page. #51: Get boolean from database using Android and SQLite (Score: 173) Created: 2010-11-03 Last updated: 2016-01-20 Tags: java, android, sqlite, boolean How can I obtain the value of a …

    Read more

  • Most votes on sqlite questions 5

    May 01, 2021 in FAQ

    Most votes on sqlite questions 5. #41 SQLite Concurrent Access #42 Escape single quote character for use in an SQLite query #43 How do I dump the data of some SQLite3 tables? #44 How Scalable is SQLite? #45 SQLite table constraint - unique on multiple columns #46 SQLite: How do I save the result of a query as a CSV file? #47 What is a good choice of database for a small .NET application? #48 How to delete all records from table in sqlite with Android? #49 List of tables, db schema, dump etc using the Python sqlite3 API #50 "Insert if not exists" statement in SQLite

    Read all the top votes questions and answers in a single page. #41: SQLite Concurrent Access (Score: 195) Created: 2010-10-30 Last updated: 2018-01-30 Tags: sqlite Does SQLite3 safely handle concurrent access by multiple processes reading/writing …

    Read more

  • Most votes on sqlite questions 4

    May 01, 2021 in FAQ

    Most votes on sqlite questions 4. #31 Best way to work with dates in Android SQLite #32 Quick easy way to migrate SQLite3 to MySQL? #33 How to concatenate strings with padding in sqlite #34 sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied #35 Unable to load DLL 'SQLite.Interop.dll' #36 Does it matter what extension is used for SQLite database files? #37 Mac SQLite editor #38 sqlite database default time value 'now' #39 Creating stored procedure and SQLite? #40 How to retrieve inserted id after inserting row in SQLite using Python?

    Read all the top votes questions and answers in a single page. #31: Best way to work with dates in Android SQLite (Score: 238) Created: 2011-09-09 Last updated: 2014-06-29 Tags: android, sql, database, sqlite, date I’m having some trouble …

    Read more

  • Most votes on sqlite questions 3

    May 01, 2021 in FAQ

    Most votes on sqlite questions 3. #21 How do I rename a column in a SQLite database table? #22 INSERT IF NOT EXISTS ELSE UPDATE? #23 Create table in SQLite only if it doesn't exist already #24 Any good ORM tools for Android development? #25 How do I unlock a SQLite database? #26 Version of SQLite used in Android? #27 How can one see the structure of a table in SQLite? #28 How to delete or add column in SQLITE? #29 Is there a .NET/C# wrapper for SQLite? #30 sqlite3-ruby install error on Ubuntu

    Read all the top votes questions and answers in a single page. #21: How do I rename a column in a SQLite database table? (Score: 304) Created: 2009-04-30 Last updated: 2017-05-23 Tags: sqlite, alter-table I would need to rename a few columns in some …

    Read more