Mastouille

0 message0 participant0 message aujourd’hui

Neustradamus :xmpp: :linux:<a href="https://mastodon.social/tags/Roundcube" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Roundcube</a> 1.6.11 (stable) has been released (<a href="https://mastodon.social/tags/Webmail" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Webmail</a> / <a href="https://mastodon.social/tags/Mail" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Mail</a> / <a href="https://mastodon.social/tags/IMAP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IMAP</a> / <a href="https://mastodon.social/tags/SMTP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SMTP</a> / <a href="https://mastodon.social/tags/LDAP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LDAP</a> / <a href="https://mastodon.social/tags/Managesieve" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Managesieve</a> / <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a> / <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a> / <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> / <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> / <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> / <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OracleDB</a> / <a href="https://mastodon.social/tags/MSSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQL</a>) <a href="https://roundcube.net/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://roundcube.net/</a>

Tobias Frech<a href="https://fosstodon.org/@thjanssen123" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@thjanssen123</a> This post is full of pure gold if you're using <a href="https://ijug.social/tags/Hibernate" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Hibernate</a>. When optimizing your queries for a <a href="https://ijug.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OracleDB</a> keep in mind Oracle supports function-based indexes. Use the DBMS_STATS package to regularly create histograms for the indexes/the indexed table columns. When designing your data model remember Oracle does not index the null value. Also do not distort index histograms with default values (as a fix to the null problem). If handling larger datasets index range scans are key.

TimHey, <a href="https://freiburg.social/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Postgres</a>, <a href="https://freiburg.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a>, <a href="https://freiburg.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> and <a href="https://freiburg.social/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Oracle</a> pros,I have multiple workers polling a table containing jobs. If a worker receives a job, it locks it, processes it and then updates / removes the row.The issue is, that they always only should select the n next, with n being configurable, and the more workers there are, the more often they receive a result set with all results locked, preventing them from picking up work. This makes processing sometimes slower, when more nodes are added.I discovered "FOR UPDATE SKIP LOCKED" should resolve this issue, and did some testing which confirmed it on Postgres and on MySQL. From reading the documentation, this should not bring any downside, should it? I don't see more issues than with the "old" approach, if a worker stops. Am I missing something here, are there side effects which could be dangerous?<a href="https://freiburg.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://freiburg.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://freiburg.social/tags/oracledb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#oracledb</a>

Shmarkus<a href="https://mastodon.cloud/@jasongorman" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@jasongorman</a> I've seen a project where <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OracleDB</a> was replaced with <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> . The project was long and painful due to "optimized platform usage". I've created a <a href="https://mastodon.social/tags/poc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#poc</a> where I replaced postgre driver with <a href="https://mastodon.social/tags/neo4j" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#neo4j</a> but this was even harder due to no many-to-one support in the persistence layer.Haven't seen a project where frontend change was required (unless it was from <a href="https://mastodon.social/tags/jsp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#jsp</a> to some separate FE app)

Brian MatteyUpdated <a href="https://mastodonapp.uk/tags/Introduction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Introduction</a> <a href="https://mastodonapp.uk/tags/Introductions" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Introductions</a>, hashtags ahead …<a href="https://mastodonapp.uk/tags/TwitterExile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TwitterExile</a> <a href="https://mastodonapp.uk/tags/SoftwareEngineer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SoftwareEngineer</a> - <a href="https://mastodonapp.uk/tags/OpenVMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenVMS</a>, <a href="https://mastodonapp.uk/tags/Linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Linux</a>, <a href="https://mastodonapp.uk/tags/HP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HP</a>-UX, <a href="https://mastodonapp.uk/tags/OracleDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OracleDB</a>, <a href="https://mastodonapp.uk/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a>, <a href="https://mastodonapp.uk/tags/VirtualBox" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#VirtualBox</a> <a href="https://mastodonapp.uk/tags/RealAle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RealAle</a> (<a href="https://mastodonapp.uk/tags/Tring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Tring</a> especially), <a href="https://mastodonapp.uk/tags/RedWine" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RedWine</a> and <a href="https://mastodonapp.uk/tags/Whisky" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Whisky</a> (<a href="https://mastodonapp.uk/tags/SingleMalt" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SingleMalt</a>) <a href="https://mastodonapp.uk/tags/Curry" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Curry</a>, <a href="https://mastodonapp.uk/tags/IndianFood" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IndianFood</a>, <a href="https://mastodonapp.uk/tags/FullEnglish" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FullEnglish</a>, <a href="https://mastodonapp.uk/tags/ChocolateOrange" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ChocolateOrange</a> <a href="https://mastodonapp.uk/tags/SciFi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SciFi</a> <a href="https://mastodonapp.uk/tags/ScienceFiction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ScienceFiction</a> - <a href="https://mastodonapp.uk/tags/StarTrek" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#StarTrek</a>, <a href="https://mastodonapp.uk/tags/Orville" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Orville</a>, <a href="https://mastodonapp.uk/tags/StarWars" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#StarWars</a>, <a href="https://mastodonapp.uk/tags/Expanse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Expanse</a> etc. <a href="https://mastodonapp.uk/tags/CouchPotato" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CouchPotato</a> but love socialising down the <a href="https://mastodonapp.uk/tags/Pub" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Pub</a> Fedora <a href="https://mastodonapp.uk/tags/Hat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Hat</a> wearer <a href="https://mastodonapp.uk/tags/AgnosticAtheist" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AgnosticAtheist</a> <a href="https://mastodonapp.uk/tags/UKLabour" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UKLabour</a> voter (or <a href="https://mastodonapp.uk/tags/LibDem" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibDem</a> or <a href="https://mastodonapp.uk/tags/Greens" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Greens</a> to get Tories out) <a href="https://mastodonapp.uk/tags/Socialism" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Socialism</a> <a href="https://mastodonapp.uk/tags/FBPE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FBPE</a>

Recherches récentes

Options de recherche

Administré par :

Statistiques du serveur :

#OracleDB