Search Results

Search found 22238 results on 890 pages for 'db security'.

Page 89/890 | < Previous Page | 85 86 87 88 89 90 91 92 93 94 95 96  | Next Page >

• How to insert / retrieve a file stored as a BLOB in a MySQL db using python

  - by Phage

  I want to write a python script that populates a database with some information. One of the columns in my table is a BLOB that I would like to save a file to for each entry. How can I read the file (binary) and insert it into the DB using python? Likewise, how can I retrieve it and write that file back to some arbitrary location on the hard drive?

  Read the article

• Get values from DB field into an array with PHP

  - by Adnan

  Hello, I have a field in my DB that holds value separated by commas like; $tmp_list = "COB,ISJ,NSJ," Now when I fetch that the row, I would like to have them in an array. I have used array($tmp_list) but I get the values in one line only like: [0] => 'COB,ISJ,NSJ,' instead of [0] => 'COB', [1] => 'ISJ', [2] => 'NSJ' All help is appriciated.

  Read the article

• Performance & Security Factors of Symbolic Links

  - by Stoosh

  I am thinking about rolling out a very stripped down version of release management for some PHP apps I have running. Essentially the plan is to store each release in /home/release/1.x etc (exported from a tag in SVN) and then do a symlink to /live_folder and change the document root in the apache config. I don't have a problem with setting all this up (I've actually got it working at the moment), however I'm a developer with just basic knowledge of the server admin side of things. Is there anything I need to be aware of from a security or performance perspective when using this method of release management? Thanks

  Read the article

• Saving multiple select form data in db

  - by fl00r

  Hi. I've got form for some model A, which has got few fields: tile description ... colors colors are selected from multiple select and options are ['red', 'green', 'blue', 'yellow']. User can choose colors as many as he wants. I don't think that making Color model and has_many relationship is good solution here to store colors data in model A. So question is: How to store multiple data in db for such multiple select forms?

  Read the article

• DB.Null equivalent in JDBC

  - by Fakrudeen

  Is there an equivalent of (ADO.NET) DB.Null in JDBC? Or do I simply pass null in the parameter? Particularly in the context of Mysql?

  Read the article

• Java class in DB

  - by Debuger

  Hi! Can anyone explain why was idea to store Java class in Db? What it is good for? And how to create stored procedure with Java class? Best regards!

  Read the article

• Databases: Migrate data between MS Access DB and MYSQL

  - by Dean

  Hello, I have 2 databases, one is MS Access DB from an old website, and the other one is MYSQL from the new Joomla+VirtueMart based website. I need to migrate existing products from MS Access to MYSQL. I thought of putting both on server and writing SQL queries in MYSQL workbench, untill I have a good script for that, but I'm very new to SQL, so I'd rather avoid that. I there a better way and more efficient for that?

  Read the article

• Windows Security popup window pops up each time any connection is made

  - by MC Emperor

  I have a problem with the Windows Security popup below. It pops up every time the system tries to make connection with any internet source. It's very annoying, and I don't know how to resolve the problem. (The popup window below is in Dutch, but says something like Connect to somedomain.com. Then it expects you to give your credentials.) I am running on a Windows 7 x64 OS. Now how do I solve this problem? Is it a Windows Firewall problem?

  Read the article

• SimpleDB as Denormalized DB

  - by Max

  In an environment where you have a relational database which handles all business transactions is it a good idea to utilise SimpleDB for all data queries to have faster and more lightweight search? So the master data storage would be a relational DB which is "replicated"/"transformed" into SimpleDB to provide very fast read only queries since no JOINS and complicated subselects are needed.

  Read the article

