The driver used for the database connection should have connection settings that govern transaction behavior. The pyodbc driver for python, for example, has the “autocommit” setting. With autocommit set to “True”, the SQL Server session will autocommit transactions - each statement that opens a transaction will autocommit that transaction as it completes. Using the pyodbc driver, if autocommit is set to “False” the session will have implicit_transactions ON. A number of statements implicitly begin a transaction (unless the session is already within a transaction) in this mode. Note that some SELECT statements may avoid starting a transaction if they do not specify a table. Implicit transactions do not commit automatically when the statement which began them completes. Implicit transactions require a commit or rollback. More information about pyodbc here - but if using a different driver look for that driver’s documentation. https://github.com/mkleehammer/pyodbc/wiki/Database-Transaction-Management More information about implicit transactions here… https://docs.microsoft.com/en-us/sql/t-sql/statements/set-implicit-transactions-transact-sql?view=sql-server-ver16

Instead of a boolean attribute that shows if a row is being processed, add a timestamp with time zone attribute that you set to current_timestamp when you start processing a row. When looking for rows to process, add a WHERE condition like WHERE locked_at IS NULL OR locked_at < current_timestamp - INTERVAL '30 minutes' Then you have a lock that automatically expires after 10 minutes. If processing could take longer than 30 minutes, use a different interval.

Check your connection string. This Driver=Testserver should be DSN=Testserver if you're using a DSN. Otherwise use a DSN-less connection string.

UIs (such as Workbench) silent tack on a LIMIT to constrain the amount of output. This speeds up certain queries. I suspect this explains the alleged difference. Running the 'same' (or, in some cases, 'similar') twice in a row -- the second one may be much faster than the first. This is due to "caching". Run your queries both ways again. I suggest you look at SHOW CREATE TABLE; you may find that the table is not really ENGINE=MyISAM. 8.0 is seriously deprecating that old Engine. I recommend you take the hint and move to InnoDB. "long it takes to bring the data" -- That sounds like it includes the web page rendering. Instead, add code to actually capture the time before and after.

SELECT MAX(pincode1) AS pincode1, MAX(pincode2) AS pincode2, city FROM tbl GROUP BY city;

There was a https://github.com/termux/termux-packages/issues/10808#issuecomment-1137229251 . To install the up to date version of numpy (1.22.4), simply run MATHLIB="m" pip install numpy And numpy wheel will be build normally. Your second error (with [...]/https) seems an Internet connection problem, but not sure.

May be you can do something like, get the current working directory and then combine it with your folder/filename to dynamically store your screenshots and logs in a specific folder relative to your project directory. I've used something like this in Java, System.setProperty("webdriver.chrome.driver", System.getProperty("user.dir") + "//chromedriver"); System.setProperty(FirefoxDriver.SystemProperty.BROWSER_LOGFILE, "FFLogs.txt"); File file = new File(System.getProperty("user.dir") + "//data/report-" + currentDate + ".csv"); String logFile = "./Target/Result-" + currentDate + ".jtl"; You can figure out something on the same line in Python with, driver.save_screenshot('./project_directory/save_screenshot.png') for storing in your current project/code directory. Note: I haven't worked with Python personally. But, you should be able to get the current directory and combine it as a string to the filename and parse it to save your screenshot/logs.

You can use https://github.com/SeleniumHQ/docker-selenium#video-recording that Selenium provides for video recording. Since you use docker images in "remote driver" manner you can use those images from python code as well.

Are you familiar with either language ? Are there co-workers or mentors that use either of these languages ? These are the types of questions you need to answer. Either language works fine with Selenium. If you are starting from scratch with no resources, I guess I would start with Python. The learning curve should be easier and the tutorials on the web should be more recent. Disclaimer --- I prefer Java but have been using it for a long time.

Since you have shared that there are no lookup errors or no such window exception, I think it might be an issue related to waiting time. This is why when you are running an individual test, it works fine. However, when you must be running multiple tests together, no wait time between the tests restricts the elements in the script to load. Let me know if you have added the wait time in-between the tests. And if adding wait time resolves your issues, I would like to hear it too. Also, here I am sharing a link for a similar query that I think might help you solve the problem https://www.typemock.com/answers/9694/running-all-tests-fails-some-tests-that-pass-individually

