Παρουσίαση με Ετικέτες

HowTo: Install Python, PIP and cx_Oracle on MSYS2 / Windows
23 Αυγούστου 20 03:12 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   
Here’s how to install Python, PIP package installer and cx_Oracle extension module on MSYS2: $ pacman -S python warning: python-3.8.3-1 is up to date — reinstalling resolving dependencies… looking for conflicting packages… Packages (1) python-3.8.3-1 Total Installed Size:  108.66 MiB Net Upgrade Size:        0.00 MiB :: Proceed with installation? [Y/n] y … $ pacman -S […]
Δημοσίευση στην κατηγορία: , , , , , , , , , , , ,
MySQL DATETIME vs TIMESTAMP and the year 2038
01 Νοεμβρίου 19 09:45 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   
Judging from MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/datetime.html, it sounds best to use DATETIME rather than TIMESTAMP if you want your database to be future proof. After all 2038 is only 18+ years away. The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' […]
Δημοσίευση στην κατηγορία: , , , , , , , , , ,
How-to: get int value via ADO.net SqlDataReader using column name
21 Ιανουαρίου 19 08:54 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   
Based on Sam Holder’s answer at https://stackoverflow.com/questions/7388475/reading-int-values-from-sqldatareader/54296026, just contributed an extension method for fetching Int32 values via ADO.net’s SqlDataReader, without jumping through hoops (aka first fetch column ordinal [number] by name, then fetching the int value passing the column ordinal). Would be nice if Microsoft was providing such things out of the box. namespace adonet.extensions […]
Δημοσίευση στην κατηγορία: , , , , , , , ,
Fix: Windows Update 0x8e5e03fa, 0x800703fa errors
20 Νοεμβρίου 17 03:15 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   
Sometime ago, I was receiving errors 0x8e5e03fa and 0x800703fa on several pending updates at Windows 10’s Update pane (found at Settings / Updates & Security / Windows Update from the Start menu). The updates history wasn’t showing many more details, but could see Knowldege Base article numbers (KBxx) for some pending cummulative updates. Trying to […]
Δημοσίευση στην κατηγορία: , , , , , , , , ,
HowTo: Delete all nodes and relationships from Neo4j graph database
18 Απριλίου 15 02:54 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   
At a Neo4j question in http://stackoverflow.com/questions/19624414/delete-node-and-relationships-using-cypher-query-over-rest-api, a recent reply (older ones use obsolete Cypher syntax) says: Both START and the [r?] syntax are being phased out. It’s also usually not advised to directly use internal ids. Try something like: match (n{some_field:"some_val"}) optional match (n)-[r]-() delete n,r So, to delete all nodes (including disconnected ones) and […]
Δημοσίευση στην κατηγορία: , , , , , , , , ,

Search

Go

Ιστορικό Δημοσιεύσεων

Συνδρομές