• Restoring Typus plugin after changing DB Schema

  - by benoror

  I installed Typus plugin (http://intraducibles.com/projects/typus) for my app and I love it. But along the development of the app I frequently do migrations and change the DB Schema and relationships, and then the plugin fails. Is there a way to re-generate the plugin with the new schema? Thanks!

  Read the article

• Which DB (SQL) is better supported in Erlang ?

  - by Konstantin

  Hello! What do you recommend me to use with Erlang -- MySQL or Postgres ? Which DB has better (more mature, more stable, faster) driver for Erlang ?

  Read the article

• Dynamically Insert Variables into DB Table using PreparedStatement

  - by gran_profaci

  I was working with PreparedStatement today and noticed that it used setString() setTimestamp() etc. to insert variables into the DB. I basically have 20 tables each with at least 15 columns and it would not be feasible for me to manuallt write down all the setters. Considering that I have an ArrayList "Vals" which contains all the variables to be inputted in String format (obtained by getString() using PreparedStatement itself), is there any way I can do an insert without using expressly using the Setters? That would save me a lot of time.

  Read the article

• Check if db connection is closed - php

  - by Hamad

  Db connectivity is handled by an include. I want to run this command: mysql_close($con); Only if we currently have a connection. Something like isset()? Thanks Hamad

  Read the article

• Table in DB for generating primary keys?

  - by Sapphire

  Do you ever use a separate table for "generating" artificial primary keys for DB (and why)? What I mean is to have a table with two columns, table name and current ID - with which you could get new "ID" for some table by simply locking the row with that table name, getting the current value of the key, increment it by one, and unlock the row. Why would you prefer this over standard integer identity column? P.S. The "idea" is from Fowlers Patterns of Enterprise Application Architecture, btw...

  Read the article

• How should I access to SQL Server DB?

  - by worlds-apart89

  I have been reading that direct access to a SQL Server database over the Internet is insecure, so I am wondering what intermediary I can and should use between the client and the server. What are the best practices in terms of security and performance?

  Read the article

• How to syncronize merge subscription in Sql Compact DB (on a Mobile device emulator)

  - by Bero

  Using SQL ManagementStudio 2008 I created SQL 3.5 Compact DB (TestCompact.sdf) and I have created subscription to existing Publication. Using SQL Management Studio it is working. I have transfered TestCompact.sdf to Windows Mobile 5 emulator device and with QueryAnalyzer for Mobile I could query existing tables in TestCompact.sdf. I don't know how to start replication synchronization on that mobile device. Do I need to write some C# code or it is possible do it more simple?

  Read the article

• How to store short date format to db?

  - by HelloWorld

  I use NSCoreData , I want to store this formatted date to db, field type is date, how can I do this? date formatted: 2010-10-31 I hope I explained my scenario. Sorry for my English. Greetings.

  Read the article

• Running a sharded DB from a single machine

  - by ming yeow

  This sounds kinda dumb, but I have a sharded DB that I no longer think I need to run on 2 machines, and would like to run on one single machine instead. Any ideas on how that can potentially be done? There are lots of resources on how i can achieve the converse, but very little on how this can be done

  Read the article

• Marking deleted records in DB tables

  - by Emanuil

  Sometimes you want to mark a DB table record as deleted instead of deleting it permanently, right? How do you do that? So far I've been using a boolean "deleted" field.

  Read the article

• Last results submitted in mysql db

  - by Tapha

  How would i get the last 20 results submitted in a mysql db row. I need the 20 most recent user submitted results. Cheers.

  Read the article

• Best password practices?

  - by sansenya

  for sensitive data, would it be better to have a somewhat long, but memorable password (and hence not totally random) or use a program like keepass to make a super long, random password with the highest possible entropy, and then just write down the password on a piece of paper kept in ones pocket. If that bang on the door comes, then swallow the paper. Which is a better security practice? I'm not in any way a criminal, i just am curious about topics concerning security. Thanks.

  Read the article

• Expand my knowledge in DB programming

  - by talgleichger

  Hi there, my name is Tal, Im working on a PHP Application the should have lots and lots of records, what DB should I use, and are there guides on the web that explains how to build efficient dbs and tables? Tnx!

  Read the article

• CodeIgniter: is $_POST already clean for db input?

  - by Shishant

  Hello, This is my first app with CI and I want to know whether $_POST is clean and can I directly insert the data into db? I have enabled $config['global_xss_filtering'] = TRUE; Thank You.

  Read the article

• Spring security and MySQL under CentOS

  - by user223268

  i'm trying to connect to MySQL using spring security, spring should access the database and check the user and pass using direct sql. the problem is when i use localhost to access my local database nothing happen no exceptions no any thing but login fails. if i changed the host of the server to one of my team machine IP address the program login successfully. the only deference is that i'm using CentOS 6.5 and my team is using Windows. how can i make sure i'm configuring MySQL correctly and what privileges should i grand to my users to be able to finish this. note: i'm a newcomer to linux and MySQL server administration.

  Read the article

• Selecting favourites from DB rails 3

  - by Richlewis

  I have a small app which has Users, Recipes, Ingredients and preparation models A user has many recipes, recipes belong to user and ingredients/preparation belongs to recipes. Now a user can view all recipes but I would like the option to add the particular recipe to a favourites list. Would I need to set a new DB to hold this and then link by associations or could I add a column to the recipe model called fav for example? Im looking for the best practice here or if someone has done this before and can offer any advice that would be appreciated

  Read the article

< Previous Page | 85 86 87 88 89 90 91 92 93 94 95 96  | Next Page >