Related articles:
Load more
Linux can seem like a very daunting environment. But it doesn’t have to be! With the two topics in this cheat sheet—the commands you’ll use on a daily basis and the useful help pages—you can easily navigate your Linux environment.
After over 30 years in the IT industry, he is now a full-time technology journalist. During his career, he has worked as a freelance programmer, manager of an international software development team, an IT services project manager, and, most recently, as a Data Protection Officer. Dave is a Linux evangelist and open source advocate. We would like to show you a description here but the site won’t allow us. Iexplorer 4 1 6.
Linux Commands
Although you can do most things in Linux these days by pointing and clicking, you still may want to try using Linux at the command prompt. This table shows you the commands that help you navigate your Linux system using only your keyboard.
In command-line SQL.Plus, you type a command and direct SQL.Plus to execute it by pressing the Return key. SQL.Plus processes the command and re-displays the command prompt when ready for another command. In i SQL.Plus, you type a command or a script into the Input area and click the Execute button to execute the contents of the Input area. UNIX and Linux (Method 1) UNIX and Linux (Method 2) UNIX and Linux (Returning values from SQL) Checking the Database is Up; Windows. To run a SQL script using SQL.Plus, place the SQL along with any SQL.Plus commands in a file and save it on your operating system. For example, save the following script in a file called 'C: emp.sql'.
Command | Description |
cat [filename] | Display file’s contents to the standard output device (usually your monitor). |
cd /directorypath | Change to directory. |
chmod [options] modefilename | Change a file’s permissions. |
chown [options] filename | Change who owns a file. |
clear | Clear a command line screen/window for a fresh start. |
cp [options] sourcedestination | Copy files and directories. |
date [options] | Display or set the system date and time. |
df [options] | Display used and available disk space. |
du [options] | Show how much space each file takes up. |
file [options] filename | Determine what type of data is within a file. |
find [pathname] [expression] | Search for files matching a provided pattern. |
grep [options] pattern [filesname] | Search files or output for a particular pattern. |
kill [options] pid | Stop a process. If the process refuses to stop, use kill -9 pid. |
less [options] [filename] | View the contents of a file one page at a time. |
ln [options] source [destination] | Create a shortcut. |
locate filename | Search a copy of your filesystem made at around 3am for the specified filename. |
lpr [options] | Send a print job. |
ls [options] | List directory contents. |
man [command] | Display the help information for the specified command. |
mkdir [options] directory | Create a new directory. |
mv [options] sourcedestination | Rename or move file(s) or directories. |
passwd [name [password]] | Change the password or allow (for the system administrator) to change any password. |
ps [options] | Display a snapshot of the currently running processes. |
pwd | Display the pathname for the current directory. |
rm [options] directory | Remove (delete) file(s) and/or directories. |
rmdir [options] directory | Delete empty directories. |
ssh [options] user@machine | Remotely log in to another Linux machine, over the network. Leave an ssh session by typing exit. |
su [options] [user [arguments]] | Switch to another user account. |
tail [options] [filename] | Display the last n lines of a file (the default is 10). |
tar [options] filename | Store and extract files from a tarfile (.tar) or tarball (.tar.gz or .tgz). |
top | Displays the resources being used on your system. Press q to exit. |
touch filename | Create an empty file with the specified name. |
who [options] | Display who is logged on. |
To access your CDs/DVDs:
The only thing missing is creating a new table with a CSV import. Super modern MySQL app! Modern mobile MySQL client is just what I needed! Has features not found in other apps in the store. Has support for multiple regions, workspaces etc. Outstanding developer support also. Soon to be the premier mobile client!
- If you’re in the GUI, the media should be automatically detected.
- On the command line, look in the
/media
You may need to use mount/media/cdrom, /media/dvdrom, or some other variant.
To remove your CDs/DVDs:
- In the GNOME 3 desktop, right-click the CD icon and choose Eject. If you’re using the KDE Plasma desktop, select the Device Notifier icon in the Panel, then select the CD icon to eject.
- On the command line, type umount /media/cdrom, where you should change cdrom to whatever you had to use to mount the item.
Linux Help Pages
To find help in Linux, try
- man -k [keyword]: Search a database for commands that involve the keyword. Can also be used as apropos [keyword].
- info [command]: Display a file’s help information in an alternate format.
- man [command]: Display a file’s help information.
- whatis [command]: Display a short blurb about the command.
- openSUSE: The openSUSE documentation provides a complete reference guide to both the openSUSE environment, and the GNOME 3 desktop environment. There’s also a user forum where users can post and answer specific questions about using openSUSE.
- Ubuntu: The official Ubuntu documentation provides basic information on how to get started with most common desktop tasks. Just look for the topic area you’re interested in and follow the thread. Ubuntu also has a wiki website, where Ubuntu users can contribute their own guides and tutorials.
Package Details: tableplus 0.1.64-1
Package Actions
- View PKGBUILD / View Changes
Git Clone URL: | https://aur.archlinux.org/tableplus.git (read-only, click to copy) |
---|---|
Package Base: | tableplus |
Description: | Modern, native, and friendly GUI tool for relational databases (Alpha) |
Upstream URL: | https://tableplus.com/ |
Keywords: | |
Licenses: | custom |
Submitter: | rew1red |
Maintainer: | rew1red (tableplus) |
Last Packager: | rew1red |
Votes: | 6 |
Popularity: | 0.39 |
First Submitted: | 2019-12-02 20:06 |
Last Updated: | 2020-08-24 14:01 |
Dependencies (3)
- gnome-keyring(gnome-keyring-git)
- gtksourceview3(gtksourceview3-git)
- libgee(libgee-git)
Sources (2)
techno-geek commented on 2019-12-31 20:15
Not a problem with the package, but do know that the PostgreSQL database type does not appear to be currently working.
rew1red commented on 2019-12-05 14:55
@NoD -- I'm sure, if only it were mine to fix! Tableplus is closed sourced software.
@chri -- Looks like the shasum changed upstream, but the version was not incremented by the author. I've updated the pkgbuild with the hash from the upstream repository, but the version remains 0.1-18.
chri commented on 2019-12-05 08:26
sha256sum for v0.1-18 has not been adapted in last commit:288d60d1019212badc0a01eb4ab6f67f97b88a17c581c07f6eb224c8d5adc050 tableplus_0.1-18_amd64.deb
Table Plus Linux Download
NoD commented on 2019-12-05 05:57
I know it's an alpha release.That's why I am reporting this stuff. To help you make it better. :)
rew1red commented on 2019-12-04 15:51
As of 0.1-16, all database connector libraries are statically linked and the aforementioned workaround or patched desktop shortcut are no longer required.
rew1red commented on 2019-12-04 15:40
@NoD--
Some of the issues you're encountering are related to the alpha-release nature of tableplus, and not the packaging. Until this morning, the author had dynamically linked against the libmysqclient library and included it in his release. I patched the desktop shortcut for tableplus in this pkgbuild so that said library would be accessible. It was a workaround, but got things working for us Arch users.
If you were to launch it directly, you'd need something like:
LD_LIBRARY_PATH=/opt/tableplus/resource/library/ /usr/local/bin/tableplus
With this said, it looks like the author has rebuilt the binary this morning, statically linking against libmysqlclient. Garageband 10 1 1 – complete recording studio and more. I'll work on getting the pkgbuild updated to reflect this.
For more information:https://github.com/TablePlus/TablePlus-Linux/issues/4#issuecomment-561670001 Davinci resolve studio 14 2 – professional color correction pen.
NoD commented on 2019-12-04 08:45
rew1red commented on 2019-12-03 15:05
I guess libgee is an (unlisted) dependency of tableplus-- I do see it installed on my system, but it's not listed as an upstream dependency. I'll update the pkgbuild in a moment to include it.
NoD commented on 2019-12-03 08:52
Table Plus Linux Server
tableplus: error while loading shared libraries: libgee-0.8.so.2: cannot open shared object file: No such file or directory