I think that I understood, and I had similar problem sometimes. So in this case I make a screenshoot and I take the xpath. Advice you need to use xpath simpler, use descendant,... Later I think you will have a new problem because this element only it's activated when the mouse is on the button, so you will need to use the library Actions ( https://medium.com/analytics-vidhya/python-selenium-all-mouse-actions-using-actionchains-197530cf75df ) to move it

Winappdriver can start executables (generally .exe files on Windows) I suspect your .msc file is a management saved console? If so, your actual executable would be mmc.exe (see e.g. here: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/mmc ) and your msc file an argument passed to mmc. I cannot test this, but I suspect something along these lines should solve your problem: from appium import webdriver desired_caps = {} desired_caps["app"] = "Wherever mmc is on your system\mmc.exe" desired_caps["appArguments"] = "C:\Desktop\vit extended\vit.msc" desired_caps["platformName"] = "Windows" driver = webdriver.Remote("http://127.0.0.1:4723", desired_caps)

1+GB size for a table with 2k rows means either it has huge text columns or it is highly bloated. Why don't you try running vacuum (analyze, full) against the database in question (if you haven't already done that) and re-check the size of your table again? VACUUM reclaims storage occupied by dead tuples. In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore it's necessary to do VACUUM periodically, especially on frequently-updated tables. Reference: https://www.postgresql.org/docs/current/sql-vacuum.html (PostgreSQL | Docs)

So this worked for me. I am relatively new to operating systems, so idk if there are any consequences that I'm unaware of. my solution: in terminal run: lsof -i:5432 sudo kill [PID] then rebuild the image and restart the container.

If one were to refer to the https://www.postgresql.org/docs/14/app-pgdump.html , one would discover that The -n and -N switches have no effect when -t is used, because tables selected by -t will be dumped regardless of those switches This seems to be exactly what is happening in your case. Contrary to what your comment says (--table="lime*" // redundant because), that switch actually overrides your schema specification. You should omit --table.

https://sqlite.org/cli.html says: Most of the time, sqlite3 just reads lines of input and passes them on to the SQLite library for execution. But input lines that begin with a dot (".") are intercepted and interpreted by the sqlite3 program itself. These "dot commands" are typically used to change the output format of queries, or to execute certain prepackaged query statements. This means if you are NOT using the CLI tool, for example, if you are using a query API, then those dot commands are not recognized. In other words, a dot command like .mode column is only used when writing queries in the sqlite CLI. If you want to use Python to do something similar, you would have to print the row yourself in a manner that aligns to columns. There are a couple of solutions for pretty-printing SQL query results in answers to this question: https://stackoverflow.com/questions/10865483/print-results-in-mysql-format-with-python

You can use rules in gitlab ci to control when you want to stage to be executed: https://docs.gitlab.com/ee/ci/yaml/index.html#rules e.g. set rules to only publish package when branch name is master. You can even use regex for filtering branch name. Hope it helps.

The python_app and mysql_db services/containers do not share a network namespace, thus they don't have the same localhost. Just use mysql_db as the hostname when connecting to the DB. I would recommend that your python code takes the DB hostname from an env var or command line argument. If you want to hardcode it, you can use something like db and then use the docker compose links aliasing feature which is documented https://docs.docker.com/compose/networking/#links to map db to the actual service name.

Are you using dockerized Mongodb like this? https://hub.docker.com/_/mongo you must replace localhost in this line of code with mongodb container name: client = MongoClient("mongodb://userName:password@/sampledb")

First of all, all data you can compile can be decompiled if you really want its a question about time, so you are correct here. I did not know where in the world you are, but I will recommend AWS, Azure, Google Cloud and some of the big players out there, its not cheap but here you are sure about the provider did not have your root access key. If you lose your root key or SSH key you its will require you can create a snapshot of the VM disk and restore it for a new VM. Both AWS, Azure and Google have a very high level of security and use a vary advance ACL for users so its your responsibility to have the security ofc. I'm located in EU and working for a company where GDPR is very important, so I will recommend one of the big players, and read the data protection privacy. If needed contact a lawyer to review the company based on your use case. If its still not securer enough for the data you working with, I will highly recommend locally hardware and here the customer shut pay for that hardware fee you spent based on your contract. that's my recommend