Skip to content
#

SQL

sql logo

SQL stands for structured query language. It uses commands such as "select", "insert", "update", "delete". Some common relational database management systems that use SQL are: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, etc.

Here are 10,207 public repositories matching this topic...

bobvawter
bobvawter commented Jan 29, 2020

We should generalize the go-version-check.sh script to verify the presence and minimum versions of all tools required from the developer's environment.

The CONTRIBUTING.md file should be consulted (and likely refreshed) for a list of required dependencies. Additionally, it should be cross-checked against the dependencies listed in build/builder/Dockerfile.

For example, the upgrade to

surpavan
surpavan commented Dec 5, 2018

Some scripts are very big and editor will take long time to load into UI - for such scripts we save in drive and run them from workbench or some other tool - just by selecting the file and running it without loading it to editor.

Can we get that feature - probably in tools or some relevant location when we right click on the database name - to run the sql file on selected connection/DB inste

dsbrgg
dsbrgg commented Dec 11, 2019

Environment

Knex version: 0.20.3
Database + version: psql (PostgreSQL) 12.1
OS: macOS 10.14.6

Bug

The expirationChecker property on the connection object is not being called to recreate the connection object with new credentials for the database, even though the timeout was reached.

The first time that a request is being made, it works fine but after the timeout, it won't all

comicfans
comicfans commented Dec 12, 2019

Relevant system information:

  • OS: archlinux 64bit kernel 5.1.15
  • PostgreSQL version (output of postgres --version): postgres (PostgreSQL) 11.2
  • TimescaleDB version (output of \dx in psql): 1.5.1
  • Installation method: compile from source

Describe the bug

before upgrade, I'm using timescaledb 1.3, pg_dump gives no warning

pg_dump -U myname --format=custom 
dougmitarotonda
dougmitarotonda commented May 9, 2019

In the Features section of the documentation for version 0.5.3, it says

"Transactions: t = Database.transaction(); t.commit()."

However, I get an error when trying to do this:

>>> url = '...'
>>> db = records.Database(url)
>>> t = db.transaction()
>>> t.commit()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: '_GeneratorContextManager'
JeanGolang
JeanGolang commented Feb 7, 2017

Hello Philip!
I think there is an issue with this part of the code of rqlite (store/store.go).

func (s *Store) Database(leader bool) ([]byte, error) {
	if leader && s.raft.State() != raft.Leader {
		return nil, ErrNotLeader
	}
	// Ensure only one snapshot can take place at once, and block all queries.
	s.mu.Lock()
	defer s.mu.Unlock()

	f, err := ioutil.TempFile("", "rqlilte-snap-
flyway
server
jeduardo824
jeduardo824 commented Jul 18, 2019

After facing an issue caused by Ransack interpreting 1/'t' as true and some unsuccessful research, I found about the sanitize args and the recommended way to skip them. The documentation never mentions that ransackable_scopes_sanitize_args must be a class method and the example shown defines an instance method.

I think that's worth a documentation update, making more clear how to use th

pddeveloper12
pddeveloper12 commented Jan 7, 2020

nopCommerce Version: 4.00, 4.10, 4.20

Steps to reproduce the problem:
Setup a multi-store
Go to Admin > Configuration > Setting > Catalog setting > on the "Search" section "Search page. Page size options" value is not saved in another store.

I have checked there is a very small change in the view page.

bug
devin-petersohn
devin-petersohn commented Jan 6, 2020

This will serve as a metaissue for several documentation issues needed to be cleaned up before the next release.

  • README updates
    • Update pandas API coverage - it hasn't been updated, even since new functionality was added
    • Make a pass at the README for clarity
    • Fix build label to master
    • Add some Advanced usage on README - how to start with custom ray/dask
    • [
surister
surister commented Jan 21, 2020

This is a reminder for me or a task if anyone wants :P

imagen

Basically, The last two questions aren't really regex's questions.

To do:

  • Move said questions to correct place.
  • Add new regex questions (Python related!)?
  • Maybe add a new ## Regex section, as it is a valuable skill
poco

Created by Donald D. Chamberlin, Raymond F. Boyce

Released 1986

Wikipedia
Wikipedia

Related Topics

database php mysql
You can’t perform that action at this time.